When creating a new report, what is the significance of the "timeout" setting?

0 Likes

Problem:

When creating a new report, what is the significance of the "timeout" setting?

Resolution:

ANSWER
----------------------------------
This setting allows you to set a timeout period when executing reports:


The execution time of the query on the database must not last longer than the specified timeout period, otherwise an exception is thrown.

If the timeout period is exceeded you will see the following message in the Data tab of the reports screen:

"Could not execute report query: The query has timed out."


The FrontEnd server log will show the following exception:

"java.sql.SQLException: The query has timed out."


Old KB# 23648
Comment List
Anonymous
Related Discussions
Recommended