RVR-RDBMS-401

1. Issue Summary

   • The error code RVR-RDBMS-401 indicates a failure in fetching data via the RDBMS (Relational Database Management Systems) connector in Rivery. This suggests an issue either with the data source access or Rivery configuration settings related to pulling data from the database.
   • Initial diagnosis points towards a possible configuration problem, network connectivity issue, or changes in the database schema that might not have been reflected in Rivery's settings.

2. Action Steps:

   • Verify Credentials and Network: Ensure that the credentials used for connecting to the RDBMS are correct and have not been changed or revoked. Check network connectivity between Rivery and the RDBMS instance.
   • Schema Updates: Verify whether there have been any updates or changes to the database schema, such as renamed tables or fields that Rivery is trying to access.
   • Check Data Connector Configuration: Review the configuration settings in Rivery for the RDBMS connection. Ensure that the specified database, schema, and other settings align with the current database setup.
   • Database Logs: Review logs from the RDBMS server for any indicators of why the data extraction might be failing. This can provide clues if there are permission issues, timeouts, or other error messages.
   • Consult Rivery Documentation: Explore Rivery’s detailed documentation regarding common RDBMS issues and verify if the steps outlined therein are applicable to this error.

3. External References:

   • Rivery Documentation on RDBMS Connector Issues - For detailed guidance on troubleshooting and setting up RDBMS connections.
   • Refer to specific database documentation (e.g., PostgreSQL, MySQL, SQL Server) for insights on connection settings and troubleshooting network or credential issues.

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