Project

General

Profile

Actions
Copy link

Task #16114

closed

AirCCS FFM integration - investigate error

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

Status:
Closed
Priority:
Low
Assignee:
-
Start date:
04/23/2024
Due date:
04/24/2024
% Done:

100%

Estimated time:
0:00 h
Spent time:
1:00 h
GitLab ID:
422
GitLab Milestone:
GitLab Ticket Number:
212
GitLab Time Logged:
3600
Lock Timeline Date:
No
gitlab project trace:

Description

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "AIRMESSAGES_IMP.PKG_FFM_INTEGRATION", line 100
ORA-06512: at line 1

FFM content:

=HEADER
RCV,2024/04/24 00:27
=PRIORITY
QN
=DESTINATION TYPE B
INTERNET,MRUCSXH,
INTERNET,EMAILXS,
INTERNET,EMAILXS,
INTERNET,EMAILXS,
INTERNET,EMAILXS,
INTERNET,EMAILXS,
INTERNET,EMAILXS,
=ORIGIN
EMAILXS
=MSGID
200110
=TEXT
FFM/5
1/MK5749/20APR/BOM
MRU
ULD/PMC03866JE
/2
006-29194535BOMSCL/P3K306.8MC1.42T42/CONSOLIDATION C
/LGWMK
/ATLDL
/SCLDL
/L
SCI//T1
239-23975545BOMLHR/T5K1194MC7.04/CONSOLIDATION C/HEA
/LGWMK
/LHRMK
/L
SCI//T1
239-23975394BOMMRU/P31K528.7MC3.12T38/NON HAZ PHARMAC
/L
ULD/PMC0411MK
/1
239-23972793BOMJNB/P33K356.3MC2.10T54/CONSOLIDATION C
/JNBMK
/L
239-23956181BOMJNB/P4K236.8MC1.40T5/ELECTRONICS AND
/JNBMK
/L
239-23975416BOMJNB/T3K377MC2.22/CONSOLIDATION C/HEA
/JNBMK
/L
239-23973294BOMJNB/T3K341.2MC2.01/CONSOLE SHIPMEN/HEA
/JNBMK
/L
239-23975560BOMJNB/T4K60MC0.35/ELECTRICAL GOOD
/JNBMK
/L
239-23975405BOMGRU/T1K1059MC6.25/CONSOLIDATION C/HEA
/JNBMK
/GRUMK
/L
ULD/PMC68105MK
/1
006-60388764BOMBNA/T20K566MC3.34/QUEEN NIGHT STA
/LGWMK
/BNADL
/L
SCI//T1
006-60388790BOMSDQ/T8K224.9MC1.33/ORGANIC CHEMICA
/LHRMK
/SDQDL
/L
SCI//T1
239-23538034BOMMRU/T9K200MC1.18/GENERAL MERCHAN
/L
239-24060186BOMMRU/P7K1116.5MC6.59T10/PLANT MACHINE/HEA
/L
239-23975394BOMMRU/P7K119.4MC0.70T38/NON HAZ PHARMAC
/L
006-29194535BOMSCL/P1K102.2MC0.47T42/CONSOLIDATION C
/LGWMK
/ATLDL
/SCLDL
/L
SCI//T1
ULD/PMC0136MK
/3
239-23975556BOMJNB/P6K1005.8MC5.93T8/ALUMINIUM COLLA/HEA
/JNBMK
/L
MRU
ULD/PMC0423MK
/3
239-23972793BOMJNB/P21K226.7MC1.34T54/CONSOLIDATION C
/JNBMK
/L
239-23956181BOMJNB/P1K59.2MC0.35T5/ELECTRONICS AND
/JNBMK
/L
239-23975556BOMJNB/P2K335.2MC1.98T8/ALUMINIUM COLLA/HEA
/JNBMK
/L
LAST

GitLab Sync Log

[{"id": "15108", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-02-06T07:58:47.536Z", "log_date": "2025-02-05", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-02-06T07:58:47.536Z: 1h-(1.0)h spend at: 2025-02-05", "status": "active", "deleted_by": "", "redmine_entry_id": 7790}]

Actions
Copy link
 #1

Updated by Redmine Admin 7 months ago

  • GitLab Sync Log updated (diff)
Actions
Copy link

Also available in: Atom PDF