9 Replies Latest reply on Dec 12, 2014 4:00 AM by Mike Jones

    Patch Catalog Error: Error: error on lazy load :  (Caused By: An error occurred while attempting to access the database:  Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

    Benjamin Hawkins

      Hi,

       

      We've just upgraded to BSA 8.5 SP1 and are having issues with Patch Catalog updates.

       

      The catalog is failing on it's update with the following errors:

       

      Error14-Jul-2014 10:27:22, Error: error on lazy load :  (Caused By: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object)))

      Error14-Jul-2014 10:27:22, Error: error on lazy load :  (Caused By: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object)))

      Error14-Jul-2014 10:27:22, Error: lazy loading error : change signature  (Caused By: Unable to load PSC children (Caused By: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object))))

      Error14-Jul-2014 10:27:22Error while add/update patch in depot: hotfix : WindowsServer2003-SP2-KB955069-x86-ENU.exe-MS08-069-en-WINDOWS SMALL BUSINESS SERVER 2003-SP2, , Error: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object))

      Error14-Jul-2014 10:27:22Error while add/update patch in depot: hotfix : WindowsServer2003-SP2-KB949014-x64-ENU.exe-MS08-035-en-WINDOWS SERVER 2003 R2, ENTERPRISE EDITION (X64)-SP2, , Error: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object))

      Info14-Jul-2014 10:27:22Updated metadata information for hotfix : Windows6.0-2008-SP2-KB2621146-x86.msu-MS11-095-en-WINDOWS SERVER 2008, ENTERPRISE EDITION-SP2
      Info14-Jul-2014 10:27:22Catalog update progress is 17% completed. Processing Depot batch 54 : 11/81 completed.
      Error14-Jul-2014 10:27:22Error while add/update patch in depot: hotfix : Windows6.0-2008-SP1-KB958911-x64.msu-MSWU-327-en-WINDOWS SMALL BUSINESS SERVER 2008 (X64)-SP1, , Error: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object))

      Info14-Jul-2014 10:27:22Catalog update progress is 17% completed. Processing Depot batch 12 : 10/147 completed.
      Info14-Jul-2014 10:27:22Executing work item Depot Object Processor WorkItem (batch 39) on application server: job_bmcbsapr10
      Error14-Jul-2014 10:27:22, Error: error on lazy load :  (Caused By: An error occurred while attempting to access the database:

      Message : Cannot get a connection, pool error Timeout waiting for idle object SQLState: null ErrorCode: 0

      (Caused By: Cannot get a connection, pool error Timeout waiting for idle object (Caused By: Timeout waiting for idle object)))

       

      Any help appreciated.

       

      Thanks

      Ben