Project

General

Profile

Actions
Copy link

Task #15857

closed

FFM Integration issue for TK161

Added by Redmine Admin 7 months ago. Updated about 3 hours ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
03/24/2025
Due date:
03/24/2025
% Done:

100%

Estimated time:
0:00 h
Spent time:
1:30 h
GitLab ID:
2267
GitLab Milestone:
GitLab Ticket Number:
474
GitLab Time Logged:
5400
Lock Timeline Date:
No
gitlab project trace:

Description

Refer to log provided by Nicolas:

ORA-00001: unique constraint (AIRCCS_COMMON.FLIGHTHEADER_UK1) violated
ORA-06512: at "AIRMESSAGES_IMP.PKG_FFM_INTEGRATION", line 381
ORA-06512: at "AIRMESSAGES_IMP.PKG_FFM_INTEGRATION", line 358
ORA-01403: no data found
ORA-06512: at "AIRMESSAGES_IMP.PKG_FFM_INTEGRATION", line 350
ORA-06512: at line 1

RCA: Issue with above is FFM integration is attempting to create the flightheader while it should only have created the leg to the existing flight.

Fix: To modify AIRMESSAGES_IMP.PKG_FFM_INTEGRATION.CREATEIMPORTFLIGHT such that it checks if the flightheader exist, if so, it only created the missing leg.

Fix done and deployed on prod and staging

GitLab Sync Log

[{"id": "18911", "author": "Nirmal Shibchurn", "hours": 0.5, "created": "2025-03-24T06:46:32.802Z", "log_date": "2025-03-24", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-03-24T06:46:32.802Z: 30m-(0.5)h spend at: 2025-03-24", "status": "active", "deleted_by": "", "redmine_entry_id": 7673}, {"id": "18910", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-03-24T06:46:23.574Z", "log_date": "2025-03-24", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-03-24T06:46:23.574Z: 1h-(1.0)h spend at: 2025-03-24", "status": "active", "deleted_by": "", "redmine_entry_id": 7674}]

Actions
Copy link

Also available in: Atom PDF