SAP Knowledge Base Article - Preview

3195684 - Error: "sql syntax error: incorrect syntax near "("" when realtime records processed by the flowgraph

Symptom

  • Create a realtime task flowgraph with Join Node
  • Execute the flowgraph successfully, initial load records load to target
  • When there is any realtime data records processed by the flowgraph, see error below.
    "e DPApplier ApplierCommon.cpp(00385) : ApplierCommon[8409699] got applier error: ApplierCommon::handleError(): errorNo=153102 errorMsg=exception 153102: Applier failed in index server <Replicationtask_name>::doBatchTxn: exception 153102: Applier failed in index server <Replicationtask_name>::executeTask: sql syntax error: sql syntax error: incorrect syntax near "(": line 1 col 38172 (at pos 38172) (please check lines: ) at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_task.cc:163"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SDI, flowgraph, realtime, Join, cdc, syntax error , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , HAN-WDE-EIM , Flowgraph, RepTasks and other SDA Tools , 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.