RVR-ATH-200

Issue summary

The error code RVR-ATH-200 with the description "Error in query execution result" occurs when there are issues executing queries within Data Integration when connected to Amazon Athena. Possible causes include misconfigurations or permission errors when accessing the relevant data buckets or issues with the queries executed.

Action steps

To resolve the error, follow these steps:

1. Verify Athena configuration:
   • Ensure your Athena connection settings in Data Integration is correctly configured by verifying that the AWS credentials used have the necessary permissions to access the specified S3 buckets and Athena services.
2. Check permissions:
   • Make sure the IAM role or user has the required permissions to perform actions on the buckets associated with Athena, such as querying, creating tables, partitions, etc. This includes permissions like s3:ListBucket, s3:GetObject, athena:StartQueryExecution, among others.
3. Examine Query syntax and data:
   • Verify the SQL queries executed are correct, and the data format in S3 supports the operations. Sometimes syntax errors or incorrect data format (For example, CSV, JSON) can cause query execution failures.
4. Athena Query settings:
   • Check if the Athena settings, such as Workgroup configurations, are correctly set up. Some setups require specifying a Workgroup and ensuring that client-side settings do not override necessary configurations.

External references

• For more details on configuring Amazon Athena with Data Integration, refer to Data Integration Amazon Athena as a target topic.
• For more detailed IAM roles setup, refer to Amazon's Athena permissions topic.

note

If the issue persists or you need further assistance, open a support case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.