I have a Quicksight dataset that’s been working fine for months pulling data from S3 via a manifest file but all of a sudden all the refreshes started failing with the errors below since yesterday:
FAILURE_TO_PROCESS_JSON_FILE=
Error details:
S3 Iterator: S3 problem reading data
I’ve double checked the manifest file format and the S3 bucket permissions for Quicksight and everything seems fine and nothing has changed on our end for this to suddenly stop working out of the blue…
Manifest file:
{
"fileLocations": [
{
"URIPrefixes": [
"https://s3.amazonaws.com/solar-dash-live/"
]
}
],
"globalUploadSettings": {
"format": "JSON"
}
}
The error I get in the email alert is different and says "Amazon QuickSight couldn't parse a manifest file as valid JSON." However I verified that the above JSON is formatted correctly.
Also, if I create a new dataset with the same manifest file, it will show the data in the preview tool but its just the Refresh that fails so clearly the manifest file is formatted correctly if Quicksight is able to initially pull data from S3 but only fails later.
asked 4 years ago
Is the data in S3 encrypted with a KMS key? I've found I've received similar errors when having encrypted data, and Quicksight didn't have access to the key (either identity based or resource-based denials)
Thanks for the suggestion but I never set it up to be encrypted unless something changed completely on its own. I haven't changed anything in AWS configuration and these errors suddenly began out of the blue. Very strange. I guess I'm just going to have to cave and pay for AWS support.