RVR-SF-RDBMS-302

1. Issue Summary

   • Error Code: RVR-SF-RDBMS-302 indicates a failure in executing an SQL command within Data Integration platform using the RDBMS data connector. This error generally arises due to issues in the SQL command syntax or connectivity problems between Data Integration and the database. It can occur when there is a syntax error in the SQL statement being executed, missing permissions, or if the database connection settings are incorrect.

2. Action Steps:

   • Verify SQL Command: Check the SQL command for any syntax errors. Ensure all SQL keywords are used correctly and that table/column names are spelled correctly.
   • Check Permissions: Ensure that the user account used in the Data Integration connection has the necessary permissions to execute the SQL command. It should have at least read and write permissions on the relevant database objects.
   • Database Connection: Ensure that the database connection configuration in Data Integration (credentials, host, port, and database name) is correct. You can test this connection to verify it is working properly.
   • Review Logs and SQL Feedback: Check any logs or feedback provided by Data Integration in the console for more detailed error messages or specific pointers on the failed SQL command.
   • Reinitialize Table: If using SQL Server Change Tracking or a similar feature, check for issues like min_valid_version or last_sync_version. You may need to reinitialize the table if synchronization has failed.

3. External References:

   • For further steps on debugging RDBMS connections on Data Integration, refer to the Data Integration documentation.
   • If using specific databases like SQL Server or Oracle, ensure permissions and SQL specifics are managed according to SQL Server Connection Setup and Oracle Connection Setup respectively.

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