Production Ticket(ST) #11776
DAILYFRESH - how at handheld have double cstmr name
1) Check the route for this customer in sql db
2) Found duplicate route for this customer.
3) Remove one of the route.
Root cause: Duplicate route.
None
Description
Hi Technical, Can i know how at handheld have double cstmr name ya? AST17. Please advice
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
- Status changed from Support In Progress to Ticket Resolved
- % Done changed from 0 to 100
- Actual Initial Response set to 22/05/2024
- Resolution updated (diff)
select * from customer where customer_code = 'ASCS0755'
select * from customer_at where customer_code = 'ASCS0755'
select * from customer where customer_id = 'cdbcc68a-d245-4b9c-bfb3-8d6804c98e34'
select* from mst_route where customer_id = 'cdbcc68a-d245-4b9c-bfb3-8d6804c98e34' and date = '2024-05-22 00:00:00.000'
select* from mst_route_at where customer_id = 'cdbcc68a-d245-4b9c-bfb3-8d6804c98e34' and date = '2024-05-22 00:00:00.000'
select * from mst_route_process where customer_id = 'cdbcc68a-d245-4b9c-bfb3-8d6804c98e34' and date = '2024-05-22'
select * from di_RoutePlan_import where org_id = 'A000003' --and customer_code = 'ASCS0755' --process_id = '4fbb2c6e-0652-4dec-8218-85f33b9f6604'
order by created_date desc
select * from di_mobile_txn_salesman_route where customer_id = 'cdbcc68a-d245-4b9c-bfb3-8d6804c98e34'
select * into DMS_Ecosystem_Backup_Table.dbo._mst_route_20240522
from DMS_EcoSystem.dbo.mst_route
--delete from mst_route where route_summary_id = 'b9044f627fe948ec9e4650c81ad57c24'