SAP Knowledge Base Article - Preview

2362235 - Initial Load for Replication task fails or flowgraph fails for large source tables or large flat files - SAP HANA Smart Data Integration

Symptom

  • (dberror) 129 - transaction rolled back by an internal error: statement snapshot set failed: access failure to ...
  • (dberror) 2048 - column store error: [2048] "<...>::*.START_REPLICATION": line 5 col 0 (at pos 487): [2048] (range 3): column store error: task framework: [403] internal error: Remote execution error Prefetch timed out.
  • “This replication task needs a long time to be executed. Please check the Data Provisioning Monitoring UI for further status updates.”
  • Initial load fails for a large replication task or flowgraph
  • Indexserver_*.trc shows "[MEMORY_OOM]  Information about current out of memory situation: OUT OF MEMORY occurred.  Failed to allocate ######## byte.
  • InternalError: dberror(CallableStatement.execute): 403 - internal error: "Schema"."Taskname": line 5 col 2 (at pos 86): [403] (range 3) internal error exception: internal error: Remote execution error exception 1000002: Allocation failed ; $size$=262144; $name$=DPServerFramework; $type$=pool; $inuse_count$=1; $allocated_size$=2048; $alignment$=8 


Read more...

Environment

SAP Hana Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

reptask, sdi, replicate, smart data integration, han-dp-sdi, data provisioning, flowgraph, han-dp-sdi, (dberror) 2048 - column store error: [2048] "<...>::*.START_REPLICATION": line 5 col 0 (at pos 487): [2048] (range 3): column store error: task framework: [403] internal error: Remote execution error Prefetch timed out , column store error: task framework: [403] internal error: Remote execution error Prefetch timed out,  Remote execution error Prefetch timed out. , KBA , sdi_improve , 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.