I have a query rule that is hitting a very slow view and is timing out. Ultimate

peterh over 10 years ago

I have a query rule that is hitting a very slow view and is timing out. Ultimately we are working on increasing the peformance of the view, but in the short term I need to fix the error. I've increased the conf.data.query.timeout property from 10 to 20 seconds, but that didn't seem to solve the issue. Is there another timeout setting that can be increased somewhere else? We are using Appian 7.2 and JBoss 7.1.1.

Specific error message: org.hibernate.JDBCException: This query did not finish within the timeout period: could not execute query...

Discussion posts and replies are publicly visible

0 Aleksi White
Appian Employee
over 10 years ago

To get some more information about the query rule, add these lines to your appian_log4j.properties, located under <APPIAN_HOME>/ear/suite.ear/resources:

log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.type=TRACE

This will give more verbose information about what exactly is happening with the query rule, which you can check in the server.log
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel