IBM Clarity Server - Relational templates time out error message
Clarity templates that use large relational queries will time out after 30 seconds
A Clarity 7 template that's using a relational query is giving the following error message:
RelationalQuery [RelationalQuery1] failed to execute.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
This error occurs when the relational query mentioned in the message (in this case RelationalQuery1) takes longer than 30 seconds to execute
Diagnosing the problem
1. Create a sample Clarity template that uses one relational query;
2. Make sure the query takes longer than 30 seconds to execute in SQL Server Management Studio;
3. Load the template in the Clarity interface and notice the error message
Resolving the problem
If the query is already optimized and database server / tables / indexes are correctly configured, then you can increase the timeout for this query by adding the TimeOut = "value" keyword in the <RelationalQuery> tag within the .template xml file (either from Studio using the Code view or by manually editing the file).
At this time, it is not possible to modify the timeout in Clarity Studio design view.