Production Ticket(ST) #10965
DailyFresh - @~Jann Yap there's no customer details in the customer database... how come ya?
Job Remark:
Ticket Logged Date:
15/02/2024
Ticket No.:
Related Ticket ID:
Type:
User Enquiry & Clarification
SLA Initial Response:
15/02/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
15/02/2024
Resolution:
Escalated to technical team to further on this escalation.
Root-cause - Back end issue
already create task on the clickUp
https://app.clickup.com/t/86ennc618
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
select login_id, password from member where org_id = 'A000003';
select* from customer where org_id = 'A000003';
--Query to check and the script takeb from my sql profiler
select * from mst_branch where branch_id= 'ECA11890-27BD-4A2B-AFDE-BFD376D39232';
exec sp_WhoIsActive
exec sp_executesql N'spCustomerMasterDataRetriveList @total, @org_id, @member_id',N'@total int,@org_id nvarchar(7),@member_id nvarchar(13)',@total=1,@org_id=N'A000003',@member_id=N'A000003-admin'
#3 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
#4 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to User Enquiry & Clarification
- Actual Initial Response set to 15/02/2024