LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. 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.

Introduction

When searching a large list of process instances (approximately 100 or more) in the K2 Workspace Management Console - Manage Process Instances page, an error may occur giving a 'timeout expired' message indicating that there are no pool connections available.

Error Scenario Steps

Note: The steps below describe one scenario under which this error may occur. They are simplified and not all steps are shown or described.
  1. Create 100 active process instances
  2. Navigate to the K2 Workspace Management Console "Manage Process Instances" Page.
  3. Refresh the list a couple of times using the Search Button

Error Message

The following error message relates to this issue:
  • “Failed to return Process Instance Data Table: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.”

Error Resolution

This Hotfix is contained within the latest K2 blackpearl 0807 Update. Install the update package to resolve the error.

The latest K2 blackpearl 0807 Update is available as an independent installation package which can be found here: https://portal.k2.com/downloads/bp/default.aspx