(AI KB) PCS Timeout Error When Logging In/Launching Application

Issue: PCS does not launch and produces an error message mentioning a SQL connection timeout or too many connections.

Error Text Example:

System.AggregateException: One or more errors occurred. ---> System.InvalidOperationException: 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.

Possible Causes:

• User(s) Device Does not have a valid Network Connection - The users PC cannot connect to the DB due to a lack of Network Connection or Invalid Network Permissions 

• Too Many Open Connections – The system has run out of available database connections.

• SQL Server Not Reachable – The server may be offline, blocked by a firewall, or misconfigured.

• Database is Slow – The system may be handling too many requests or running inefficient queries.

Resolution: 

Verify that the user(s) PC does have network access to the SQL Server hosting the PCS Database

1. 1. On the impacted PC - Open Command Prompt and type:

      ping <SQL_SERVER_ADDRESS>

      Note: "<SQL_SERVER_ADDRESS>" Needs to be your SQL Server Address

   2. If you get a response, the server is reachable.

   3. If it fails, the server may be offline or blocked from being accessed.