Project

General

Profile

Production Ticket(ST) #11082

Daily Fresh- customer database empty again, pls resolve this issue. tq

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Start date:
29/02/2024
Due date:
29/02/2024
% Done:

0%

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

We checked backend side the data able to retrieve in the database using SQL profiler as we check. the data able to retrieve. For further checking. This escalation already to escalate to level 3. The issue has been fixed
The Solution is the fixing the store procedure query
Root Cause- Timeout Issue

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

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'

#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
  • Actual Initial Response set to 29/02/2024
  • Resolution updated (diff)

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 Muhammad Arif 7 months ago

please check with technical team the root cause and resolution.

#4 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Resolution updated (diff)

Also available in: Atom PDF