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 Data Integration. 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 Data Integration 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 Data Integration are correctly configured and that the database is accessible. This includes verifying host, port, username, and password.
   • Data Integration Documentation: Review Data Integration 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 Data Integration official documentation for further information on database connection setup: Data Integration Documentation

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