Intermittent error running the SQL Query operation

  • KM03103958
  • 26-Feb-2018
  • 30-Apr-2021

Summary

Intermittent error running the SQL Query operation

Question

Receiving the following error:
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
Increasing the pool connection and the pool size the issue is still occuring interrmittently.

Answer

Set the Pooling input to "false"