× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Rob, I had something like this a couple months back, had to do with SQLPKG
objects, might be it or it might not be.

On Thu, Feb 21, 2013 at 7:54 AM, <rob@xxxxxxxxx> wrote:

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
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.