Your WorkflowGen web server occasionally receives a database connection timeout error message

Issue

Your WorkflowGen web server occasionally receives a database connection timeout with the following error message:

Server Error in '/wfgen' Application.

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.

Solution

To resolve this issue, update your WorkflowGen web.config connection string with a minimum and a maximum pool size of 10 and 200 respectively. The suggested maximum pool size can be increased based on your database server activity load.

Example

Data Source=...;User ID=...; Password=....;InitialCatalog=...;Min Pool Size=10;Max Pool Size=200;