JDE user Cache issue during EditLine processing

[agupta]

We are using the JDE MBFs to create/edit POs in JDE. These MBFs are called from an integration tool that gives JDE adapter.
We have see this error mainly for order with large number of lines (>50).
The error message -
Error-XT4311Z1.F4311EditLine-/OneWorld/Packages/QAFULLD/source/CDIST/b4302180.c-078M-Error: Open Cursor for cache B4302180F125812 failed
Error-XT4311Z1.F4311EditLine-/OneWorld/Packages/QAFULLD/source/CDIST/xt4311z2.c-0001-Error: Action Invalid

We changed the following properties in JDBJ.ini
dataCacheEntrySizeThreshold=-1
dataCacheEntryThreshold=-1

This change did help and the error frequency has gone down.
Any inputs on this issue will be helpful?

 

[BOster]

ini file changes are not going to do anything. You have a jdeCache cursor leak. Basically there is a bug in the bsfn logic some where that is opening up cache cursors and not closing them. You have a limit of 100 cache cursors for every named jdeCache instance.

Oh, there could also be a bug in your integration tool in how it is calling the BSFNs. If you bought an integration tool with a pre-packaged solution then either your vendor has a bug they need to fix or Oracle has a bug they need to fix.

 

[k jacquemyn]

Hi,
We were exploring this forum because we have exactly the same problem in BSFN B4302180. We also work through Webmethods 6.5 with 8.98.3.3 and E1 server W2008/64 bits.
We were wondering if you got finally a solution for this ?

Best regards,

Kris Jacquemyn