Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Good morning! I've been using iNav for testing my stored procedures for quite some time, but yesterday morning I was trying to debug one and it locked up. It said something about trying to start the debugger (or something like that). Anyway, I had to kill it via the task manager.
Now, when I click on the "run an SQL script" I get an "unknown error has occurred" popup. I do see the following msg in one of my jobs, but I'm not sure what it means or how I can correct it.
MESSAGE ID . . . . . . : SQL0462
DATE SENT . . . . . . : 07/16/13 TIME SENT . . . . . . : 10:32:39
MESSAGE . . . . : Procedure or user-defined function OBJECT_STATISTICS in
QSYS2 returned a warning SQLSTATE.
Cause . . . . . : An SQLSTATE of the form 01xxx was returned by the
procedure or user-defined function OBJECT_STATISTICS in QSYS2 (with specific
name QSQOBSTAT), along with message text *N.
Recovery . . . : The user must understand the meaning of the warning. See
your database administrator, or the author of the user-defined function or
procedure.
Also, in my QZRCSRVS job I see the following errors:
Ownership of object ZRCRPCSPC in QTEMP type *USRSPC changed.
Client request - run program QSYS/QUSRJOBI.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QUSRJOBI.
Client request - run program QSYS/QUSRJOBI.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QSZRTVPR.
Product information not found.
Client request - run program QSYS/QUSRJOBI.
Client request - run program QSYS/QUSRJOBI.
Client request - run program QSYS/QUSRJOBI.
I'm hoping someone has had this same problem, because I'm lost without my iNav.
Thanks!
Chris
Are you on Client Access V7R1 with the latest PTF package installed on your Windows PC?
Hi Bob. No, it looks like I'm on 6.0
you can't tell with the Client Access Emulator HELP | About Personal Communications... menu option. It always shows version 6.0
You need to launch: IBM i Access for Windows Properties
Oh, I see.... Yes, I am running V7R1M0 Service level SI00000. Not sure how to tell if I have the latest PTF pkg on my laptop tho. Is there a way of running an update check?
According to the manual, "this warning appears in the job log if the procedure encounters objects for which the user does not have *USE object authority. The warning is provided as an indication that the procedure was unable to process all available objects. "
Hummmm..... That's interesting, Steve. I was able to do it the day before. Maybe I better check with Ops. Thanks for the input.
Well, Ops told me that nothing has changed. I did find the following message tho. Hopefully, it means something to someone.
Recovery . . . : The product ID 5733OMF, release *ONLY, product option
0000,load ID *CODE and format PRDR0100, requested is not valid. Specify
valid product and format information then try the request again.
You do NOT have the latest PTFs installed. You need to go download them from the Client Access PTF Matrix (seach this website for the link). And you may also have to follow the IBM warning about the Microsoft security update being installed first. Read the warning on the IBM site, then follow their link to the Microsoft "hot fix" page to pull down the fix.
Then install the Client Access PTFs onto your Windows 7 PC.