Production task failing on UPDATE error

[robterry]

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)

[robterry]

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

[john_wang]

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.

[robterry]

How do I raise an S1 case?

[robterry]

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

[robterry]

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

[john_wang]

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.

[robterry]

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 👇

[Dana_Baldwin]

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