Production Ticket(ST) #11632
SNEKKU - pls verify this user ME5, missing no 5 but duplicate no 4
1) Check the collection in sql database.
2) Found duplicate and missing collection no.
3) Escalate to level 3. https://app.clickup.com/t/86ep9h3jh
4) Release new version, 3.2.21.0
Root cause: User do a collection by confirming it then canceling it, and subsequently do another collection.
None
Description
pls verify this user ME5, missing no 5 but duplicate no 4
- collection
History
#1 Updated by Rashdan Hussin 5 months ago
- Status changed from Assigned To to Support In Progress
select * from member where member_cd = 'ME5'
select * from txn_mobile_collection_header where created_by = '51652691-534C-451D-85CE-5617FE27BFE3' order by col_no
select * from txn_mobile_collection_header_at where col_id = '893c5edd-2868-4ae0-90d2-278c06d668a7'
select * from txn_mobile_collection_header_at where col_id = 'ab7797dc-bb76-4964-9636-c5b7f75f570c'
select * from txn_mobile_collection_header_at where col_no like '%CCME5000005%'
select * from di_mobile_txn_collection_header where org_id = 'snekku' and doc_no like '%CCME5000005%'
#2 Updated by Rashdan Hussin 5 months ago
- Status changed from Support In Progress to Escalated to Level 3
- % Done changed from 0 to 50
- Actual Initial Response set to 05/05/2024
- Resolution updated (diff)
#3 Updated by Rashdan Hussin 5 months ago
- Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen
- Handover to azhar.
- End shift.
- Check the clickup for any update.
- Ask arif or shu ern the root cause and fixes of this issue.
#4 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
Have to do testing on this
#5 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#6 Updated by Rashdan Hussin 5 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
- % Done changed from 50 to 90
- Resolution updated (diff)
#7 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100