IBM Clarity Server - Relational templates time out error message

Technote (troubleshooting)


Problem(Abstract)

Clarity templates that use large relational queries will time out after 30 seconds

Symptom

A Clarity 7 template that's using a relational query is giving the following error message:

Clarity.12005
RelationalQuery [RelationalQuery1] failed to execute.

System.Data.SqlClient.SqlException
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Cause

This error occurs when the relational query mentioned in the message (in this case RelationalQuery1) takes longer than 30 seconds to execute

Environment

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.

Rate this page:

(0 users)Average rating

Add comments

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:

2013-07-24

Translate my page

Machine Translation

Content navigation