For EXCEL with some 3 PivotTable Visual Id’s passed Job status returns COMPLETED with Error Type INTERNAL_ERROR. How can i troubleshoot / resolve ?
Included the job status response with some info masked
{
“Arn”: “arn:aws:quicksight:us-east-1::dashboard//snapshot-job/",
“CreatedTime”: “2024-03-18T22:58:30.754Z”,
“ErrorInfo”: {
“ErrorMessage”: null,
“ErrorType”: “INTERNAL_ERROR”
},
“JobStatus”: {
“Value”: “COMPLETED”
},
“LastUpdatedTime”: “2024-03-18T23:00:22.571Z”,
“RequestId”: "",
“Result”: {
“AnonymousUsers”: []
},
“Status”: 200,
“ResponseMetadata”: {
“RequestId”: "****”,
“Metadata”: {},
“ChecksumAlgorithm”: 0,
“ChecksumValidationStatus”: 0
},
“ContentLength”: 403,
“HttpStatusCode”: 200
}
Here is the masked snapshot request
{
“AwsAccountId”: “",
“DashboardId”: “*",
“SnapshotConfiguration”: {
“DestinationConfiguration”: {
“S3Destinations”: [
{
“BucketConfiguration”: {
“BucketName”: "”,
“BucketPrefix”: "report/”,
“BucketRegion”: “us-east-1”
}
}
]
},
“FileGroups”: [
{
“Files”: [
{
“FormatType”: {
“Value”: “EXCEL”
},
“SheetSelections”: [
{
“SelectionScope”: {
“Value”: “SELECTED_VISUALS”
},
“SheetId”: “c9058b08-30b8-4107-9230-9026b92f2590”,
“VisualIds”: [
“82fcf22e-f0a5-4672-8aa9-25b5f1b71436”,
“c5dfa462-381e-4622-b159-fe5eefac2f10”,
“7393b8aa-e17e-4c52-8a68-f5d3493864da”
]
}
]
}
]
}
],
“Parameters”: {
“DateTimeParameters”: [
{
“Name”: “pSpendDate”,
“Values”: [
“2024-02-29T00:00:00+00:00”
]
}
],
“DecimalParameters”: ,
“IntegerParameters”: ,
“StringParameters”:
}
},
“SnapshotJobId”: “******”,
“UserConfiguration”: {
“AnonymousUsers”: [
{
“RowLevelPermissionTags”:
}
]
}
}