Datanory Production » Datanory - SNEKKU

select * from sync_mobile_token where login_id= 'me3' order by created_date desc--> i notice that user still use the older version 3.2.22.6 no
-- the collection running_ number already fixed on 3.2.22.5
--------------------------------------------------------------------------------------------------------------------------------------------
select created_by,updated_by,* from txn_mobile_collection_header where col_no like '%ME3%' ORDER BY COL_NO DESC
--CCME3000005-240430 --> updated by snekku_Admin
--CCME3000005--> updated_by integration_api
-- jumping number missing --> CCME3000015,CCME3000016, CCME3000017, CCME3000018 ,CCME3000013

------------------------------------------------------------------------------------------------------------------
select created_by,updated_by,* from txn_mobile_collection_header where col_no like '%CCME3000013%' ORDER BY COL_NO DESC--> status approved

select created_by,updated_by,* from txn_mobile_collection_header where col_no like '%CCME3000016%' ORDER BY COL_NO DESC
-- CCME3000016 This collection is in the mobile but not in actual table
select created_by,updated_by,* from txn_mobile_collection_header where col_no like '%CCME3000017%' ORDER BY COL_NO DESC
select created_by,updated_by,* from txn_mobile_collection_header where col_no like '%CCME3000018%' ORDER BY COL_NO DESC
--no data inside
-------------------------------------------------------------------------------------------------------------------------
select * from di_mobile_txn_collection_header where collection_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%'
--> here the doc number is CCME3000013-240625
--> the collection_ id for 13 and 16 are same
select * from di_mobile_txn_collection_header where collection_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%'-- the expeced doc NO= CCME3000016
--> CCME3000013-240625 Why the Doc number is CCME3000013-240625?? CCME3000016-240625?
-- in at_table is CCME3000016-240625
select * from di_mobile_txn_collection_header where collection_id like '%CCME3000017%'--> missing
select * from di_mobile_txn_collection_header where collection_id like '%2ca5a195-3e37-4bca-a5e0-757587ef48c8%'
--> CCME3000013-240625 Why the Doc number is CCME3000015-2406285?? not CCME3000018-240628?
-- in at_table is CCME3000016-240625
--------------------------------------------------------------------------------------------------------------------------
select created_by,updated_by,created_date,updated_date,* from txn_mobile_collection_detail where col_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%'
select created_by,updated_by,created_date,updated_date,* from txn_mobile_collection_detail where col_id like '%CCME3000017%' -- no collection header
select created_by,updated_by,created_date,updated_date,* from txn_mobile_collection_detail where col_id like '%2ca5a195-3e37-4bca-a5e0-757587ef48c8%'

select created_by,updated_by,created_date,updated_date,* from txn_invoice_history_header where invoice_id like '%102F9EECDF0C462EB6DEDC2C9B0D0018%'
select created_by,updated_by,created_date,updated_date,* from txn_invoice_history_header where invoice_id like '%CCME3000017%' -- no collection header
select created_by,updated_by,created_date,updated_date,* from txn_invoice_history_header where invoice_id like '%98E2DA34AEF54821A3335FDA670F8D5F%' OR invoice_id LIKE '%AC260B76BDF14246B7E4DDF05C4E1BA6%'

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select created_by,updated_by,* from txn_mobile_collection_detail where col_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%'
select created_by,updated_by,* from txn_mobile_collection_detail where col_id like '%CCME3000017%' -- no collection header
select created_by,updated_by,* from txn_mobile_collection_detail where col_id like '%2ca5a195-3e37-4bca-a5e0-757587ef48c8%'
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select created_by,updated_by,* from txn_mobile_collection_invoice where col_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%' -- this is Col-13
select created_by,updated_by,* from txn_mobile_collection_invoice where col_id like '%CCME3000017%' -- no collection header
select created_by,updated_by,* from txn_mobile_collection_invoice where col_id like '%2ca5a195-3e37-4bca-a5e0-757587ef48c8%'
---------------------------------------------------------------------------------------------------------------------------------
select * from txn_invoice_history_header where invoice_id= '102F9EECDF0C462EB6DEDC2C9B0D0018'--this is Col-13(Supposed to be 16)
select * from txn_invoice_history_header where invoice_id in( '98E2DA34AEF54821A3335FDA670F8D5F',
'AC260B76BDF14246B7E4DDF05C4E1BA6')--this is CCME3000015-240628( suppose to be CCME3000018-240628)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select col_id,col_no,a.at_date,a.at_type,a.created_by,a.updated_by,* from txn_mobile_collection_header_at a where col_id like '%eba30867-a91a-40ec-8f9c-3ce88c8e8e0b%' ORDER BY a.at_date DESC--> CCME3000013-240625, CCME3000016-240625 --> updated By snekku admin
--select col_id,col_no,a.at_date,a.at_type,a.created_by,a.updated_by,* from txn_mobile_collection_header_at a where col_no like '%CCME3000016%' ORDER BY a.at_date DESC
select col_id,col_no,a.at_date,a.at_type,a.created_by,a.updated_by,* from txn_mobile_collection_header_at a where col_no like '%CCME3000017%' ORDER BY a.at_date DESC-- CCME3000017 there is no changes or update has been done the at_table empty
select col_id,col_no,a.at_date,a.at_type,a.created_by,a.updated_by,* from txn_mobile_collection_header_at a where col_id like '%2ca5a195-3e37-4bca-a5e0-757587ef48c8%' ORDER BY a.at_date DESC --CCME3000018-240628,CCME3000015-240628 updated By snekku_admin
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-- have to check with jann either the Me3 user are in the list,
 -- if the ME3 user is in the list this is due to operational user since user did not clear data in a datanory app

As we check with miss jann we notice that the user has not clear the data

jann, u got any method can check whether user got clear data?

we checked based on their uploaded database

please help to check all, if got not clear data please inform, thanks

if like that need everyone to upload latest database for checking

when this happens, only the first record will jump...the rest subsequent record will be alright

jann, please change the ME3 collection number first ya, thanks

and he/she need to upload database and clear the data

before continue any activity

but need to remind her to clear data after upload all data

but need to remind her to clear data after upload all data