RVR-MSSQL-RDBMS-206

Issue summary

• The error code RVR-MSSQL-RDBMS-206 indicates an issue with the MSSQL Data Connector unable to retrieve the keys for a specified table. This can often result from problems such as incorrect table meta-information, absence of primary or composite keys, or issues with the Change Tracking or Cleanup processes within SQL Server.

Action steps

To resolve the error, follow these steps:

• Verify Key Existence: Ensure that the table in question has primary keys or composite keys defined. Lack of keys will prevent Data Integration from conducting operations that require them.
• Change Tracking: Check if Change Tracking enabled for the database and the specific table. You can do this by running queries against the sys.change_tracking_databases and sys.change_tracking_tables to verify the change tracking settings.
• Inspect Cleanup Processes: Automated cleanup of the Change Tracking data might be happening too frequently, leading to data removal before full synchronization. Monitor and adjust these processes if necessary.
• Review Logs: Analyze the MSSQL server logs for any errors or messages related to the failure in retrieving keys. These logs can offer insights into why the keys are not obtainable.
• Reinitialize Table: If change tracking is a factor, consider reinitializing the table from the Data Integration console to reset synchronization and potentially resolve the issue.

External references

• For additional troubleshooting on SQL Server issues, you can refer to the official Microsoft SQL Server Documentation.
• For detailed Data Integration documentation specifics, refer to SQL Server CDC for further setup and configuration guidelines specific to using MSSQL with Data Integration.

If the issue persists or if these steps do not resolve the problem, open a ticket with Data Integration support to receive more specialized assistance.