Support #12819
[SCP ID :##6155##] : session expired :SD IMPEX SDN.BHD. MY0619872 JM BARIANI HOUSE SDN. BHD.
Status: | Work Completed-End life cycle | Start date: | February 22, 2022 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | BIB | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Pelanggan mempunyai dua akaun Agronetbiz, kedua-dua akaun mengalami masalah sama iaitu session expired bila cuba membuat semakan baki . Pelanggan telah clearkan cache dan browsing history . Masalah sama masih berlaku. Mohon VB untuk membuat semakan seperti dibawah
maklumat pelanggan :
1-
Nama Syarikat : SD IMPEX SDN.BHD.
User : asiantaste
2- Nama Syarikat : JM BARIANI HOUSE SDN. BHD.
User : JMbarianihouse
logs: \\172.16.49.2\prod_logs\VPIBKA02\BIB1\jmbariani
History
#1 Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 100
Hi team
Root Cause:
Based on log as below, the ib throws session expired due BIB_ACCOUNT table return more than 1 result when query by account number.
[2/22/22 15:30:54:365 SGT] 0000013c SystemOut O [22/02/2022] [15:30:54:365] [ERROR] [IBAccountSummaryServices]:527 - Error details : org.hibernate.NonUniqueResultException: query did not return a unique result: 2
at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:328)
at net.penril.bib.core.hibernate.AccountDAOImpl.getAccountByAccountNo(AccountDAOImpl.java:606)
at com.ib.enterprise.services.ib102_enquiry.summary.IBAccountSummaryServices.execute(IBAccountSummaryServices.java:234)
at com.ib.bib.controller.actions.ib102_enquiry.summary.IBAccountSummaryAction.execute(IBAccountSummaryAction.java:79)
Expected:
IB expected DB to return 1 result.
Solution:
Added 1 more parameter.
Therefore, IB will retrieve the account details from the BIB_ACCOUNT table based on account number and company id instead of only filtering by account number only.
This is because, based on current BAU flow, 1 account can be paired up with more than 1 company. Which means, multiple cif numbers can be paired with 1 account.
#2 Updated by Siti Balqis Othman over 2 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- Assignee changed from Siti Balqis Othman to Zahir Abd Latif
Migrated to production on 15/04/2022 under Migration ID182