Forum Discussion
Query evaluation error after 10 Mins
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.
what about the network? Same subnet?
Yes aboth are in same subnet.
I don't think any issue with oracle.
When i click save and close in Power query editor ""analyzing potential issue step completed quickly in old gateway. But this step running long in new gateway.
