topic Re: Oracle ODBC Setup In QMC in QlikView

Oracle ODBC Setup In QMC

dclark0699 — Sun, 09 Jun 2019 01:05:03 GMT

Hi all,

process to write a row back to Oracle database worked fine before upgrading to 18c in Qlikview. Now continuously getting

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

User Preferences set to allow read/write, script settings set to allow read/write, mode is write in the connection string, odbc set up does not have the read only box checked.

Not sure what else it could be. Any ideas?

Re: Oracle ODBC Setup In QMC

vireshkolagimat — Sun, 09 Jun 2019 14:15:48 GMT

Hi, Did you made the changes in edit script settings tab?

Re: Oracle ODBC Setup In QMC

dclark0699 — Sun, 09 Jun 2019 15:47:52 GMT

I did check the box on the settings tab in the script editor

Re: Oracle ODBC Setup In QMC

Brett_Bleess — Thu, 11 Jul 2019 13:23:42 GMT

For this one the correct community is going to be the Oracle Community, not Qlik, as the issue is in the Oracle side of things, not Qlik as far as I can tell as the error you are receiving is one we are displaying that is being generated by Oracle and the Oracle connector/driver, so I suspect Oracle has changed something in their driver that likely needs a tweak to the connect string etc.

That being said, have you attempted to recreate the connect string, and more importantly, did you update the Oracle driver on the machine running QlikView as well? Be sure to do that, and once you have updated, then try things again, if that still throws error, I would try to recreate the connection string in the script and hopefully that will then get things working, but if not, I would check Oracle Forums as well for further clues. Sorry I do not have a better answer for you.

Regards,
Brett

Re: Oracle ODBC Setup In QMC

Rehan — Wed, 17 Jul 2019 19:31:16 GMT

Dealing with the same issue here. It works in Desktop though. We upgraded from Qv Server Nov 2017 to Nov 2018