Support #12872
[SCP ID :##6206##] : MASALAH SISTEM DI IBAM ( TAK BOLEH DOWNLOAD WELCOME PACK & MEMO TO BRANCH)
| Status: | Work Completed-End life cycle | Start date: | March 18, 2022 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Siti Balqis Othman | % Done: | 100% | |
| Category: | IBAM | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
we received few complaint from branch which they not able to download document for welcome page. page stuck and no response.
Please help to check this urgently as we suspect this issue caused slowness to IBAM since yesterday.
History
#1
Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- % Done changed from 0 to 100
Hi team,
Based on the log we found that the customer was unable to download the document because of a JDBC connection issue. As per below log
[3/18/22 9:27:03:980 SGT] 0000012d SystemOut O [18/03/2022] [09:27:03:980] [ERROR] [JDBCExceptionReporter]:101 - J2CA1010E: Connection not available; timed out waiting for 180 seconds.
[3/18/22 9:27:03:980 SGT] 0000012d SystemOut O [18/03/2022] [09:27:03:980] [ERROR] [JDBCExceptionReporter]:101 - J2CA1010E: Connection not available; timed out waiting for 180 seconds.
[3/18/22 9:27:03:980 SGT] 0000012d SystemOut O [18/03/2022] [09:27:03:980] [ERROR] [IBSSLoggerBase]:242 - Transaction not successfully started
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
at net.penril.ibss.core.hibernate.AdminGroup.getGroupByIdentifier(AdminGroup.java:450)
at com.ib.ibss.common.utils.IBSSNavigationUtil.buildNavigation(IBSSNavigationUtil.java:108)
at com.ib.ibss.controller.actions.ss231_welcome_pack_management.IBSSWelcomeLetterDownloadAction.execute(IBSSWelcomeLetterDownloadAction.java:55)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
Solution:
1) Reduce the db calling to get BIB_COMPANY detail. We will get the details from the view bean. Thus, every time a customer clicks a button download, IB will use data from the view bean instead of calling db to get the company details.
2) Change the query to get the mode type only instead of the whole object for Navigation.
3) Add a function to disable the download button after clicking for 5 seconds. (Kak Ilah request to change it to disable - remove 5 seconds timeout)
This fixes already migrate to production on 18/03/2022. IT team(kak Ilah) success tested download report function and disable button.
Require to monitor the activity.