Production Ticket(ST) #10850
SNEKKU - please remove this ya as mysoft just 1 only
Job Remark:
Ticket Logged Date:
26/01/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
11/03/2024
Resolution:
deleted the customer code in the Database.
Root cause- User Enquiry and support request
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
History
#2 Updated by Muhammed Assyafiq Bin Ahmad Kamal 8 months ago
- Assignee changed from Muhammed Assyafiq Bin Ahmad Kamal to Muhammed Azhar Mohamed Maideen
Assign to Azhar to delete this 2 customer from datanory. Reason to delete, customer has remove in mysoft buy our integration only update and insert. Hence deletion currently perform by support manually from back-end.
#3 Updated by Muhammed Azhar Mohamed Maideen 8 months ago
- Status changed from Assigned To to Support In Progress
#4 Updated by Muhammed Azhar Mohamed Maideen 8 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
Backup all four table has been done:
customer_to_user_relation20240126
mst_customer_contact_address20240126
mst_customer_branch20240126
Customer20240126
select * from customer where org_id= 'snekku' and customer_code= '1y410';
select * from mst_customer_branch where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
select * from mst_customer_contact_address where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
select * from customer_to_user_relation where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
DELETE FROM customer where org_id= 'snekku' and customer_code= '1y410';
DELETE FROM mst_customer_branch where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
DELETE FROM mst_customer_contact_address where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
DELETE FROM customer_to_user_relation where customer_id= '90E2AC0AF02F4A8B80DA1F215630E8C8';
-------------------------------------------------------------------------------------------------------------------
select * from customer where org_id= 'snekku' and customer_code= '1y409_1';
select * from mst_customer_branch where customer_id= 'D1594C15CA2B43A6B735163A6B950E49';
select * from mst_customer_contact_address where customer_id= 'D1594C15CA2B43A6B735163A6B950E49';
select * from customer_to_user_relation where customer_id= 'D1594C15CA2B43A6B735163A6B950E49';
DELETE FROM customer where org_id= 'snekku' and customer_code= '1y409_1';
DELETE FROM mst_customer_branch where customer_id= 'D1594C15CA2B43A6B735163A6B950E49';
DELETE FROM mst_customer_contact_address where customer_id= 'D1594C15CA2B43A6B735163A6B950E49';
#5 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 11/03/2024
- Resolution updated (diff)