2584826 - Remote Subscription Failed to start - Error:exception 153102: Applier failed in index server DP_ReplicationTargetTable::processInsert: exception 153102: Applier failed in index server DP_ReplicationTargetTable::processBatch: not enough values: - SAP HANA Smart Data Integration 2.0 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2584826 - Remote Subscription Failed to start - Error:exception 153102: Applier failed in index server DP_ReplicationTargetTable::processInsert: exception 153102: Applier failed in index server DP_ReplicationTargetTable::processBatch: not enough values: - SAP HANA Smart Data Integration 2.0

Symptom

An existing real-time replication taks which previously had a status of "Replicating changes in real-time" now fails with error below

exception 153102: Applier failed in index server  DP_ReplicationTargetTable::processInsert: exception 153102: Applier failed in index server  DP_ReplicationTargetTable::processBatch: not enough values: :4: line 1 col 42 (at pos 41) at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC5HAPPY_rel_fa~hana2sp00/s/ptime/query/checker/check_insert.cc:34

The following entries can also be seen in the indexserver logs

  • [5957]{-1}[16/11739303] 2018-01-04 02:51:27.721526 e DPApplier        dp_replicationTargetTable.cpp(00899) : Applier failed in DP_ReplicationTargetTable::processInsert exception 153102: Applier failed in index server  DP_ReplicationTargetTable::processBatch: not enough values: :4: line 1 col 42 (at pos 41) at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC5HAPPY_rel_fa~hana2sp00/s/ptime/query/checker/check_insert.cc:34
    [5957]{-1}[16/11739303] 2018-01-04 02:51:27.722215 e DPApplier        dp_replicationManager.cpp(01514) : Exception Row:|'700'|'ACT1'|'A4'|'B1'
  • Applier failed in DP_ReplicationTargetTable::processBatch not all variables bound: unbound parameter : 5 of 5, 1 out of 1 batches at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC5HAPPY_rel_fa~hana2sp00/s/ptime/query/query_param.h:778
  • [5957]{-1}[154/11736991] 2018-01-04 02:03:44.720211 e SQLSessionParam  query_param.h(00777) : unbound parameter : 5 of 5, 1 out of 1 batches

Read more...

Environment

  • HANA Adapter
  • DP Agent 2.2.1
  • SAP HANA Smart Data Integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration , Problem

About this page

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

Search for additional results

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