RVR-MSS-803

1. Issue Summary

   • The error "Missing columns for parsing. Error Code: RVR-MSS-803" with the Azure SQL data connector typically indicates that the data being received doesn't match the expected schema. This could happen if certain columns that the process expects are not present in the data source or if there's a mismatch in column names or data types.
   • This often arises from schema changes in the source database or incorrect schema mapping in Rivery.

2. Action Steps:

   • Verify Source Schema: Check the schema of your Azure SQL source to ensure that all expected columns are available and correctly named. Make any necessary updates to align the source schema with what Rivery expects.
   • Update Schema Mapping: In Rivery, go to the schema mapping for your River and verify that all expected columns are mapped correctly. If the data source has evolved, you may need to perform "Clear All" and then "Auto Mapping" to update the mapping according to the actual structure.
   • Check for Deprecated Columns: Ensure that any columns that might have been deprecated in the source are removed from the schema mapping.
   • Review Database Permissions: Make sure that the database user in Rivery has permission to access all required fields.

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