SP23_W1 AS/400 installation

A couple of beauties from this simple upgrade:


I noticed that the install instructions for SP23 are wrong, and I thought that I would tell you. There is a section which says that if you are upgrading from < SP22, you need to FTP the printqueue members from the old to the new.

The CD and LCD commands in that section are mixed up.

You need to:

CD B7334SYSBK
LCD B7334SYS
BIN
MGET PRINTQUEUE.*

The instructions say:
LCD B7334SYSBK
CD B7334SYS
BIN
MGET PRINTQUEUE.*

Note that GET does get from CD (foreign dir) to LCD (local dir)


And another one:

Users could not run jobs after applying the new servicePack. Note that this was really strange. The Jobs WERE running, but they could not write to the F986110 or select from the F986111.

The other very strange thing was that the first one DID work. This must have been because the selection to the F986111 failed to get a next number, and it inserted a record with a blank job number in the F986110. Ironically I could see the record, because this was the only record in WSJ for this user. I did not notice that the job number was blank (i.e. no sequencing for 1 record!!). Totally fortuitous that it worked the first time, crazy.

Got error OS40002001 -803 in the UBE kernel jde log files.

1) Add the following line in JDE.INI on server to disable
CLI SQL Server mode-
[DB SYSTEM SETTINGS]
sqlServerMode=0
NOTE: If the customer is not running vertex or running
older release of vertex which does not require CLI SQL
server mode and the customer is running 8.11 SP1 and
below
application release, customer can disable server mode
using
the sqlServerMode = 0 in the jde.ini
2) Stop E1 services on enterprise server (ENDNET).
3) Stop Extended Dynamic Remote SQL (EDRSQL) server (
i.e.
ENDTCPSVR SERVER(*EDRSQL)
4) Start all services: EDRSQL, i.e. STRTCPSVR SERVER(*EDRSQL
) and EnterpriseOne Service (STRNET).