Normally, a profile aborts the processing if an error occurs in phase 4 (e.g. due to a constraint violation). You can override this behaviour by setting checkbox Continue with next record on SQL error in phase 2.
In this mode, any pending statements for this record will be ignored and the processing will continue with the statements in the next record. See also system variable VAR_SYS_HAS_SQL_ERROR and VAR_SYS_EXCEPTION_STACKTRACE.
Note: If the checkbox is set, the transaction control value "After all records" does not make sense. See sections “Phase 4” and Transaction control.