RVR-RDBMS-305

1. Issue Summary

   • You encountered the error "Failed to get primary keys from RDBMS" with the error code RVR-RDBMS-305 while using the RDBMS Data Connector in Rivery. The error indicates a failure to retrieve primary keys from the specified relational database management system (RDBMS). This might occur if the tables in the source database do not have primary keys defined, or if there is an issue with the connection permissions or configurations.

2. Action Steps:

   • Check Primary Keys: Ensure that the tables you are trying to access in the RDBMS have primary keys defined. Primary keys are necessary for certain database operations and their absence could trigger this error.
   • Verify Permissions: Confirm that the database user you are using with Rivery has sufficient permissions to access metadata, specifically to view primary key constraints in the tables.
   • Database Connectivity: Make sure that the database connection settings in Rivery are correctly configured and that the database is accessible. This includes verifying host, port, username, and password.
   • Rivery Documentation: Review Rivery's documentation for any specific configuration or setting requirements concerning RDBMS integrations, and verify if your setup meets those requirements.

3. External References:

   • You can refer to Rivery's official documentation for further information on database connection setup: Rivery Documentation

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