IBM Support

"Finished with error ...Query timeout expired" when publishing Data Mart

Troubleshooting


Problem

User publishes a Data Mart. This creates a job in the batch queue. - Afterwards, user opens the batch queue. User notices that the job has 'Finished with Error'. - User double-clicks on the job, to find out what went wrong. This shows 'Query timeout expired' The problem does not affect all publishes. - In one real-life customer example, the following were successful: -- Full Export for one period (1706) -- 2 year’s Incremental Publication for 1 period The following failed: -- 2 year’s Incremental Publication for 6 period’s per batch -- 2 year’s Incremental Publication for 5 period’s -- 2 year’s Incremental Publication for 1 period.

Symptom


Details Section
Query timeout expired

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21999503

Page Feedback