eNICQ 6 - "Max pool size was reached" error

Reported Issue: 

eNICQ 6 Users get a message when opening eNICQ 6 which says "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."

image001.png

Root Cause: 

eNICQ 6 has a default of 100 maximum connections to the database. With a database that has many VON Centers added, it could cause the connections to the SQL database to exceed the maximum amount.

Resolution or Workaround:

  1. CLICK HERE to download the eNICQ6ConnectionEditor.zip file (the readme.txt file can be downloaded by CLICKING HERE).

  2. Extract all the files in the zipped folder. You will want to create a folder specifically to extract these files to.

  3. In the extracted files locate the vonEncryptedConnection.dll file and copy it.
    2.png
  4. On the workstation where the eNICQ 6 client is installed go to C:\Program Files (x86)\Vermont Oxford Network\eNICQ 6 and replace the vonEncryptedConnection.dll file with the one copied from the downloaded zip file.

  5. Return to the folder where the zip file was extracted to and locate the enicq6ConnectionEditor file (the Application file) and double-click on it to start the application.

    3.png

  6. When the application starts open the File menu in the top right and select Open.

    4.png

  7. Browse for the Connection.enicq file. The editor will first open C:\ProgramData\VON which is the default location of the Connection.enicq file. Select and open that file.

  8. The database and proxy server information will populate the fields in the eNICQ 6 Connection File Editor. Locate the Max Connections field and increase that to whatever you think will be sufficient. You can always rerun the editor to increase it further if you continue to get the error.

    5.png


  9. Click File again and select Save. Again, it will bring you to C:\ProgramData\VON, the default location of the Connection.enicq file. Overwrite the old Connection.enicq file. The file name must remain "Connection.enicq".

  10. Run eNICQ 6 to make sure that the error is no longer occurring when users log into the program.