SAP Knowledge Base Article - Preview

2625315 - DB2 LogReader Adapter - default value of ‘ ‘ (space) is recorded as NULL- insert fails with error


When DB2 source table column is define with default value of '' (space) and such table is replicated, we see error like below in dpserver traces:

ApplierCommon.cpp(00462) : Last exception (76): exception 153102: Applier failed in index server  DP_ReplicationTargetTable::processInsert: exception 153102: Applier failed in index server  DP_ReplicationTargetTable::processBatch: cannot insert NULL or update to NULL: TrexUpdate failed on table 'SRC_BAS:BCA_CN_LINK' with error: constraint NOT NULL violation;checkStringColumn(): found NULL on pos 0;column 'FLG_FIRST_REMAIN', table 'SRC_BAS:BCA_CN_LINK', rc=56 at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/




SAP HANA Smart Data Integration


SAP HANA smart data integration all versions


DB2LogReaderAdapter, DB2ECCAdapter, Applier failed, Cannot insert null, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.