My Oracle Support Banner

REFRESH_ACCESS_RIGHTS Batch Is Failing In ORM (Doc ID 2658410.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Financial Services Operational Risk - Version 8.0 and later
Information in this document applies to any platform.

Goal

Customer reported issue as REFRESH_ACCESS_RIGHTS batch was failing and below errors were present in logs


[RevappServer.log]
  [REVELEUSLOG] Apr 8,20 21:57:19 : [NONE]Returning acknowledgement ::::::::::::::::::::YBLORINFO_1539951596110_20200407_4~BATCH

[REVELEUSLOG] Apr 8,20 21:57:19 : [NATIVESOCKETCONNECTION]Finished Writing [YBLORINFO_1539951596110_20200407_4~BATCH
] to Native client
[REVELEUSLOG] Apr 8,20 21:57:19 : [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)

[REVELEUSLOG] Apr 8,20 21:57:19 : [NATIVESOCKETCONNECTION][NSockConn] Closing Connection #25

in msg_trace_log
Log Message here 1: Mon 06 Apr 2020 05:31:34 PM IST||INFO||Waiting for new connection ...
Error Msg :-> ORA-02396: exceeded maximum idle time, please connect again

Log Message here 1: Mon 06 Apr 2020 05:31:34 PM IST||SEVERE||WriteToDataBase: Error, Could not execute insert statement ...Error code ...2396...Error message ...ORA-02396: exceeded maximum idle time, please connect again

Log Message here 1: Mon 06 Apr 2020 05:31:34 PM IST||WARN||ThreadMessage::PopFromQ : s_pLogger->Write failed
Log Message here 1: Mon 06 Apr 2020 05:31:34 PM IST||INFO||Message : YBLORINFO_1539951596110_20200406_1: ICC: NOTASKID: ICC_0004: ICC.BATCHMONITOR.BATCH_START: ORMUSER: INFORM: NOMESSAGE
Log Message here 1: Mon 06 Apr 2020 05:31:34 PM IST||INFO||Waiting for new connection ...
Error Msg :-> ORA-01012: not logged on
Process ID: 65396
Session ID: 122 Serial number: 42534
 

Solution

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
Goal
Solution


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