Bug #12713
[SCP ID :##6084##] : Merchant QR Code Error - Decode value Too Short
Status: | Work Completed-End life cycle | Start date: | December 28, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Bal,
Kindly attend below request.
Customer unable to scan the QR code generated to PPK Kluang and CROPRENEUR ENTERPRISE with error "Decode value Too Short". Kindly assist to check on this issue. we attached QR that having issue
Thank you.
History
#1 Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Investigation
#2 Updated by Siti Balqis Othman over 2 years ago
- File Existing Merchant Category Code.png added
- File The Correct Merchant Category code.png added
- Status changed from Investigation to Pending SIT Deployment
- % Done changed from 0 to 100
Root Cause:
After investigating, we found that the saved category code in the database is not correct. The stored category code is 763.
The correct value from the down list is 0763. Based on the stored value, the 0 value is missing at the front.
The missing value 0 at the front is due to Long data type conversion when saved to DB Table.
The solution given are:
1) Change the Long data type to String data type for category code field.
2) Remove long data type conversion.
3) Data patching query to update category code to the correct value and alter column data type.
#3 Updated by Siti Balqis Othman over 2 years ago
- Status changed from Pending SIT Deployment to Work Completed-End life cycle
- Assignee changed from Siti Balqis Othman to Zahir Abd Latif
Hi Zahir,
The fixes has been migrated to production on 05/01/2022 under Migration ID 175.