Error Code | 15 |
Error Message | One of the following errors may be displayed: • SOURCE_1 DMS schema has an unmatched field <FieldName> in record <RecordName>. • Error 15 connecting to 'SQL Server 2019': Source connector schema has an unmatched field <FieldName> in record 'R1' • Error 15 connecting to 'Salesforce': Source connector schema has an unmatched field <FieldName> in record 'R1' • Field type mismatch for '<SourceName>' schema record layout '<TableName>' field '<FieldName>' |
Description | This schema mismatch error may be displayed with connectors like Excel 365, SQL Server 2019, Salesforce, and ServiceNow. |
Cause/Solution (1) | Cause: The source table has changed and the schema of newly selected table is not loaded. Solution: Refresh the source connection to load the newly selected table schema: 1. Open the transformation. 2. Select the Source tab. 3. Click Connect. 4. Click the Refresh icon that is displayed above source properties. |
Cause/Solution (2) | Cause: Target table has changed and the new schema does not match with the previous target table. Solution: When Header property is changed after schema is loaded and the field names are different 1. Open the transformation. 2. Select the Source tab. 3. Check the fieldname in the schema. 4. Now set the header correctly. 5. Click Connect. 6. Click the Refresh icon that is displayed above source properties |
Cause/Solution (3) | Cause: The Header property has changed after the schema is loaded and the field names are different. Solution: If you set the Schema Mismatch property to Error, a message is displayed to change your Schema Mismatch property to Use Connection, Match by Name, Connect, and then click Refresh to get the new schema. |
Cause/Solution (4) | Cause: There is a schema mismatch due to change in value of “Use Display Values”. Solution: On the Mapping tab, delete all fields on the target side and re-map the fields. |
Related Information |