Forum Discussion
Query evaluation error after 10 Mins
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.
I would look at this article then to get some deeper diags as to what is going on. Monitor and optimize on-premises data gateway performance | Microsoft Learn
Compare it with the old gateway and look for differences.