- 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.
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.
[Enter your Cause here...]
To resolve issues see SAP Note 2640827.
SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Bug Filed