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 - 1850 days ago
Last viewed on: 15 Aug 2018 (4928 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