AML Batch Failure (Doc ID 2722363.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

Symptoms

While executing AML batch more than once, the first executed batch has failed in task 124 /OFSAA/FCCM/ficdb/bin/execute.sh,AccountProfile_Trade.

In Task 124 AccountProfile_Trade.log below

2020-10-16 23:37:28,543 [main] INFO : 10209AccountProfile_Trade - Message 10209: Done executing query AccountProfile_Trade
2020-10-16 23:37:28,543 [main] INFO : 10226AccountProfile_Trade - Message 10226: Number of records: 0
2020-10-16 23:37:28,544 [main] INFO : 10225AccountProfile_Trade - Message 10225: Total number of records: 0
2020-10-16 23:37:28,545 [main] INFO : 20208AccountProfile_Trade - Message 20208: Analyzing table OFSAAFCCM.ACCT_SMRY_MNTH partition NULL
2020-10-16 23:41:05,752 [main] INFO : 20209AccountProfile_Trade - Message 20209: Done analyzing table OFSAAFCCM.ACCT_SMRY_MNTH partition NULL
2020-10-16 23:41:05,753 [main] INFO : 10221AccountProfile_Trade - Message 10221: Preprocessing complete in 0.0 seconds
2020-10-16 23:41:05,753 [main] INFO : 10221AccountProfile_Trade - Message 10221: Processing complete in 1.0 seconds
2020-10-16 23:41:05,753 [main] INFO : 10221AccountProfile_Trade - Message 10221: Analyze Table complete in 217.0 seconds
2020-10-16 23:41:05,876 [main] INFO : 10202AccountProfile_Trade - Message 10202: Component exited successfully. Start time: 10/16/20 23:37:24, End time: 10/16/20 23:41:05, Execution time: 0 day(s) 00:03:41.391

--

0 rows loaded.

Task 124 ficgen log below error

[Tue Oct 20 06:46:46 2020 AM +0000][SEVERE][BACKEND][OFSAA][FICGEN] [ICC_UPDATE] : ICC UPDATE FAILED ...
--

In Revappserver.log below error

[20-10-20 06:46:46,252 GMT AM] [DEBUG] [APP] [REVELEUS] [NA] [ICCEVENTHANDLER] Handling ICC Event :BatchrunID [FCCMINFO_AML_BATCH_20201017_1] infoDate [AML] taskID [BATCH] ComponentID [BATCH] taskType [2] status [4]
[20-10-20 06:46:46,252 GMT AM] [ERROR] [APP] [REVELEUS] [NA] [NONE] [NSockConn] Error while reading
java.io.EOFException
at java.io.DataInputStream.readByte(DataInputStream.java:267)
at com.iflex.fic.ficserver.NativeSocketConnection.readString(NativeSocketConnection.java:155)
at com.iflex.fic.ficserver.NativeSocketConnection.run(NativeSocketConnection.java:200)

[20-10-20 06:46:46,252 GMT AM] [ERROR] [APP] [REVELEUS] [NA] [NATIVESOCKETCONNECTION] [NSockConn] Closing Connection #8465
[20-10-20 06:46:46,253 GMT AM] [DEBUG] [APP] [REVELEUS] [NA] [NONE]

In iccserver.log below error

[20-10-20 06:46:46,246 GMT AM] [DEBUG] [APP] [ICC] Query to update batch status: UPDATE batch_run SET v_batch_status = ? WHERE v_batch_run_id = ?
[20-10-20 06:46:46,246 GMT AM] [ERROR] [APP] [ICC] 1603176406246Execute Bind variables query in sync way.........1
[20-10-20 06:46:46,246 GMT AM] [ERROR] [APP] [ICC] 1603176406246Inside Execute Bind variables query in sync way.........
[20-10-20 06:46:46,248 GMT AM] [ERROR] [APP] [ICC] 1603176406246Got back Cargo from FICServer...........
Cargo:[SC:10][ST:1000][SST:0][Oper:0][Version:0][EF:false][D:ficmaster][S:null][U:null][PT:1000][P:null1]
[20-10-20 06:46:46,248 GMT AM] [ERROR] [APP] [ICC] 1603176406246exec1 = 0

Cause

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