One or more rows contain values violating non-null, unique, or foreign-key constraints.

We execute SELECT statements successful our .NET 8.0 app via the ODBC operator connected HANA systems and person the mistake connection mentioned successful the taxable line.

Characteristics of the affected system:
- SAP Business One 10.0 mentation for SAP HANA (10.00.260) SP 2408 (64-bit)
- HDBODBC (64-bit) 2.20.22.39682

The occupation lone occurs erstwhile SAP fields are retrieved that person the information benignant NVARCHAR(1) with a default value. For example: OWHS.Locked
SELECT "Locked" FROM "OWHS"

The occupation nary longer occurs for these fields if their information benignant is changed via the CAST command, e.g. to VARCHAR(1).
SELECT CAST("Locked" AS VARCHAR(1)) FROM "OWHS"

In each different systems that are equipped with older SAP Businnes One and HDBODBC versions, this occupation does not occur.

Our workaround:
Disable the observance of constraints, .NET-Code:
DataSet dataSet = caller DataSet { EnforceConstraints = false };
DataTable effect = dataSet.Tables.Add();
ExecuteOnDbCommand(command, commandAction => result.Load(commandAction.ExecuteReader()), setSchemaContext);
return result;