SAP Knowledge Base Article - Preview

3018606 - QUEUE trigger-based subscription times out after 20 minutes, no HADP tables created - SAP HANA Smart Data Integration

Symptom

  • Replications error out after about 1200 seconds of starting. Status of the task remains on "starting", the PRESQL operation to QUEUE the subscription will not complete.
  • Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "HANADW"."SUB_VT_SAPSR3_BSIK" QUEUE'. ,exception 71000256: QUEUE: SUB_VT_SAPSR3_BSIK: Failed to add subscription for remote subscription SUB_VT_SAPSR3_BSIK[id = 129054087] in remote source RS_ECC_SDI[id = 129007298]. Error: exception 151050: CDC add subscription failed: RS[RS_ECC_SDI]: Request timed out.
  • There was a blocked thread in the source HANA preventing cleanup of HADP_ tables


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP NetWeaver 7.5

Keywords

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.