Multi Threaded Kernel Issue When Upgrading To EnterpriseOne Tools Release 8.97.2.0
We ran into an issue when upgrading our EnterpriseOne Tools Release from 8.96.1.5 to 8.97.2.0.
In order for the multi-threaded kernels to run correctly there is a setting in the JDE.INI file that needs to be set, SQLServerMode.
The error that I was getting was like the following:
ConnectDB:Unable to connect to DS ‘XXXXXXX – 811 Server Map’ in DB ‘XXXXXXX – 811 Server Map’ on Server DB ‘XXXXXXX’ via ‘L’ with Commitment ‘N’.
The solution indicated by Global Support was not available to me but the number is 201075487. Below is the solution text that he sent:
On the Enterprise Server AS/400 JDE.INI, in the [DB SYSTEM SETTINGS] stanza, there is a default setting: SQLServerMode=N.
For Multi Threaded Kernels to start and work, this setting needs to be Active or set to Y. After adding the line to the stanza and setting it to Y, the customer was able to use Multi Threaded Kernels and the error disappeared.
I was unable to find the setting in Server Manager.
So, if you can find it, let me know.
Author
Stewart Schatz
More Stories
Quick Tip: IBM Navigator for i Default URL
This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console
Server Manager Agent Not Connecting To SMC
After a Java update, the server manager agent may not connect to the SMC because of parameters in the java.security...
Quick Tip: How To Delete Multiple SQLPKGs
Run the following command to delete all the SQLPKG's in the QRECOVERY library with a name beginning with "OW" DLTSQLPKG...
Quick Tip: IBM i (iSeries / AS400) Spool File Navigation
The following commands can be used to navigate spool files after using a command similar to WRKSPLF. Just enter the...
Needle: IBM iSeries (AS400) Power Outage JDE Recovery
Crazy to think but this issue has come up a few times in my years as an Oracle JD Edwards...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but...
Average Rating