Skip to main content
Feedback

RVR-RDBMS-301

Issue summary

  • You encountered an error with the code RVR-RDBMS-301 related to the RDBMS data connector in Data Integration. This error description, "Failed to get data on resource," suggests that the system is unable to access or retrieve data from the database resource. This can often occur due to synchronization or setup issues, particularly in environments using SQL Server with Change Tracking enabled.
  • Initial diagnosis indicates the issue may relate to the absence of a valid synchronization version, likely caused by automated cleanup processes within your database settings.

Action steps

To resolve the error, follow these steps:

  • Investigate Change Tracking Configuration:
    • ensure you enable Change Tracking on both your database and the specific tables involved. Use the appropriate SQL queries to verify this configuration.
  • Check for Cleanup Processes:
    • Review the cleanup settings in your SQL Server to ascertain if changes are being cleaned up too frequently, which could delete synchronization data important for the Data Flow's operation. Adjust settings if necessary.
  • Reinitialize Table:
    • If synchronization issues persist, reinitialize the table data within Data Integration by navigating to your Data Flow's Schema and selecting "Set initiate migration for all tables." This will reset the synchronization version.
  • Review SQL Server Logs:
    • Analyze logs for any messages regarding synchronization or other relevant errors. This can provide insights into why data retrieval is failing.
  • Cross-check Concurrent Usage:
    • Ensure that no concurrency issues are present, which can occur if multiple processes are attempting to synchronize data simultaneously. Adjust server or application settings to mitigate such conflicts.

External references

  • Learn more about SQL Server Change Tracking in the Data Integration context here: Data Integration Documentation.
  • For detailed troubleshooting regarding SQL Server's change tracking cleanup processes and configurations, consider checking SQL Server's official documentation or community forums for best practices.
note

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

On this Page