Skip to main content
Feedback

RVR-MSS-803

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 Data Integration.

Action steps

To resolve the error, follow these 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 Data Integration expects.
  • Update Schema Mapping: In Data Integration, 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 Data Integration has permission to access all required fields.
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