Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
iNav issue when trying to "run an SQL script"
has no ratings.
Published: 16 Jul 2013
Revised: 22 Jul 2013 - 1342 days ago
Last viewed on: 25 Mar 2017 (3444 views) 

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.

iNav issue when trying to "run an SQL script" Published by: Chris Proctor on 16 Jul 2013 view comments(9)

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

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 8 hours 47 minutes ago

Are you on Client Access V7R1 with the latest PTF package installed on your Windows PC?

Posted by: chrisp
Premium member *
Portland, OR
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 8 hours 43 minutes ago

Hi Bob. No, it looks like I'm on 6.0

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 8 hours 22 minutes ago
Edited: Tue, 16 Jul, 2013 at 14:13:40 (1348 days ago)

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

 

Posted by: chrisp
Premium member *
Portland, OR
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 7 hours 30 minutes ago

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?

 

Posted by: SteveCCNJ
Premium member *
Egg Harbor Twp., NJ
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 7 hours 27 minutes ago

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. "

Posted by: chrisp
Premium member *
Portland, OR
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 6 hours 57 minutes ago

Hummmm..... That's interesting, Steve. I was able to do it the day before. Maybe I better check with Ops. Thanks for the input.

 

Posted by: chrisp
Premium member *
Portland, OR
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 5 hours 32 minutes ago

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.

 

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 9 days 4 hours 46 minutes ago

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.

 

Posted by: chrisp
Premium member *
Portland, OR
Comment on: iNav issue when trying to "run an SQL script"
Posted: 3 years 8 months 3 days 8 hours 21 minutes ago

Hi Bob. That was the problem! Once I loaded the PTFs it worked fine. Thank you so much for the tip!

Chris