topic Re: Failed to build update statement in Qlik Replicate

Failed to build update statement

ssrlv — Mon, 24 Feb 2025 11:27:05 GMT

[TARGET_APPLY ]E: Failed to build update statement I am Getting this error in child task as soon as the load is completed. I checked all column names and none are over 30 characters long. Table name is very short. I am getting this error in BATCH apply mode and transactional apply mode? This is only happening for this one table. This is Oracle source and Oracle target version 19c 19.19 put level.

Re: Failed to build update statement

sureshkumar — Mon, 24 Feb 2025 14:21:36 GMT

Hello @ssrlv

Reproduce the issue with TARGET_APPLY set to VERBOSE, why it is failing.

And also, logs are encrypted kindly decrypt the logs to check why the query its failing.

How to Decrypt Qlik Replicate Verbose Task Log Fil... - Qlik Community - 1862114

Please check whether the supplemental logging for all columns is enabled or not?

Regards,
Suresh

Re: Failed to build update statement

ssrlv — Mon, 24 Feb 2025 15:08:47 GMT

There is a primary key for this table, so only the supplemental logging PK columns is enabled. I am reloading the table now with verbose logging on. I will have my Linux admin run the DUMPLOG to decrypt the update statement in the log file for the task if it fails again.

Re: Failed to build update statement

ssrlv — Mon, 24 Feb 2025 16:15:07 GMT

the verbose log showed that the target database was missing the PK index. I created that index and now the table is replicating without errors. Appears the table was dropped and the other indexes were recreated but the PK index was missing.