SAP Knowledge Base Article - Preview

3545725 - Error: cannot insert NULL or update to NULL in the real-time replication of the flowgraph using FileAdapter remote source - SDI

Symptom

  • The source of the flowgraph is the virtual table, which uses FileAdapter remote source.
  • The real-time replication of the flowgraph does not work and throws an exception.
  • exception 153102: Applier failed in index server DP_ReplicationTargetTask::doBatchTxn: exception 153102: Applier failed in index server DP_ReplicationTargetTask::executeTask: start task error:  [2620] executor: plan operation failed;Error executing "INSERT INTO "<schema>."."<target table>" (... cannot insert NULL or update to NULL: TrexColumnUpdate failed on table '<schema>:<target table>' with error: constraint NOT NULL violation;checkIntColumn(): found NULL on pos 0,column '<column>', table '<schema>:<target table>',


Read more...

Environment

SAP HANA Smart Data Integration 

Product

SAP HANA smart data integration 2.0

Keywords

DP agent, ESCAPE_CHAR, TEXT_QUOTES, csv, txt , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

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.