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 Data Integration. This suggests an issue either with the data source access or Data Integration 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 Data Integration 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 Data Integration 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 Data Integration is trying to access.
   • Check Data Connector Configuration: Review the configuration settings in Data Integration 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 Data Integration Documentation: Explore Data Integration’s detailed documentation regarding common RDBMS issues and verify if the steps outlined therein are applicable to this error.

3. External References:

   • Data Integration 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 Data Integration support.