ubes get a poiter not set for location referenced after upgrade of OS/400 and tools

cjohnson9

Member
Hi, we have 4 R55 reports that will not run the job log is below when they run we get the following and they don't complete. we tried rewriting them still no good we went from tools 9.0 to 8.95 on 8.9 and os/400 v5r3 on an model 810 to v5r4 on a model 525.

5722SS1 V5R4M0 060210 Job Log S10B0289 12/27/07 11:56:30 Page 1
Job name . . . . . . . . . . : R55AM003 User . . . . . . : JDE Number . . . . . . . . . . . : 024973
Job description . . . . . . : JDE1 Library . . . . . : QGPL
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
CPF1124 Information 00 12/27/07 11:56:26.722288 QWTPIIPP QSYS 066E *EXT *N
Message . . . . : Job 024973/JDE/R55AM003 started on 12/27/07 at 11:56:26 in
subsystem QBATCH in QSYS. Job entered system on 12/27/07 at 11:56:26.
CPI1125 Information 00 12/27/07 11:56:26.722848 QWTPCRJA QSYS 010F *EXT *N
Message . . . . : Job 024973/JDE/R55AM003 submitted.
Cause . . . . . : Job 024973/JDE/R55AM003 submitted to job queue QBATCH in
QGPL from job 024949/ONEWORLD/DSP01. Job 024973/JDE/R55AM003 was started
using the Submit Job (SBMJOB) command with the following job attributes:
JOBPTY(5) OUTPTY(5) PRTTXT() RTGDTA(QCMDB) SYSLIBL(RBTSYSLIB QSYS
QSYS2 QHLPSYS QUSRSYS) CURLIB(B9SYS) INLLIBL(JDEOW QTEMP
QGPL) INLASPGRP(*NONE) LOG(4 00 *NOLIST) LOGCLPGM(*NO) LOGOUTPUT(*JOBEND)
OUTQ(QGPL/GES) PRTDEV(P2) INQMSGRPY(*RQD) HOLD(*NO) DATE(*SYSVAL)
SWS(00000000) MSGQ(QUSRSYS/JDE) CCSID(65535) SRTSEQ(*N/*HEX) LANGID(ENU)
CNTRYID(US) JOBMSGQMX(64) JOBMSGQFL(*WRAP) ALWMLTTHD(*NO) SPLFACN(*KEEP).
*NONE Request 12/27/07 11:56:26.723056 QWTSCSBJ *N QCMD QSYS 0194
Message . . . . : -CALL PGM(PRINTUBE) PARM('JDE ' '/tmp/QACXQT0X77'
'PD9' '*ALL' '224323' 'QTEMP/R55AM003' 'PD9')
CPC2206 Completion 00 12/27/07 11:56:27.153072 QSYCHONR QSYS 0665 QC2SYS QSYS *STMT
To module . . . . . . . . . : QC2SYS
To procedure . . . . . . . : system
Statement . . . . . . . . . : 6
Message . . . . : Ownership of object Q000003117 in B9SYS type *USRQ
changed.
Cause . . . . . : The ownership of object Q000003117 in library B9SYS type
*USRQ has changed.
SQL7908 Completion 00 12/27/07 11:56:27.578744 QSQROUTS QSYS *STMT QSQPRCED QSYS *STMT
From module . . . . . . . . : QSQSRVRC
From procedure . . . . . . : SQSERVER
Statement . . . . . . . . . : 5373
To module . . . . . . . . . : QSQPRCED
To procedure . . . . . . . : QSQPRCED
Statement . . . . . . . . . : 6430
Message . . . . : Job 024951/QUSER/QSQSRVR used for SQL server mode
processing.
Cause . . . . . : A Structured Query Language (SQL) statement was executed
while running in SQL server mode. SQL statements for this connection or
thread will be processed in job 024951/QUSER/QSQSRVR. Technical description
. . . . . . . . : SQL server mode was requested by either setting the SQL
server mode job attribute, or by setting the server mode environment
attribute via the SQL Call Level Interface. When running in this mode, SQL
statements are processed by a separate job, which runs under the user
profile specified for the connection. The thread identifier is 8 and the
connection is to Relational Database *N. If the Relational Database name is
*N, this means that all connections for the thread will use the same job.
MCH3601 Escape 40 12/27/07 11:56:30.208240 JDEKRNL B9SYS *STMT JDEKRNL B9SYS *STMT
From module . . . . . . . . : K2TABLOAD
From procedure . . . . . . : UBESort_Extended
Statement . . . . . . . . . : 3
To module . . . . . . . . . : K2TABLOAD
To procedure . . . . . . . : UBESort_Extended
Statement . . . . . . . . . : 3
Message . . . . : Pointer not set for location referenced.
5722SS1 V5R4M0 060210 Job Log S10B0289 12/27/07 11:56:30 Page 2
Job name . . . . . . . . . . : R55AM003 User . . . . . . : JDE Number . . . . . . . . . . . : 024973
Job description . . . . . . : JDE1 Library . . . . . : QGPL
MSGID TYPE SEV DATE TIME FROM PGM LIBRARY INST TO PGM LIBRARY INST
Cause . . . . . : A pointer was used, either directly or as a basing
pointer, that has not been set to an address.
CPF1164 Completion 00 12/27/07 11:56:30.290232 QWTMCEOJ QSYS 00D7 *EXT *N
Message . . . . : Job 024973/JDE/R55AM003 ended on 12/27/07 at 11:56:30; 1
seconds used; end code 0 .
Cause . . . . . : Job 024973/JDE/R55AM003 completed on 12/27/07 at 11:56:30
after it used 1 seconds processing unit time. The job had ending code 0.
The job ended after 1 routing steps with a secondary ending code of 0. The
job ending codes and their meanings are as follows: 0 - The job completed
normally. 10 - The job completed normally during controlled ending or
controlled subsystem ending. 20 - The job exceeded end severity (ENDSEV job
attribute). 30 - The job ended abnormally. 40 - The job ended before
becoming active. 50 - The job ended while the job was active. 60 - The
subsystem ended abnormally while the job was active. 70 - The system ended
abnormally while the job was active. 80 - The job ended (ENDJOBABN command).
90 - The job was forced to end after the time limit ended (ENDJOBABN
command). Recovery . . . : For more information, see the Work Management
topic in the Information Center,
http://www.ibm.com/eserver/iseries/infocenter.


Thanks,
Chris
 
Re: ubes get a poiter not set for location referenced after upgrade of OS/400 and tools

Just going through the check list from changing an AS/400:

1) I'm sure you've checked and installed all appropriate PTFs for V5R4?
2) Did you delete the existing *SQLPKG objects after the OS upgrade?
3) Is the Remote DB Directory Entry correct?
4) Is the EDRSQL service started?

Sorry these are so generic. I tried looking for messages that matched yours, but didn't come up with anything.
 
Re: ubes get a poiter not set for location referenced after upgrade of OS/400 and tools

We are on iSeries, V5R3 and just updated to XE SP23_T1. We are not seeing the major problems you are, but we do see the references to Sql Server Mode. There is a jde.ini setting to turn of SQL Server Mode - Take a look at SAR #201047405.
Judy
 
Back
Top