Open Cursor for Cache F04UI001 Failed

[jkiel]

We intalled an ESU and now the P4314 intermittenly gives an error message Open cursor for cache F04UI001 Failed.

Error #1 DDItem:078M ErrLevel:1 errorID:0 File:/OneWorld/Packages/DV900FF18/source/CFIN/b0400047.c line:1921
Alpha Description: Error: Open Cursor for cache F04UI001 failed
Glossary Text: CAUSE . . . . A cursor was not able to be opened because the Cache Init was
not successful or cache F04UI001 was empty.
RESOLUTION. . Verify that the Cache Init was successful and that records
exist in your cache prior to the Open Cursor. Check the
JDE.LOG and JDEDEBUG.LOG for additional information.

Can anybody help.

 

[BOster]

If you have not modified the APPL or BSFNs in question you should report this to Oracle since they would most definitely have a bug.

Opening a cache cursor will fail for the following reasons:

1. The cache has not been initialized.

2. The cache is initialized but is empty. This is not an error condition and cache code should be aware that this could happen and not throw an error unless business logic dictates that the cache should never be empty. Even so, throwing a cryptic cache error message is still bad code.

3. Cache cursor resource leak. In other words, no more available cursors. You are limited to 100 cache cursors for a named cache instance. If cursors are not closed properly this results in a cache cursor resource leak.

Any time you get any kind of cache cursor error that is a bug some place IMO.

 

[cbudoris]

this is an old thread, but we just got this error too. We're on JDE 9.1 apps.

There's an ESU for this error, but its combined with a bunch of other fixes and a medium sized object list: JM12715