Project

General

Profile

Production Ticket(ST) #11040

Snekku - hi @Azhar13 , please assist remove customer 10006_1, not exist in mysoft, thanks

Added by Muhammed Azhar Mohamed Maideen 7 months ago. Updated 7 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
23/02/2024
Due date:
29/02/2024
% Done:

0%

Estimated time:
Spent time:
4.00 h
Job Remark:
Ticket Logged Date:
23/02/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
23/02/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
12/03/2024
Resolution:

already delete the customer names Customer 10006_1 because it not exist in the mysoft. We are requested to deleete

Root cause - operational
-- Already confirmed with client and use claimed this issue was solved.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

History

#1 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Assigned To to Support In Progress

select * from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

select * from customer_to_user_relation where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

select * from mst_customer_contact_address where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
select * from mst_customer_branch where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
select  * into customer240223 from customer;
select  * into customer_to_user_relation240223 from customer_to_user_relation;
select  * into mst_customer_contact_address240223 from mst_customer_contact_address;
select  * into mst_customer_branch240223 from mst_customer_branch;
delete  from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

delete from customer_to_user_relation where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

delete from mst_customer_contact_address where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
delete from mst_customer_branch where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

#2 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • Type set to Support Request
  • Resolution updated (diff)

select * from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

select * from customer_to_user_relation where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

select * from mst_customer_contact_address where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
select * from mst_customer_branch where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
select  * into customer240223 from customer;
select  * into customer_to_user_relation240223 from customer_to_user_relation;
select  * into mst_customer_contact_address240223 from mst_customer_contact_address;
select  * into mst_customer_branch240223 from mst_customer_branch;
delete  from customer where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

delete from customer_to_user_relation where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

delete from mst_customer_contact_address where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';
delete from mst_customer_branch where org_id= 'snekku' and customer_id like '%AF63AD871CAB4687A96871D127D5E34D%';

#3 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Actual Initial Response set to 12/03/2024
  • Resolution updated (diff)

Also available in: Atom PDF