Support #8454
[SCP ID :##4556##] : BIB- UNABLE TO LOGIN AS INITIATOR (ID-0202593) BADAN DAKWAH ISLAMIAH AGROBANK(BADIA)
Status: | Closed - End of life cycle | Start date: | May 03, 2018 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | BIB | Spent time: | - | |
Target version: | - |
Description
Hi Stephanie
Please attend this case
Staff unable to login as initiator. Error message: system timed out Time stamp: around 3.00PM Username: bdhribadia Full Name: AZMAN BIN RAMLI Mobile No: 60197232707 Address: BADAN DAKWAH ISLAMIAH AGROBANK BADIA DA UNIT SPI AGROBANK LEBOH PASAR BESAR City: KUALA LUMPUR State: Wilayah Persekutuan - Kuala Lumpur Postcode: 50726 Email Address: azman@agrobank.com.my Role: Initiator User Status: ACTIVE FTL Completed: Yes
History
#1 Updated by Stephanie Sufrapto over 6 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 100
As our conversation, customer retry to login within 15:12 PM, 15:13 PM , 15:14 PM and successfully login and initiate transaction at 15:30PM.
Unable to login issue cause by deadlock issue. As snapshot below.
In other email, we suggest the solution is to watch whether other agrobank staff is accessing database within time of deadlock.
[4/30/18 15:13:04:277 SGT] 0000042e SystemOut O [30/04/2018] [15:13:04:277] [ERROR] [IBPortalWelcomeServices]:527 - Error code : www.agronet.com.my--CBpD-20180430151304
[4/30/18 15:13:04:277 SGT] 0000042e SystemOut O [30/04/2018] [15:13:04:277] [ERROR] [IBPortalWelcomeServices]:527 - Error details : org.hibernate.exception.SQLGrammarException: could not update: [net.penril.bib.core.BibUser#3947]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at com.ib.enterprise.services.ib101_access.IBPortalWelcomeServices.executeWelcome(IBPortalWelcomeServices.java:153)
at com.ib.bib.controller.actions.ib101_access.IBPortalLoginAction.execute(IBPortalLoginAction.java:219)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
#2 Updated by Stephanie Sufrapto over 6 years ago
- Assignee changed from Stephanie Sufrapto to Ahmad Hazri
#3 Updated by Zahir Abd Latif over 6 years ago
- Assignee changed from Ahmad Hazri to Zahir Abd Latif
#4 Updated by Zahir Abd Latif over 6 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.