SAP Knowledge Base Article - Public

2809388 - Truncate checkbox in RepTask doesn't commit before trying to insert the loaded data.

Symptom

  • Truncate checkbox in RepTask doesn't commit before trying to insert the loaded data.
  • The truncate operation creates a lock in the table,
  • After fetching all data from the remote db an insert is tried out,
  • Since the table has a lock due to the truncate operation the task never ends.

Environment

SAP HANA Smart Data Integration

Reproducing the Issue

When running a job which executes a RepTask set with the Replication Behaviour as "Initial load only" and checked with the "Truncate table" checkbox a timeout due to Lock-wait time out exceeded because the truncate didn't commit before trying to insert the new records.

Cause

[Enter your Cause here...]

Resolution

To resolve issues see SAP Note 2640827.

Keywords

SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration , Bug Filed

Product

SAP Analytics Cloud 1.0