RVR-ATH-201

Issue summary

The error code RVR-ATH-201 with the description "Error in query execution result." suggests an issue within the query execution process related to Athena while using the Athena data connector in Data Integration.

Action steps

To resolve the error, follow these steps:

1. Verify Query syntax: Double-check the SQL query syntax executed in Athena. Ensure there are no syntax errors or unsupported SQL features that might cause execution failures.
2. Check table and database permissions: Make sure the necessary permissions are set on the AWS Athena tables and databases accessed. Lack of permissions to read or write data can lead to query execution errors.
3. Validate AWS configuration: Confirm that the AWS credentials and configuration used to connect to Athena are correct. Any misconfiguration in access keys or regions can disrupt connectivity.
4. Inspect data types and formats: Review the data types and formats expected by the Athena query. Mismatched data types or unsupported formats might cause query failures.
5. Review logs: Check the AWS Athena query execution logs for detailed error messages or stack traces that can provide more context on what went wrong.
6. Reattempt query execution: After making necessary corrections, reattempt the query execution to check if the issue is resolved.

External references

For more about Athena configuration and error handling, refer to Amazon Athena, and Data IntegrationAmazon Athena as a target topics.

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.