<{{Subtitle_Weight}} class="prominent-subhead {{Show_Subtitle}}"> {{Header_Subtitle}}

Timeout errors on ProcessOverview

~~repeating-content.html~~
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Issue

The following timeout error appears, when clicking on the Process Overview:

"An error occurred while loading the report. Timeout expired.

The timeout period elapsed prior to completion of the operation or the server is not responding."

Symptoms

The time it takes for the process overview page to open is about 02:13.


After adjusting the service broker command timeout, as well as as the timeout under App settings to 120 seconds, the process overview opens.

The timeout errors were no longer showing after extending the timeouts on the K2hostserver.exe.config

Resolution

The issue was resolved by updating the statistics/indexes on the K2 database.

Please also see below documentation for more information:

http://www.databasejournal.com/features/mssql/sql-server-how-important-are-index-statistics.html