IBM Support

IBM Clarity Server - Relational templates time out error message

Technote (troubleshooting)


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


Clarity 7.x

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.

Document information

More support for: Clarity 7
Clarity Server

Software version: 7.0, 7.2, 7.2.1

Operating system(s): Windows

Reference #: 1589070

Modified date: 24 July 2013

Translate this page: