RVR-RDBMS-101

1. Issue Summary

   • The error RVR-RDBMS-101 with the message "Failed to close session to RDBMS" indicates an issue with terminating a session properly in the RDBMS using Data Integration data connector. This could be related to the connection management configuration, network issues, or locking issues in the database.
   • This error often arises when there are problems with either the client-side configuration or server-side handling of database sessions.

2. Action Steps:

   • Check Database Connection Configuration: Ensure that your database connection settings in Data Integration are correctly set up, including host, port, database name, username, and password.
   • Connection Pool Settings: Verify if the connection pool settings are correctly configured. Misconfiguration may lead to the failure of closing the session. You might want to adjust pool sizes or test different settings for managing database connections.
   • Network Stability: Ensure network stability between Data Integration and your database. Intermittent connectivity issues can lead to sessions not being closed properly.
   • Database Logs: Check the RDBMS logs for any errors or warnings that might provide insight into why the session is not closing. Look for any indications of transaction or session locks.
   • Session Timeout Settings: Review the session timeout settings on both the Data Integration side and the RDBMS side to ensure they are aligned correctly to handle idle sessions.
   • Reinitialize River: If applicable, consider reinitializing the river to resolve potential sync issues caused by persistent sessions.

3. External References:

   • For more on configuring Data Integration connections, visit: Data Integration Connection Documentation.
   • For handling RDBMS session and connection issues, consult the documentation of your specific RDBMS type, such as PostgreSQL or SQL Server.

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