Task #17915: Billing-Ocean TSP Post entry - level-3-support - Redmine

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:

gitlab project trace:

Billing Fix - Discrepancy Found - May 2025

Description

Tasks:
Issues are summarized as per below:

Issue with length of Container Type column being too short
PK_MainTBDInfo Issue
PK_tbl_TBDItems Issue
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}]