Support #10093

[SCP ID :##5065##] : BIB not accessible

Added by Zahir Abd Latif about 5 years ago. Updated about 5 years ago.

Status:Work Completed-End life cycleStart date:August 07, 2019
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:BIBSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

Customer complaint BIB was not accessible on 06/08/2019 9:30pm. Based on checking, found that BIB at ibappsvr1 is not responding.
Last log captured 06/08/2019 4.37pm.

Please help to check what is the root cause and provide us propose solution.

History

#1 Updated by Stephanie Sufrapto about 5 years ago

  • Status changed from New - Begin Life Cycle to Work Completed-End life cycle
  • Assignee changed from Stephanie Sufrapto to Zahir Abd Latif
  • % Done changed from 0 to 100

J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/ProdAgroDatasource.
[8/6/19 17:08:45:664 SGT] 00000099 SystemOut O [06/08/2019] [17:08:45:664] [ERROR] [JDBCExceptionReporter]:101 - Connection not available, Timed out waiting for 300003
[8/6/19 17:08:45:664 SGT] 00000099 SystemOut O [06/08/2019] [17:08:45:664] [ERROR] [JDBCExceptionReporter]:101 - Connection not available, Timed out waiting for 300003
[8/6/19 17:08:45:664 SGT] 00000099 SystemOut O [06/08/2019] [17:08:45:664] [ERROR] [IBPortalAccessServices]:527 - Error code : www.agronet.com.my--ADaK-20190806170845
[8/6/19 17:08:45:664 SGT] 00000099 SystemOut O [06/08/2019] [17:08:45:664] [ERROR] [IBPortalAccessServices]:527 - Error details : org.hibernate.TransactionException: Transaction not successfully started

Issue cause by : database connection is slow or lost connection, cause websphere thread is hang there and connection pool is full. After restart application will release all the threads and connection pool.

Please close. TQ

Also available in: Atom PDF