Skip to main content
Feedback

RVR-MSS-500

Issue summary

The error code RVR-MSS-500 is an internal error related to the Azure SQL data connector on Data Integration platform. This results from multiple issues related to connection setups or database configurations.

Initial diagnosis suggests the issue might be related to change tracking or cleanup processes, which involve the database settings concerning synchronization and data integrity between the source and the river operation.

Action steps

To resolve the error, follow these steps:

  1. Verify change tracking: Ensure that Change Tracking is enabled for the database and tables. You can do this by executing SQL queries to check the current status of Change Tracking.
  2. Review logs: Go through your MSSQL server logs for messages related to change tracking or any issues encountered during river extraction.
  3. Reinitialize tables: If there are issues with last_sync_version, consider reinitializing the table data to reset and attempt synchronizing from a clean state.
  4. Investigate cleanup processes: Examine if the database cleanup settings might be interfering with your data synchronization. Excessive cleanups can remove important change tracking data and disrupt synchronization.
  5. Test the connection: Ensure your Azure SQL connection configuration is correct. Use the "Test Connection" function in Data Integration to verify connectivity.
  6. Allowlist IPs: Check that your Azure SQL server allows connections from Data Integration IP addresses by allowlisting them.

External references

For more information, refer to the following topics:

note

If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.

On this Page