Boomi · Data Integration: Amazon Athena
RVR-ATH-200: error in query execution result (Athena)
Short answer
RVR-ATH-200 means a query Data Integration ran against Athena failed, from configuration, bucket permissions or the query itself. Check the S3 and Athena permissions and the SQL.
VerifiedLast verified
01Error text
Error in query execution result. Error Code: RVR-ATH-20002Likely causes
- Configuration issues, permission errors on the data buckets, or the queries themselves.
03How to fix it
- Confirm the AWS credentials can access the S3 buckets and Athena.
- Grant permissions such as
s3:ListBucket,s3:GetObjectandathena:StartQueryExecution. - Check the SQL and that the S3 data format supports the operation.
- Check the workgroup configuration.
04Official documentation
→Related errors
- RVR-ATH-100: error trying to connect to AthenaRVR-ATH-100 means Data Integration could not connect to Amazon Athena, from misconfigured connection settings or missing permissions. Verify the region, workgroup and credentials, and the IAM permissions.
- RVR-S3-100: S3 loading errorRVR-S3-100 is an S3 loading error, usually a permission or configuration problem with the bucket used as a source or target. Check the IAM permissions and the bucket name and path.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Boomi work:Open Boomi jobsBoomi rates and salaries