Search found 15 matches

by shelfos
Tue Nov 10, 2015 7:56 pm
Forum: New Toolkit
Topic: Sporadic "Toolkit request failed.." errors after OS upgrade
Replies: 2
Views: 3890

Sporadic "Toolkit request failed.." errors after OS upgrade

Over this past weekend we upgraded our OS to i7.2. Since then we get sporadic errors when calling rpg programs. They don't consistently occur, but they do seem more frequent with more users connected (but maybe not). The error is: "Toolkit request failed. Possible reason: a CCSID not matching that o...
by shelfos
Thu Jul 30, 2015 9:51 pm
Forum: New Toolkit
Topic: CPC2206 error
Replies: 1
Views: 3145

Re: CPC2206 error

Upon further investigation the reason it seems to be happening on every rpg call is that before every rpg call we are running the getDiagnostics() function (found in ToolkitServiceXML.php) to get the job number, user name, and job name. If I eliminate this step the problem goes away. Could the probl...
by shelfos
Thu Jul 30, 2015 12:59 am
Forum: New Toolkit
Topic: customControl and killing rpg program
Replies: 2
Views: 3752

Re: customControl and killing rpg program

What I decided to do rather than use the "kill" method was to use another option suggested by Alan Seiden which is to change the job before calling the rpg program so that the job automatically gets ended if an error occurs. What actually happens is that when the rpg program errors out and a message...
by shelfos
Thu Jul 30, 2015 12:14 am
Forum: New Toolkit
Topic: CPC2206 error
Replies: 1
Views: 3145

CPC2206 error

It seems like whenever the toolkit is used to call an rpg program a spooled file gets generated with the following text:

CPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed

I have searched and searched and am no closer to understanding the root of this.
by shelfos
Wed Jul 22, 2015 5:28 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 11786

Re: GetSPLF failing to perform the CPYSPLF function

In my shop we rolled our own function called runQuery() which uses db2_execute, so the ReadSPLFData() function in iToolkitService.php now reads as follows: private function ReadSPLFData() { $Txt=''; // old code //$stmt = "SELECT ZSF255 FROM {$this->TmpLib}.{$this->TMPFName} FOR FETCH ONLY"; // new c...
by shelfos
Thu Jun 04, 2015 12:55 am
Forum: New Toolkit
Topic: customControl and killing rpg program
Replies: 2
Views: 3752

customControl and killing rpg program

Ideally we write rpg programs that never fail, that never have errors, or when they do they are handled perfectly, but alas (and maybe I can speak only for myself), I am imperfect. If an rpg program stops processing with an error on the console awaiting a reply the browser does not get a response un...
by shelfos
Fri May 29, 2015 9:43 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 11786

Re: GetSPLF failing to perform the CPYSPLF function

So, just a quick followup. Casting the results to CCSID(37) had the following effects: 1.) When using db2_exec() in the Db2supp.php executeQuery() function, I still get 0 results. 2.) When I bypass the Db2supp.php executeQuery() function and use the db2_execute() function instead, I get results! Yea...
by shelfos
Fri May 29, 2015 6:33 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 11786

Re: GetSPLF failing to perform the CPYSPLF function

The file being created is QGPL/PGMR9301. These are the file permissions (PGMR9301 is part of the BMAPGMR group): Object User Group Authority *PUBLIC *USE *GROUP BANK93 *ALL *GROUP BMAPGMR *ALL MICR *ALL QPGMR *ALL QTCP *ALL QTMHHTTP *ALL ZENDADMIN *ALL If I use STRSQL or iSeries Navigator to perform...
by shelfos
Fri May 29, 2015 5:19 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 11786

Re: GetSPLF failing to perform the CPYSPLF function

That was a great idea to try to narrow this down.

I do get results for the qsys2.syscolumns query.

I am authenticating the toolkit at PGMR9301
by shelfos
Thu May 28, 2015 8:42 pm
Forum: Zend Server for IBM i
Topic: GetSPLF failing to perform the CPYSPLF function
Replies: 24
Views: 11786

Re: GetSPLF failing to perform the CPYSPLF function

SELECT ZSF255 FROM QGPL.PGMR9301 FOR FETCH ONLY; SELECT ZSF255 FROM QGPL/PGMR9301 FOR FETCH ONLY; When running either of them using Db2supp.php db2_exec() I get 0 results. What's weird is if I use db2_execute() to run either query I also get 0 results. But if I use STRSQL (old green screen) I DO ge...