3558337 - Replication Flow Fails Due to NULL Value in Non-Nullable Column - SAP Datasphere

Replication Flow fails with the error below when replicating data from ODP SAPI DataSource to SAP Datasphere.

• "Failed to write data to target due to database error. (SQL error code = 287, SQL error msg = SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: Not nullable "<field_name>" column). Contact the system administrator for the HANA system to address the issue and then resume the replication task."

SAP Datasphere

Run Replication Flow

The source table contains NULL values in key fields, which are incompatible with the target table's non-nullable constraints.

This is a limitation of loading data from ODP SAPI DataSource to SAP Datasphere via Replication Flows.

To address this limitation, please request a feature enhancement for replication functionality, which should allow the selection of custom key fields per object or table during replication. Refer KBA 3332382 for the detailed process.

• KBA 3332382 - How to create an enhancement request for SAP Datasphere?

As an alternative, use CDS Views (standard or custom) to return data from ABAP tables.

KBA 3332382 - How to create an enhancement request for SAP Datasphere?

ODP_SAPI, Datasphere, Replication Flow , KBA , DS-DI-RF , Replication Flows , Product Enhancement