RVR-RDBMS_API-001

1. Issue Summary

   • The error "Failed to execute given query. Error Code: RVR-RDBMS_API-001" indicates a failure when trying to execute a query using Rivery's RDBMS API connector. This error typically arises from issues within the query syntax or compatibility with the API. Common causes may include unsupported SQL features, special characters, or incorrect syntax for the query environment【4:5†source】.

2. Action Steps:

   • Check Query Compatibility: Make sure that the query is compatible with the RDBMS API connector by ensuring it employs only SQL features supported by the API. Avoid using multi-statements or complex SQL logic not supported by the API【4:5†source】.
   • Simplify the Query: If possible, simplify the query by breaking it down into smaller parts to identify the section that might be causing the failure.
   • Review SQL Syntax: Double-check your query syntax to conform with standard SQL syntax for the particular database you are querying.
   • Examine Logs and Error Messages: Review any logs or additional error messages provided by Rivery for more specific information on why the query failed. This might offer direct hints if there's anything specific within the SQL statement causing the error.
   • Test Query Locally: Test the SQL query in a local or native database client environment to verify its syntax and logic independently of the Rivery platform.

3. External References:

   • Rivery Documentation: Rivery Error Codes (this link will take you to more detailed explanations and troubleshooting steps for different error codes).

If the issue persists or you need further assistance, please open a ticket with Rivery support.