Hello!
We encountered a strange issue, one of our queries runs ok from oracle developer but sometimes ago started to fail in Appian. Appian reported it as rule error but in the log there is a timeout. We have it as 30 seconds and from oracle developer the query runs in 1-2 seconds.
What can cause such difference between using query from database tool and from appian?
Discussion posts and replies are publicly visible
If you cannot find another solution, I have found success in the past by using the "Execute Stored Procedure" shared component to execute long-running queries, as that Smart Service is immune to the timeout of queryEntities (though I have never used the function that also comes with the shared component). This will also allow you to bypass the two-step query process that Appian uses and just get the desired rows, which going off what I've read in this post will reduce the time of the query to below the timeout threshold anyway.