topic Re: Production task failing on UPDATE error in Qlik Replicate

Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 09:39:30 GMT

Oracle Source SQL Sever Target
We're running a task in Replicate that has been running for multiple years but started to fail on Saturday morning and we can't establish why - this is impacting our business wide update processes so need some urgent assistance to identify and help us fix the issue

We're not aware of any changes to this existing process

The error messages we are seeing are along these lines

RetCode: SQL_ERROR SqlState: 42000 NativeError: 11501 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The batch could not be analyzed because of compile errors. Line: 1 Column: -1

RetCode: SQL_ERROR SqlState: 42000 NativeError: 264 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The column name 'F_CUS_AMOUNT_OS' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more

more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code. Line: 1 Column: -1 [1022502] (ar_odbc_stmt.c:4011)

Re: Production task failing on UPDATE error

OritA — Mon, 13 Oct 2025 10:16:57 GMT

Hi,

From past experience we've seen this error when the ODBC driver version did not match the Replicate version (in your case version V2022.11.0.746) . Please check that the ODBC driver vesion of ms-sql meets the prerequisite for this release - here is a link to product documentation:
https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/SQL%20Server/prereqs_sql_server_target.htm

In addition - please note that you are running an old version that is out of support. We strogly recommend you to upgrade to latest Replicate version. FYI here is a link to product lifecycle information:

https://community.qlik.com/t5/Product-Lifecycle/Qlik-Replicate-Product-Lifecycle/ta-p/1837201

Regards,

Orit

Re: Production task failing on UPDATE error

john_wang — Mon, 13 Oct 2025 10:25:57 GMT

Hello @robterry ,

Agree with @OritA .
In addition, it’s not only the column F_CUS_ID — all columns appear more than once in the apply SQL statements, which is quite unusual.

I’d suggest trying the following steps:

Stop and resume the task.
If the issue persists, stop the task, restart the Replicate services, and then resume the task.
As a further step, stop all tasks, restart the OS, and resume the task again to see if that helps.

However, as Orit mentioned, upgrading to a supported Replicate version is strongly recommended.

Hope this helps.

John.

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 11:08:03 GMT

Thanks - we don't believe it will be ODBC connected as the processes were running without any issues and nothing has changed in relation to them

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 11:14:44 GMT

We've stopped tasks and restarted replicate services and then resumed tasks, its working on other processes its just the one process relating to the T_SH_Customer table that is causing the issue / failures

Are there any other things we can try ahead of the OS restart as this will have an impact on other processes outside of Replicate

Re: Production task failing on UPDATE error

john_wang — Mon, 13 Oct 2025 12:08:09 GMT

Hello @robterry ,

Could you please share the SQL Server ODBC driver version you’re using?

Personally, I don’t think there’s a better approach than performing an OS restart in this case.

By the way, were there any recent changes in the environment? For example, OS patches or related software upgrades?

Good luck with resolving the issue,

John.

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:25:44 GMT

We applied cumulative patching on the Oracle OCI environment that the process links to on Friday evening (finished by 20:15) but have seen no impacts to any other process that we run via Qlik Replicate (as per the snapshot added to the chat)

It is only the specific update process LD-FULL-APPLY-CRM-TASK that is erroring and then only when hitting a specific table T_SH_Customers that it is causing an error

After the patching was applied this process ran for 12 hours without any issue until it failed on Saturday morning

Because we've seen successful process elsewhere and also this process ran for a period of time without issue we don't believe it is linked to the cumulative patching applied in OCI

Re: Production task failing on UPDATE error

john_wang — Mon, 13 Oct 2025 12:32:53 GMT

Hi @robterry ,

Thanks for the clarification.

I’d suggest opening an urgent support ticket and including the attachment mentioned above.
Our support team will be more than happy to assist you further.

Regards,

John.

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:37:10 GMT

Hi John - can you advise on how we raise an "urgent support ticket"?

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:43:58 GMT

we've tried the Qlik Help section but that isn't very helpful
we've tried "ask a question" but the "support" section of location does allow for any selection of a support area
All in all a very poor user experience

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:44:50 GMT

we've also tried our account management team (who haven't responded as yet) and your phone lines that went straight to answer machine

Re: Production task failing on UPDATE error

john_wang — Mon, 13 Oct 2025 12:49:43 GMT

Hi @robterry ,

>> can you advise on how we raise an "urgent support ticket"?

Please open an S1 case — our support team will be available around the clock to assist you.

Regards,

John.

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:52:03 GMT

How do I raise an S1 case?

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 12:57:34 GMT

I've tried to access the support / create a case via my profile but get the following message

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 13:00:32 GMT

the create case link in my profile takes me to a page that doesn't allow me to create a case

Re: Production task failing on UPDATE error

john_wang — Mon, 13 Oct 2025 13:10:34 GMT

Hi @robterry ,

Not sure if the Live Chat on the Support page works for you, but you could try asking the support team there to open a S1 case on your behalf.

Regards,

John.

Re: Production task failing on UPDATE error

robterry — Mon, 13 Oct 2025 13:14:06 GMT

ve managed to raise a case via the Qlik Bot and got the reference below, but when I try to access the chat I get the assessing message previously posted

Thank you very much! 😀Now that I have collected everything needed, let me create that case for you right now!

Your case has been created successfully! Your case number is: 410713. A member of our Support Team will respond to your issue soon.

You can check on the status or add files and/or images to your case anytime at the Customer Portal linked below 👇

Re: Production task failing on UPDATE error

Dana_Baldwin — Mon, 13 Oct 2025 18:32:31 GMT

Hi @robterry

I see the case is now closed, hope everything is resolved to your satisfaction. For this need in the future this link may help:

How to escalate a support case - Qlik Community - 1713475

Thanks,

Dana