RVR-RDBMS-314

Issue Summary

• The error code "RVR-RDBMS-314" indicates a failure to execute an SQL command using the RDBMS data connector in the Rivery platform. This error can often result from incorrect SQL syntax, missing database connectivity, insufficient permissions, or misconfigured database settings.

Action Steps:

1. Check SQL Syntax

   • Review the SQL command for any syntax errors. Ensure the query follows the correct SQL dialect specific to the RDBMS you are using.

2. Verify Database Connection

   • Ensure that the database connection settings in Rivery, such as host, port, database name, username, and password, are correctly configured. Test the connection to make sure it is active.

3. Review Permissions

   • Confirm that the user associated with the Rivery connection has the necessary permissions to execute the SQL commands. Depending on the operations being performed, appropriate permissions such as SELECT, INSERT, UPDATE, or EXECUTE might be required.

4. Check for Database-specific Requirements

   • Some databases might require specific configurations or modes to be enabled. For instance, if using Oracle, ensure that the necessary privileges for LogMiner are granted if dealing with CDC operations.

5. Review Rivery Setup

   • Ensure that your Rivery pipeline is correctly set up and that no other errors or misconfigurations exist within the Rivery console settings related to your river.

External References:

• For detailed guidelines on setting up Rivery connections and managing permissions, please refer to Rivery's official documentation here.
• Database-specific documentation (e.g., Oracle, PostgreSQL) can provide additional insights into required configurations or permission setups.

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