This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Oct 30, 2012 10:55 AM by Chris1 RSS

Connection Pools fill up for NPD

Trey Explorer
Currently Being Moderated
In 6.0 we used to have an issue were our Connection Pool fills up occasionally. Looks like its happening again in 6.1.

ErrorType: Primary| ErrorCount: 3| App: NPD| SessionId: 7163a4b4-35bb-8916-63d7-db9b54d5b827| UserId: stewartmo| IsNewSession: False| ServerID: 10.31.11.21| Misc: |
Exception: System.Web.HttpException: Error executing child request for /npd/Activity/ActivityEditorPopup.aspx. ---> System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.ConnectionPoolEmptyException: No more connections can be created. They are all being used.

We can check it using : http://pdm2.tyson.com/npd/WebCommon/AdminForms/ConnectionPoolInfo.aspx

The fix is to reset IIS.

Our config is:
<ConnectionPools>
     <ProdikaDB configChildKey="key">
     <config key="MAX" value="100" configOverrideModifier="IsLocked"/>
     <config key="CONNECT_STRING" value="@@VAR:Prodika.DB.URL@@" configAttributeOverrideBehavior="Replace" configOverrideModifier="IsLocked"/>
                    </ProdikaDB>
     <ReportDB copyOf="ConnectionPools/ProdikaDB">
     <config key="CONNECT_STRING" value="@@VAR:Prodika.ReportingDB.URL@@" />
     </ReportDB>
</ConnectionPools>

Do we need to set MAX" value="100" higher?

Edited by: Trey on Oct 9, 2012 11:27 AM
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points