Production Ticket(ST) #11797
GOLDCREST - why for branch V all end date change to 23/5/24
1) Patch the end date.
Root cause: This happen because due to recently we running the full customer integration to solve the branch and area issue for customer. Standard logic is it will update the customer to user relation based on the salesman assigned to the customer from autocount.
None
Description
may i check why for branch V all end date change to 23/5/24 ? as previouly all set to year 2099
sorry, is all customer under wwv, but add PIC to MCJ
end date should be year 2099
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 Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 24/05/2024
- Resolution updated (diff)
--select * into DMS_Ecosystem_Backup_Table.dbo._customer_to_user_relation_20240524
--from DMS_EcoSystem.dbo.customer_to_user_relation
select * from customer_to_user_relation where org_id = 'goldcrest' and end_date <> '2099-12-31 00:00:00.000' order by end_date desc
--update customer_to_user_relation set end_date = '2099-12-31 00:00:00.000', updated_by = 'Support', updated_date = getdate()
--where org_id = 'goldcrest' and end_date <> '2099-12-31 00:00:00.000'
select b.customer_code, a.customer_id, user_id, count(1) from customer_to_user_relation a
inner join customer b on b.customer_id = a.customer_id
where a.org_id = 'goldcrest'
group by b.customer_code, a.customer_id, user_id
having count(1)>1
order by b.customer_code
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100