My Oracle Support Banner

XDL - FirmAccountPosition.log does not log the Rejection Records In Main XDL Log. (Doc ID 2763730.1)

Last updated on MARCH 30, 2021

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

While running ingestion job, for 'FirmAccountPosition' task, data loading error does not get logged in XDL-FirmAccountPosition.log, it gets logged into another file called 'firmaccountposition.log'. But for all other files, the XDL errors are getting logged in the main XDL log file and hence not able to capture rejections in database table

 

In XDP-FirmAccountPosition.log,

2021-01-02 14:07:30,805 [main] INFO XDP-FirmAccountPosition - Message 10204: Processing file /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_03.dat
2021-01-02 14:07:30,828 [IngestThread0] WARN XDP-FirmAccountPosition - Message 31100: Record failed validation. Record: [~EH1497732~O~000000000000000.000~~~~~000000000000000.000~~FI~GOVT~~~~~OPC~~~~~~~~~~~~] Reason:
AccountIdentifier [Value Missing]
2021-01-02 14:07:30,830 [IngestThread0] WARN XDP-FirmAccountPosition - Message 31100: Record failed validation. Record: [~EI3230303~O~000000000000000.000~~~~~000000000000000.000~~FI~GOVT~~~~~OPC~~~~~~~~~~~~] Reason:
AccountIdentifier [Value Missing]
2021-01-02 14:07:30,830 [IngestThread0] INFO XDP-FirmAccountPosition - Message 20204: Attempting to acquire database connection
2021-01-02 14:07:30,931 [IngestThread0] INFO XDP-FirmAccountPosition - Message 20207: Acquired database connection
2021-01-02 14:07:31,266 [main] INFO XDP-FirmAccountPosition - Message 10212: Done processing /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_03.dat, Records Processed: 7344, Valid: 7342, Error: 2
2021-01-02 14:07:31,266 [main] INFO XDP-FirmAccountPosition - Message 10204: Processing file /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_01.dat
2021-01-02 14:07:31,301 [main] INFO XDP-FirmAccountPosition - Message 10212: Done processing /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_01.dat, Records Processed: 1163, Valid: 1163, Error: 0
2021-01-02 14:07:31,302 [main] INFO XDP-FirmAccountPosition - Message 10204: Processing file /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_02.dat
2021-01-02 14:07:31,379 [main] INFO XDP-FirmAccountPosition - Message 10212: Done processing /aml/as4/OFSBD/ingestion_manager/inbox/FirmAccountPosition_20201231_US_02.dat, Records Processed: 5952, Valid: 5952, Error: 0
2021-01-02 14:07:31,388 [main] INFO XDP-FirmAccountPosition - Message 10202: Component exited successfully. Start time: 01/02/21 14:06:48, End time: 01/02/21 14:07:31, Execution time: 0 day(s) 00:00:42.788

In firmaccountposition.log

Record 3735: Rejected - Error on table LC_SAILA4FCCM_PRD_04.FIRM_ACCT_POSN.
ORA-00001: unique constraint (LC_SAILA4FCCM_PRD_04.PK_FIRM_ACCT_POSN) violated

Record 4005: Rejected - Error on table LC_SAILA4FCCM_PRD_04.FIRM_ACCT_POSN.
ORA-00001: unique constraint (LC_SAILA4FCCM_PRD_04.PK_FIRM_ACCT_POSN) violated

Table LC_SAILA4FCCM_PRD_04.FIRM_ACCT_POSN:
14455 Rows successfully loaded.
2 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Space allocated for bind array: 434800 bytes(50 rows)
Read buffer bytes: 4194304

Total logical records skipped: 0
Total logical records read: 14457
Total logical records rejected: 2
Total logical records discarded: 0

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.