Support #12620
[SCP ID :##6035##] : Failed update transaction status in DB
Status: | Work Completed-End life cycle | Start date: | November 24, 2021 | |
---|---|---|---|---|
Priority: | Immediate | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | Bug | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Issue: Approver approved transaction but -
1. Transaction enquiry - still showing Pending 0 Approver
2. Transaction receipt - unable to print in CDB
3. Amount deduct from customer account
Cause: Failed to update status from 'Pending Approver' to 'Successful' in DB
History
#1 Updated by Nurul Athira Abdul Rahim almost 3 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2 Updated by Nurul Athira Abdul Rahim almost 3 years ago
- Category set to Bug
#3 Updated by Najmi Pasarudin almost 3 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#4 Updated by Najmi Pasarudin almost 3 years ago
Suggested to JTM to run script DB2 REORG to re-organize the table data to optimize performance.
#5 Updated by Najmi Pasarudin almost 3 years ago
- Status changed from Development / Work In Progress to Pending Prod Deployment
- Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
- % Done changed from 0 to 90
Script sent to Azyan.
Pending approval for production update.
#6 Updated by Najmi Pasarudin almost 3 years ago
Issue:
Some users cannot upload Bulk Payment.
Finding:
Database table Bulk Payment, at column UserId is using datatype SMALLINT. The max value is 32,767. New user with UserId more than that is unable to upload Bulk Payment.
Solution:
Run script to alter table column from SMALLINT to BIGINT.
Script provided to JTM on 14/12/2021. Pending BSN Management approval.
Note:
This issue took a long time due to inconsistent pattern and lack of info in log.
Log only shows failed to insert/update database table without reason.
#7 Updated by Najmi Pasarudin almost 3 years ago
- Status changed from Pending Prod Deployment to Pending Review
Deployed to production on 17/12/2021
#8 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Status changed from Pending Review to Work Completed-End life cycle
- Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif
- % Done changed from 90 to 100