Data application errors occur while the consumer operator is writing data to the database, and include the following common error types.
Cause:
- Row to be INSERTed duplicates an existing row in the target table.
- Row to be UPDATEd or DELETEd does not exist in the target table.
- A DML statement, intended to UPDATE or DELETE one specific row in the target table, actually applies to more than one row in the target table.
When the consumer operator is Load, Update or Stream, source rows causing data application errors are written to standard error tables.
Corrective Action:
For information on assessing row errors, see Accessing and Using Error Tables.