Project

General

Profile

Actions
Copy link

Task #17915

closed

Task #15811: Billing Fix - Discrepancy Found - May 2025

Billing-Ocean TSP Post entry

Added by Redmine Admin 7 months ago. Updated about 1 hour ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
05/26/2025
Due date:
05/30/2025
% Done:

100%

Estimated time:
16:00 h
Spent time:
9:00 h
GitLab ID:
2633
GitLab Milestone:
GitLab Ticket Number:
522
GitLab Time Logged:
32400
Lock Timeline Date:
No
gitlab project trace:
Billing Fix - Discrepancy Found - May 2025

Description

Tasks:
Issues are summarized as per below:

  1. Issue with length of Container Type column being too short
  2. PK_MainTBDInfo Issue
  3. PK_tbl_TBDItems Issue
  4. ImportOriCode being null Issue
SELECT distinct 
CASE 
WHEN errormessage like '%ation of PRIMARY KEY constraint %' AND errormessage like '%PK_MainTBDInfo%' THEN 'PK_MainTBDInfo Issue' 
WHEN errormessage like '%ation of PRIMARY KEY constraint %' AND errormessage like '%PK_tbl_TBDItems%' THEN 'PK_tbl_TBDItems Issue' 
WHEN errormessage like '%Cannot insert%' AND errormessage like '%ImportOriCode%' THEN 'ImportOriCode being null Issue' 
WHEN errormessage like '%The error is: String or binary data would be truncated%' THEN 'Issue with length of Container Type column being too short' 
else errormessage end
FROM [CCS_WAREHOUSING].[dbo].[OceanImp_Integration_Exception]
WHERE JobNumber LIKE 'TSP%'
;

GitLab Sync Log

[{"id": "23898", "author": "Nirmal Shibchurn", "hours": 3.0, "created": "2025-05-28T09:42:04.630Z", "log_date": "2025-05-28", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-28T09:42:04.630Z: 3h-(3.0)h spend at: 2025-05-28", "status": "active", "deleted_by": "", "redmine_entry_id": 9258}, {"id": "24035", "author": "Nirmal Shibchurn", "hours": 3.0, "created": "2025-05-29T09:22:32.312Z", "log_date": "2025-05-29", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-29T09:22:32.312Z: 3h-(3.0)h spend at: 2025-05-29", "status": "active", "deleted_by": "", "redmine_entry_id": 9278}, {"id": "24040", "author": "Nirmal Shibchurn", "hours": 2.0, "created": "2025-05-29T10:17:25.712Z", "log_date": "2025-05-29", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-29T10:17:25.712Z: 2h-(2.0)h spend at: 2025-05-29", "status": "active", "deleted_by": "", "redmine_entry_id": 9279}, {"id": "24045", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-05-29T11:07:31.865Z", "log_date": "2025-05-29", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-29T11:07:31.865Z: 1h-(1.0)h spend at: 2025-05-29", "status": "active", "deleted_by": "", "redmine_entry_id": 9329}]

Actions
Copy link

Also available in: Atom PDF