Project

General

Profile

Production Ticket(ST) #11676

Goldcrest- Hi pls check, this 2 collection number missing CCWWQ000575-240508, CCWWX001113-240508

Added by Muhammed Azhar Mohamed Maideen 5 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Start date:
10/05/2024
Due date:
13/05/2024
% Done:

0%

Estimated time:
Spent time:
Job Remark:
Ticket Logged Date:
10/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
10/05/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
14/05/2024
Resolution:

1) check in the database in d1, actual and at table

2) check in the mobile db

** this issue has been fixed by technical team and already release.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None


Gc4.jpg (136 KB) Gc4.jpg Muhammed Azhar Mohamed Maideen, 10/05/2024 11:54 AM
GC3.jpg (255 KB) GC3.jpg Muhammed Azhar Mohamed Maideen, 10/05/2024 11:54 AM
GC2.jpg (103 KB) GC2.jpg Muhammed Azhar Mohamed Maideen, 10/05/2024 11:54 AM
GC1.jpg (248 KB) GC1.jpg Muhammed Azhar Mohamed Maideen, 10/05/2024 11:54 AM
GOLDCREST-WWX-2024051012310127.zip (2.86 MB) GOLDCREST-WWX-2024051012310127.zip Muhammed Azhar Mohamed Maideen, 10/05/2024 02:26 PM
GOLDCREST-WWQ-2024051011165871.zip (2.55 MB) GOLDCREST-WWQ-2024051011165871.zip Muhammed Azhar Mohamed Maideen, 10/05/2024 02:26 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCWWQ000575%'
SELECT * FROM di_mobile_txn_collection_header WHERE doc_no LIKE '%CCWWQ000575%'

SELECT * FROM di_mobile_txn_collection_header_at WHERE doc_no LIKE '%CCWWQ000575%'

SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCWWX001113%'
SELECT * FROM di_mobile_txn_collection_header WHERE doc_no LIKE '%CCWWX001113%'

SELECT * FROM di_mobile_txn_collection_header_at WHERE doc_no LIKE '%CCWWX001113%'

I found that there is no respective collection in at_ di_ and actual table in the database

#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Type set to Support Request
  • Actual Initial Response set to 14/05/2024

Also available in: Atom PDF