Distribution - JDE1 (MOSC)

MOSC Banner

Exiting JDB_OpenView (View: V4211AC) With Failure

edited Jan 12, 2021 2:32AM in Distribution - JDE1 (MOSC) 4 commentsAnswered

Hi,

Batch job is ending intermittently. Log says memory failure because of open handle on the view.

=======================================================================

Below is the log:

-File Open Handle.(V4211AC)

- Failed to allocate memory

- Failed to load table information 

-Exiting JDB_OpenView (View: V4211AC) With Failure.

=======================================================================

1) Report is based on the view V4211AC (Union of F4211 F42119)

2) In the Do section, We have a select, fetch next on the same view V4211AC.

3) Inside this while loop, the developer wrote open handle on the same business view V4211AC.

Memory failure is occurring at this point.

1) Why is the Open handle on the view is failed?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center