I have some users getting the following messages in their joblog:
First, the problem I am trying to solve is a way down into their joblog.
Apparently when you get all the way out of the application (Infor LX)
you'll see messages like
CPC0911-Activation group SYS900B deleted.
I am considering this a nonissue. Just posting it here in case I'm wrong.
After they get this message, do what they need to, then then get right
back into LX. This may be in their joblog a few times.
Then I see several of these
SQL7917-Access plan not updated.
Cause . . . . . : The query optimizer rebuilt the access plan for this
statement, but the program could not be updated. Another job may be
running
the program. The program cannot be updated with the new access plan
until a
job can obtain an exclusive lock on the program.
Again, I am considering this a nonissue. However, it IS the immediately
preceeding message to the following:
CEE9902-Unexpected user error occurred in QLEDAGE.
Cause . . . . . : An unexpected error occurred in the application
programming interface QLEDAGE. See previous messages for details.
(Again, the immediately preceeding message was the SQL7917)
From program . . . . . . . . . : QLEDAGE
From library . . . . . . . . : QSYS
From module . . . . . . . . : QLETOOL
From procedure . . . . . . . : Q LE AWIRaise
From statement . . . . . . . : 176
To program . . . . . . . . . . : QLECWI
To library . . . . . . . . . : QSYS
To module . . . . . . . . . : QLEEXIT
To procedure . . . . . . . . : CEE4RegActGrpExitCommon__FPFUiT1PVUi_vPFU
LUiPVUi_vUiPV9_FEEDBACKPc
To statement . . . . . . . . : 80
Followed by:
CEE9902-Unexpected user error occurred in CEE4RegActGrpExitCommon.
CEE9902-Unexpected user error occurred in CEE4RAGE.
From program . . . . . . . . . : QLEAWI
From library . . . . . . . . : QSYS
From module . . . . . . . . : QLETOOL
From procedure . . . . . . . : Q LE AWIRais
From statement . . . . . . . : 176
To program . . . . . . . . . . : QLEAWI
To library . . . . . . . . . : QSYS
To module . . . . . . . . . : QLERAGE
To procedure . . . . . . . . : CEE4RAGE
To statement . . . . . . . . : 1
RNX8001-Error caused procedure PURPR1R in program ERPLXUSRO/PURPR1R to
stop during initialization.
Cause . . . . . : The RPG procedure PURPR1R in program ERPLXUSRO/PURPR1R
failed during procedure initialization with message . See previously
listed
messages for more information.
Yes, that was "with message .", just like it knew not what message.
CEE9901-Application error. RNX8001 unmonitored by PURPR1R at statement
*N, instruction X'0000'.
Cause . . . . . : The application ended abnormally because an exception
occurred and was not handled. The name of the program to which the
unhandled exception is sent is PURPR1R PURPR1R _QRNP_PEP_PURPR1R. The
program was stopped at the high-level language statement number(s) *N
CPA0701-CEE9901 received by PURPR1C at 1600. (C D I R)
Cause . . . . . : Control language (CL) program PURPR1C in library
ERPLXUSRO
detected an error at statement number 1600. Message text for CEE9901 is:
Application error. RNX8001 unmonitored by PURPR1R at statement *N,
instruction X'0000'.
Program . . . . . . . : PURPR1R Library . . . . . . . :
ERPLXUSRO
Owner . . . . . . . . : SSA
Program attribute . . : RPGLE
Program creation information:
Program creation date/time . . . . . . . . . . : 11/12/12 08:51:36
Type of program . . . . . . . . . . . . . . . : ILE
Program entry procedure module . . . . . . . . : PURPR1R
Library . . . . . . . . . . . . . . . . . . : QTEMP
Activation group attribute . . . . . . . . . . : *CALLER
Shared activation group . . . . . . . . . . . : *NO
User profile . . . . . . . . . . . . . . . . . : *USER
Use adopted authority . . . . . . . . . . . . : *YES
Coded character set identifier . . . . . . . . : 65535
Number of modules . . . . . . . . . . . . . . : 1
Number of service programs . . . . . . . . . . : 8
Number of unresolved references . . . . . . . : 0
Number of copyrights . . . . . . . . . . . . . : 1
All creation data . . . . . . . . . . . . . . : *YES
Observable information compressed . . . . . . : *NO
Run time information compressed . . . . . . . : *NO
Allow update . . . . . . . . . . . . . . . . . : *YES
Allow bound *SRVPGM library name update . . . : *NO
Profiling data . . . . . . . . . . . . . . . . : *NOCOL
Teraspace storage enabled PEP . . . . . . . . : *YES
Teraspace storage enabled modules . . . . . . : *ALL
Storage model . . . . . . . . . . . . . . . . : *SNGLVL
Argument optimization . . . . . . . . . . . . : *NO
Text description . . . . . . . . . . . . . . . : Receiving Open Order
Repor
Program statistics:
Number of parameters . . . . . . . . . . . . . : 0 255
Associated space size (decompressed) . . . . . : 4096
Static storage size . . . . . . . . . . . . . : 41936
Allow static storage reinitialization . . . . : *NO
Program size . . . . . . . . . . . . . . . . . : 4182016
Program state . . . . . . . . . . . . . . . . : *USER
Program domain . . . . . . . . . . . . . . . . : *USER
Release program created on . . . . . . . . . . : V7R1M0
Release program created for . . . . . . . . . : V7R1M0
Earliest release program can run . . . . . . . : V7R1M0
Conversion required . . . . . . . . . . . . . : *NO
Conversion detail . . . . . . . . . . . . . . : *COMPAT
Program performance information:
Paging pool . . . . . . . . . . . . . . . . . : *USER
Paging amount . . . . . . . . . . . . . . . . : *BLOCK
Module attributes:
Module . . . . . . . . . . . . . . . . . . . . : PURPR1R
Library . . . . . . . . . . . . . . . . . . : QTEMP
Source file . . . . . . . . . . . . . . . . . : QRPGLESRC
Library . . . . . . . . . . . . . . . . . . : ERPLXUSRS
Source member . . . . . . . . . . . . . . . . : PURPR1R
Module attribute . . . . . . . . . . . . . . . : RPGLE
Module creation date/time . . . . . . . . . . : 11/12/12 08:51:06
Source file change date/time . . . . . . . . . : 11/09/12 14:45:05
...
Number of procedures . . . . . . . . . . . . . : 7
...
Teraspace storage enabled . . . . . . . . . . : *YES
Storage model . . . . . . . . . . . . . . . . : *SNGLVL
...
DB2 for IBM i module attributes:
Number of SQL statements . . . . . . . . . . . : 13
Commitment control . . . . . . . . . . . . . . : *NONE
Relational database . . . . . . . . . . . . . : *LOCAL
...
SQL package name . . . . . . . . . . . . . . . : PURPR1R
Library . . . . . . . . . . . . . . . . . . : LES
QSYS/PRTSQLINF OBJ(ERPLXUSRO/PURPR1R)
lots of stuff...
SQL4021 Access plan last saved on 02/19/13 at 17:08:10.
SQL4020 Estimated query run time is 0 seconds.
SQL402D Query attributes overridden from query options file QAQQINI in
library QUSRSYS.
SQL4027 Access plan was saved with DB2 Symmetric Multiprocessing
installed on the system.
...
7.1
PTF Group Level
SF99710 12279
SF99709 72
SF99708 23
SF99707 5
SF99706 2
SF99705 3
SF99701 20
SF99647 2
SF99637 7
SF99627 8
SF99617 6
SF99572 10
SF99381 3
SF99380 7
SF99369 12
SF99368 15
SF99367 6
SF99366 6
SF99364 8
SF99363 11
SF99362 19
SF99145 4
I did see one ancient hit that stopping the job and starting a new one may
help. We found that to be true.
http://www-912.ibm.com/s_dir/slkbase.NSF/1ac66549a21402188625680b0002037e/d6df4e9cf748162e862571d80065ccb7?OpenDocument&ExpandSection=-1
Rob Berendt
midrange.com
