Error Code | 15 |
Error Message | Error connecting: TARGET_1 DMS schema record layout 'R1' is missing field <FieldName>referenced in the map schema. |
Description | This error message is displayed for JDBC target connector (Output Mode: Append or DeleteAppend), when the map is run a second time the connector schema and map schema do not match. |
Cause/Solution | Cause: When the map is run a second time the connector schema and map schema do not match. Solution 1: The workaround is to set schema mismatch on the target to “Use Connection, Match by Position”. 1. Click Target tab. 2. Click Target Properties. 3. On Right Panel - Select Schema Mismatch: Use Connection, Match by Position. 4. Save and Run the Map. Solution 2: Ensure that Target field’s name is same as table field name. 1. Click Mapping tab. 2. Browse the Target table. 3. Ensure that Target field’s name is same as table field name. For example, if Target Table Column1 Name: account, but mapping tab shows “Account” as field name, then change “Account” to “account’. 4. Save and Run the Map. |
Related Information |