Invoke StartBusinessProcessing Workflow: Failed to enable constraints. One or more rows contain values violating constraints.

Getting error Invoke StartBusinessProcessing Workflow: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Issue Description

When using database activities version 2022.10.x and running a simple query, using a system-defined DSN, against SAP\HANA using the SAP ODBC driver version 2.20.x the query will fail with the error "Invoke StartBusinessProcessing Workflow: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" even when there is no constraint violation.

Resolution

Downgrade SAP ODBC driver version to 2.19.18.