Re: QSQROUTE errors while processing XML on As400

This looks like a bug that should go through normal support channels.


Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




Madhavan <seawolf00@yahoo.com>@midrange.com on 10/10/2000 12:25:39 PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   java400-L@midrange.com
cc:
Subject:  QSQROUTE errors while processing XML on As400



Hi ,

I am running a batch stress test process on AS400
v4r4m0 with about 100 xml document objects to be
processed. The process briefly described as below is

> XML request objects are passed from a Windows NT
caller
> Servlet on AS400 gets the request (XML document
object)
> Spins off the object to another thread object which
parses the XML and writes to database
> Uses Type II driver and implements IBM Con Pooling

JDBC Connection parameters are:

PoolName : JdbcDb2
Max Cons : 30
Min Cons : 10
Con Time Out :2000
Max Age  : 300
Max Idle time :600
Reap time :180

The errors we get are :

Suddenly in the middle of processing, I see this error
in the QTMHHTTP job (which is on CNDW on the AS400)

"
Program does not include SQL statements.

Application error.  SQL7903 unmonitored by QSQCLI at
statement 0000004050,
  instruction X'0000'.

Pointer not set for location referenced.  "

When I see the detailed job log, the description is

"                        Additional Message
Information


Message ID . . . . . . :   SQL7903

Date sent  . . . . . . :   10/09/00      Time sent  .
. . . . . :   20:35:54


Message . . . . :   Program does not include SQL
statements.


Cause . . . . . :   QSQROUTE program has been called,
but the calling program
  is not a valid precompiled SQL program.  The
QSQROUTE program can only be
  called by a program that has been created through
the SQL precompiler.
  Programs created using the non-Integrated Language
Environment (ILE)
  commands must have been precompiled using the
non-ILE SQL commands.  Module
  created or bound using the Integrated Language
Environment (ILE) commands
  must have been precompiled using the ILE SQL
commands.
Recovery  . . . :   Remove the call to QSQROUTE
program.  If SQL statements
  need to be processed, use the CRTSQLRPG, CRTSQLCBL,
CRTSQLFTN, or CRTSQLPLI
  commands for non-ILE programs. To process SQL
statements in the Integrated
  Language Environment, use the CRTSQLCI, CRTSQLCBLI
or CRTSQLRPGI commands. "

And

"Message ID . . . . . . :   CEE9901

Date sent  . . . . . . :   10/09/00      Time sent  .
. . . . . :   20:35:54


Message . . . . :   Application error.  SQL7903
unmonitored by QSQCLI at
  statement 0000004050, 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 QSQCLI SQLPR
SQLPrepare. The program was
  stopped at the high-level language statement
number(s) 0000004050 at the
  time the message was sent.  If more than one
statement number is shown, the
  program is an optimized ILE program.  Optimization
does not allow a single
  statement number to be determined.  If *N is shown
as a value, it means the
  real value was not available.

Recovery  . . . :   See the low level messages
previously listed to locate the
  cause of the exception.  Correct any errors, and
then try the request again. "

After this , there is a java.lang.unknown error.

Can somebody please tell me what is happening ?

Regards
madhavan














__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---