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 received does not match the expected schema. This could happen if certain columns that the process expects are not present in the data source or if there is 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 Data Flow and verify that all expected columns map 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 the schema mapping excludes any columns that the source has deprecated.
- 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 help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.