Project

General

Profile

Production Ticket(ST) #11811

GOLDCREST - why the mobile showing this invoice

Added by Rashdan Hussin 4 months ago. Updated 4 months ago.

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

100%

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

1) Check the invoice in sql db.
2) Found already deleted.
3) Created at 27/11/2023 using clt device id.
4) Check at mobile by restore db, the invoice not showing.

Root cause: Invoice created by clt device.

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

None


Description

Hi pls check for this, WWX started use mobile in Feb 2024, why the mobile showing this invoice

History

#1 Updated by Rashdan Hussin 4 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Rashdan Hussin 4 months ago

select * from member where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725'

select * from txn_invoice_history_header where invoice_no = 'INWWX000002-231127'
select * from txn_invoice_history_header_at where invoice_no = 'INWWX000002-231127' order by at_date desc

select * from sync_mobile_token where org_id = 'goldcrest' and login_id = 'wwx' order by created_date
select * from sync_mobile_token where org_id = 'goldcrest' and device_id = 'clt' order by created_date

#3 Updated by Rashdan Hussin 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF