topic SQL Update Statement in QlikView

SQL Update Statement

Rehan — Wed, 17 Jul 2019 19:23:04 GMT

I have a SQL Update statement in my script without any select. We recently upgraded from QV server Nov 2017 to Nov 2018 Release. The app is now failing in QMC but works fine if I load from the Desktop. The error is

"Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1456, ErrorMsg: [Oracle][ODBC][Ora]ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction"

What am I missing here. Why it started doing this after the upgrade.

Re: SQL Update Statement

NadiaB — Sat, 20 Jul 2019 20:12:21 GMT

Hi @Rehan

Please refer to the following article:

Workaround for "Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1456, ErrorMsg: [Oracle][ODBC][Ora]ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction"

Kind Regards.

Re: SQL Update Statement

Brett_Bleess — Mon, 12 Aug 2019 18:22:19 GMT

Rehan, I believe what you need is here:

https://support.qlik.com/articles/000021069

Not sure how things got wiped out on the upgrade though, that is the part that has me a bit puzzled. If this works, be sure to add it to your documentation...

Regards,
Brett