Skip to main content
Feedback

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 Data Integration 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 Data Integration, 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 Data Integration 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 Data Integration Setup

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

External References:

  • For detailed guidelines on setting up Data Integration connections and managing permissions, please refer to Data Integration 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 Data Integration support.