RVR-RDBMS-306

1. Issue Summary

   • The error code RVR-RDBMS-306 in Rivery's Data Connector indicates a failure to retrieve table metadata when using RDBMS connections. This problem may arise due to permission issues, absence of necessary metadata access, or database configuration settings that hinder Rivery's ability to query the database metadata effectively.

2. Action Steps:

   • Check Database Permissions: Ensure that the database user configured in Rivery has adequate permissions to access the metadata of the tables. This typically requires SELECT permissions on the information schema or similar, depending on the specific RDBMS being used.
   • Review Connection Parameters: Verify that all connection parameters are correctly configured in Rivery, including host address, port, database name, and authentication details.
   • Enable Relevant Features: Make sure that features needed by Rivery are enabled in the database. For example, in SQL Server, features like Change Data Capture and Change Tracking may need specific configurations【4:13†source】.
   • Verify Network Accessibility: Ensure that there are no network issues blocking Rivery from accessing your database. This includes checking firewall rules and IP whitelisting.
   • Consult Logs: Review any available logs in Rivery for additional error messages or details that can provide further context on the failure.

3. External References:

   • Rivery SQL Server Configuration
   • Rivery Database Connections

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