RVR-RDBMS-309

1. Issue Summary

   • The error "Failed to submit tasks for schema Error Code: RVR-RDBMS-309" is encountered when using the RDBMS data connector in Rivery. This issue typically arises due to problems with schema synchronization or due to tasks not being able to complete successfully due to configuration issues.

2. Action Steps:

   • Check Schema Configuration:

     • Ensure that the schema configuration is correct in Rivery. Any mismatches or changes in the schema that are not updated in Rivery could cause this issue【4:2†Rivery Documentation 202408 (2).pdf】.

   • Reinitialize the Table:

     • If you suspect schema drift or synchronization problems, try reinitializing the table. This can be necessary if there are issues with the minimum valid version or if last_sync_version is not being received【4:6†Rivery Documentation 202408 (2).pdf】.

   • Review Logs for Issues:

     • Investigate the logs for messages related to change tracking or any issues that occurred during the river execution. This will help in identifying particular problems like synchronization issues or frequent cleanups that might have affected schema operations【4:5†Rivery Documentation 202408 (2).pdf】.

   • Manage Source Table Changes:

     • If there have been structure changes in the source table such as column additions, the system may not automatically update the schema. You need to refresh the capture table and potentially disable and re-enable Change Data Capture (CDC)【4:2†Rivery Documentation 202408 (2).pdf】.

   • Verify Change Tracking:

     • Ensure that change tracking is enabled for both the database and the specific tables involved. Run SQL queries to verify the status of change tracking【4:10†Rivery Documentation 202408 (2).pdf】.

   • Address Concurrency Issues:

     • Ensure that multiple processes are not trying to synchronize with change tracking simultaneously without proper coordination【4:1†Rivery Documentation 202408 (2).pdf】.

3. External References:

   • For more details on setting up and troubleshooting RDBMS data connectors and schema issues in Rivery, please refer to the Rivery Documentation.
   • For issues specific to SQL Server, you might find Microsoft’s documentation on Change Data Capture and Change Tracking helpful Microsoft Change Data Capture Documentation.

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