Production Ticket(ST) #11896
OROMEO - user not able to upload, error show
Job Remark:
Ticket Logged Date:
01/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
01/06/2024
SLA Delivery:
03/06/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
01/06/2024
Resolution:
1) Check the mobile db to know the data problem.
2) Found issue related to price check.
3) Escalate to level 3 (Shanyou).
4) Fix the upload sp.
Root cause: Issue with COALESCE,0).the coalesce function causing the convert to fail.
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
@Arif MCC this user not able to upload, error show at below
User: 120005
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
- Error seems come from price check data type.
- Already escalate to level 3 (shanyou).
- Shanyou said, got issue with the di insert sp, i manual fix in production and uploaded the data using their mobile db
- Issue with COALESCE,0).
- the coalesce function causing the convert to fail.
- He remove then ok already.
- But user side still cannot upload, error persist.
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Ticket Resolved
- % Done changed from 0 to 100
- Actual Initial Response set to 01/06/2024
- Resolution updated (diff)