Oracle MDA Utility issue

NupurSood — Thu, 24 Dec 2020 09:54:46 GMT

Hello All

Am using the Oracle MDA Utility VBO present on DX to execute my Oracle queries and save the results directly to a CSV. The problem is it works fine for the first query run but in case my second query run happens to be on a different connection string, the execution fails and I get the error - 'ORA-00942: table or view does not exist.

If I then go ahead and refresh my process and re-attempt the failed query run, it works just fine. I have a hunch that the previous connection doesn't get closed and the new connection isnt successfully established with the schema when I run the utility in a loop, even though closing any existing connections is a part of set connection action.

Would really appreciate your guidance with respect to the same.

Best

Re: Oracle MDA Utility issue

GeoffHirst — Thu, 15 Apr 2021 14:03:29 GMT

Hi,

I think this question was answered here.

https://community.blueprism.com/network/profile/myaccount/inbox?MailMessageKey=40387143-7a50-4095-8696-6ffb67adcd77&IsFromInbox=True

regards
Geoff Hirst

topic Re: Oracle MDA Utility issue in Digital Exchange

Oracle MDA Utility issue

Re: Oracle MDA Utility issue