Qlik Replicate task fails with failed executing truncate table statement

narendersarva — Mon, 22 Dec 2025 13:56:49 GMT

A Qlik Replicate task fails with the error:

[TARGET_APPLY ]I: Failed executing truncate table statement: TRUNCATE TABLE "PAYOR_DW"."attrep_changesBF9CC327_0000069" [1020403] (oracle_endpoint_load.c:856) 00006000: 2025-09-27T18:41:59 [TARGET_APPLY ]I: ORA-03135: connection lost contact Process ID: 19637 Session ID: 1905 Serial number: 3972 [1022307] (oracle_endpoint_load.c:862) 00006000: 2025-09-27T18:41:59 [TARGET_APPLY ]I: Failed to truncate net changes table [1022307] (oracle_endpoint_bulk.c:1162) 00006000: 2025-09-27T18:41:59 [TARGET_APPLY ]I: Error executing command [1022307] (streamcomponent.c:1987) 00006000: 2025-09-27T18:41:59 [TASK_MANAGER ]I: Stream component failed at subtask 0, component st_0_PCA UAT DW Target [1022307] (subtask.c:1474)

Resolution

The issue is that there is a database-level trigger to monitor drop/truncate and alter statements by name "TSDBA.AUDIT_DDL_TRG" which is currently invalid.

A possible fix is to validate this trigger and also add logic in this trigger to not consider attrep_changes% tables, as this is just a temp table for Qlik Replicate batch processing.

Environment

Qlik Replicate

article Qlik Replicate task fails with failed executing truncate table statement in Official Support Articles

Qlik Replicate task fails with failed executing truncate table statement

Resolution

Environment