Project

General

Profile

Production Ticket(ST) #11824

SNEKKU - hi @Azhar13, why web not shown CCMS0000008?

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
27/05/2024
Due date:
29/05/2024
% Done:

100%

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

Same issue with http://124.217.245.100:90/redmine/issues/11837

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

None

Description


WhatsApp Image 2024-05-27 at 11.24.21_e043aa8f.jpg (150 KB) WhatsApp Image 2024-05-27 at 11.24.21_e043aa8f.jpg Muhammed Azhar Mohamed Maideen, 27/05/2024 12:05 PM
WhatsApp Image 2024-05-27 at 11.24.28_fe6ab9c0.jpg (59.3 KB) WhatsApp Image 2024-05-27 at 11.24.28_fe6ab9c0.jpg Muhammed Azhar Mohamed Maideen, 27/05/2024 12:05 PM
Check collection upload.txt (18.2 KB) Check collection upload.txt Rashdan Hussin, 27/05/2024 11:20 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

select * from di_mobile_txn_collection_header where doc_no like '%CCMS0000008%'

select * from txn_mobile_collection_header_at where col_no like '%CCMS0000008%'

as I check the Collection is is di table and did not able to flow into the actual table need to run script and find the root cause on why it did not flow into the actual table

#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin

#3 Updated by Rashdan Hussin 4 months ago

  • Subject changed from Snekku - hi @Azhar13, why web not shown CCMS0000008? to SNEKKU - hi @Azhar13, why web not shown CCMS0000008?
  • Status changed from Assigned To to Support In Progress

select * from customer where customer_code = '5S009'
select * from member where member_cd = 'MS0'

select * from di_mobile_txn_collection_header where doc_no = 'CCMS0000008-240523'
select * from txn_mobile_collection_header where col_no = 'CCMS0000008-240523'
select * from txn_mobile_collection_header_at where col_no = 'CCMS0000008-240523'
select * from txn_mobile_collection_detail where col_id = '388fc971-ae7f-41bd-94b3-b05f9e4a8e44'

select * from txn_invoice_history_header where invoice_id = 'D7B3FB90B928456CB5C2B68CACC4FF45'
select * from txn_mobile_collection_invoice where inv_id = 'D7B3FB90B928456CB5C2B68CACC4FF45'

select * from txn_invoice_history_header where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F'
select * from txn_invoice_history_header_at where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F' order by at_date
select * from txn_mobile_collection_invoice where inv_id = 'DD8EEAA6D917460BB8EC1829B591B35F'

- Data insert into di table, but not actual table

#5 Updated by Rashdan Hussin 4 months ago

select * from customer where customer_code = '5S009'
select * from member where member_cd = 'MC2'

select * from di_mobile_txn_collection_header where doc_no like '%CCME1000019%'
select * from txn_mobile_collection_header where col_no like '%CCME1000020-240520%'
select * from txn_mobile_collection_header_at where col_no like '%CCMS0000008%'

--CCME1000019, CCME1000020, CCMS0000008, CCMS2000033 have in di

--CCME1000019
select * from txn_invoice_history_header where invoice_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423'
select * from txn_invoice_history_header_at where invoice_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423' order by at_date
select * from txn_mobile_collection_invoice where inv_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423'
select * from txn_mobile_collection_header where col_id = '2273FD6F576F4EC68B6E0ED85C00FFFC' --CN23/007494 cancel

select * from txn_invoice_history_header where invoice_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC'
select * from txn_invoice_history_header_at where invoice_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC' order by at_date
select * from txn_mobile_collection_invoice where inv_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC'
select * from txn_mobile_collection_header where col_id = 'E0228684148E47A5BB4FF7B85846C3CE' --CN23/009289 cancel

--CCME1000020 okay but same process id with CCME1000019

--CCMS0000008
select * from txn_invoice_history_header where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F'
select * from txn_invoice_history_header_at where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F' order by at_date
select * from txn_mobile_collection_invoice where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc'
select * from txn_mobile_collection_invoice_at where inv_id = 'DD8EEAA6D917460BB8EC1829B591B35F' order by at_date
select * from txn_mobile_collection_header where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc'
select * from txn_mobile_collection_detail where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc' --CN24/002270

--CCMS2000033
select * from txn_invoice_history_header where invoice_id = '3B0C6E99E2DB43D19830F61B72DF838F'
select * from txn_invoice_history_header_at where invoice_id = '3B0C6E99E2DB43D19830F61B72DF838F' order by at_date
select b.col_no, c.invoice_no, * from txn_mobile_collection_invoice a
inner join txn_mobile_collection_header b on b.col_id = a.col_id
inner join txn_invoice_history_header c on c.invoice_id = a.inv_id
where a.inv_id = '3B0C6E99E2DB43D19830F61B72DF838F'
select * from txn_mobile_collection_header where col_id = '54a1a28d-390d-4c83-81e2-2d37560155aa' --CCMS2000022 cancel

select * from stg_accounting_import_collection where doc_no like '%CCMC2000010%'

#6 Updated by Rashdan Hussin 4 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • % Done changed from 0 to 100
  • Type set to Support Request
  • Actual Initial Response set to 27/05/2024
  • Resolution updated (diff)

Also available in: Atom PDF