Qlik Replicate task fails with failed executing truncate table statement

[narendersarva]

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