Support #6333
[SCP ID :##3177##] : VB CHECKER UNABLE TO APPROVED CREATE BIB USER.
Status: | Closed - End of life cycle | Start date: | June 09, 2016 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | IBAM | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:
Please help to check and fix this issue:
VB Checker unable to approved BIB user being created by VB Maker. Once clickthe “Tracking ID” error message displayed.
History
#1 Updated by Yap Kah Yan over 8 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Pending logs files at 09/06/2016 @ 9:40 am to 10.30 am
Tried to replicate issue using production instance, no issue.
#2 Updated by Yap Kah Yan over 8 years ago
After checking the new logs (15/6). We found this error when retrieving account number of user.
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
Suggested solution is to delete one of the duplicate account numbers.
select company_name FROM BIB_COMPANY where company_id in (select COMPANY_ID from BIB_ACCOUNT where ACCOUNT_NO in (
select ACCOUNT_NO from BIB_ACCOUNT
group by ACCOUNT_NO
having count (ACCOUNT_NO) > 1
));
select ACCOUNT_NO from BIB_ACCOUNT
group by ACCOUNT_NO
having count (ACCOUNT_NO) > 1;
#3 Updated by Yap Kah Yan over 8 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
The following accounts have more than 1 record. Affected companies are ZS ARMIN SDN BHD and
SMART F.V. MARKETING SDN BHD. Please delete duplicate account numbers.
select * from BIB_ACCOUNT where ACCOUNT_NO in ('3007021000030915','3007021000031835','3007021000032815', '3007021000033247', '3007161000011595');
delete from BIB_ACCOUNT where oid in ('<acc_oid>');
acc_oid = oid of account to be deleted.
#4 Updated by Zahir Abd Latif about 8 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
- % Done changed from 0 to 100
Issue closed in SCP.