Question for DSI users on Xe...

swhitmire

Reputable Poster
For those of you using DSI with Xe, what version of DSI are you using, and which function caller (OneWorld or XML)?
We're on SP23_R1 and DSI 4.2.3, and as part of a plan to eventually upgrade to 9, we've recently switched from the OneWorld function caller to the XML function caller, as we understand the OWFC is no longer supported with later versions of JDE. Since the switch, we've encountered a problem with a script that calls ND3N4945 which is run hundreds of times a day by our users... at some point, usually about 24 hours after the last time the TranServer services were restarted, users start getting "Error: fetch from cache failed", and the error "CAC0001017 - (jdeCacheOpenCursor) Attempt to exceed total number of simultaneously open cursors (100) per cache failed" appears in the call object kernel logs. Once this happens to one user, all users start experiencing it within a couple of minutes, and only restarting the TranServer services corrects the issue. Neither DSI nor Oracle seems to have any record of anyone with this particular problem, and we've tried putting that function back to using the OWFC with no success. They've suggested we upgrade to DSI 4.2.4, but I wanted to be sure that there are Xe users using the XMLFC with 4.2.4 before doing that, since apparently that's the point where the code to support the multithreaded kernels in later 8.9x tools releases was added, and it's not clear from the documents we've gotten whether it's still compatible with the Xe kernels. So, any feedback anyone has on what DSI release they're using with Xe would be great (and if anyone happens to have seen our particular error, that would be even better!)
 
Scotti,

We use dcLINK 4.2.5 on OneWorld Xe SP23Y1. We were using 4.2.3 with the standard EO FC while we were on SP 22. When we went to SP23 last year, we changed to the XML FC without much issue.

Also, due to the system latency sensitivity of the RF Gun users, we have an Application server dedicated to the function calls of our TranServer. This way the quick transactions of the guns don't get queued on a jde kernel behind a longer running user process.

We just upgraded from SP3 to SP5 at the end of last month. There is a set of hot fix files that need to be updated after you upgrade to SP5, and a DCLINK database configuration entry that needs to be made.

But, we have now been operating successfully for about a month on 4.2.5 with OW XE 7333 SP23Y1.

Unfortunately, I have not seen the Cache Cursor error, and we are running on SQL Server.
 
Thanks for the information... I was concerned that 4.2.5 might not work with the XML function caller on Xe, so that's very good to know that it does.
 
Once you do get to Tools 8.98.2, you will see that the memory kernel issue has been fixed in that release. But delaying a bit is probably a good idea seeing that we are still working on the scripting error that has Oracle puzzled.
 
Back
Top