Datanory Production » Datanory - GOLDCREST

Hi @~Suzanne , noted on the escalation. We will check on it and revert back in soonest possible.

hi @~Suzanne , can we remote to your anydesk?

select * from txn_mobile_collection_invoice where col_id= '04d4dd14-409b-4f60-b391-83bd568a4545'
select * from txn_mobile_collection_invoice_at where col_id= '04d4dd14-409b-4f60-b391-83bd568a4545' order by at_date desc
select * from txn_invoice_history_header where invoice_id= 'E57C4689985B4F02A2459092B453DDA0'
select * from txn_invoice_history_header_at where invoice_id= 'E57C4689985B4F02A2459092B453DDA0' order by at_date desc
select * from txn_mobile_collection_header where col_no like 'ccmcj000285-240515%'
select * from txn_mobile_collection_header_at where col_no like 'ccmcj000285-240515%' order by at_date desc
select * from txn_mobile_collection_detail where col_id like '4a3b3f7f-f013-4a99-917c-a07f9ad80eff%'
select * from txn_mobile_collection_detail_at where col_id like '4a3b3f7f-f013-4a99-917c-a07f9ad80eff%' order by at_date desc
select * from txn_invoice_history_header where invoice_id in ('956ee005-0174-42a8-8203-5ad567a104aa'
,'c4edcd76-2e92-48ef-b5b2-193dc90b525a')

Hi arif
As I checked from the database the sync date is nul.
Need to check further on this
As I checked could not find the root cause
Please assist on this ticket
already attached database
Handover to arif
End shift

follow up