Forum Discussion
Query evaluation error after 10 Mins
Hi All,
I have two gateway server . One is old gateway server and other one is new gateway server. Old gateway server reside on Windows 2012 and new gateway server running on windoes 2022. Old gateway server we have installed Oracle 11g instant client and for new gateway server we have installed oracle 21c client.
We are running the queries in Powebi online . We are connecting oracle database .
The query is running fine on old gateway but when i run the same query using new gateway after 10 mins its end with
"Oracle: ORA-01013: user requested cancel of current operation;ORA-02063: preceding line from" error.
Per Query Timeout: 10 minutes value imapcting new gateway query run? In this why its not impacting old gateway server?
Any idea? Please help me.
5 Replies
It may be the new gateway is on a machine with less RAM or resources, so it is taking longer to do additional work in your query, and Oracle gives up after 10min. What are the differences in the machines? RAM, disk speed, CPU speed, etc.?
Thanks for replying.
Old server ; RAM 8 GB and 4 Processors
New Server: RAM 16 GB and 6 Processors
New Server hardware configuration is good comapre to old one. Validate query is completed quickly in power query editor using old gateway server but when i am using new gateway its cancelled after 10 Mins
What about the network? Same subnet? Any other filters or firewalls on the network that the old gateway was excluded from but the new one is hitting against? Could be an Oracle config, or general network setting your IT team could assist with.
