MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2009

Error SQL0302 *N



fixed

Hi all,

Our PC-based server front-end is accessing data on the i and is sometimes encountering an error. The following two error lines seem to be the common link between the QZDASOINIT jobs in error in subsystem QUSRWRK

[CPD4374] Field HVR0004 and value 4 not compatible. Reason 7.
[7 -- Value contains numeric data that is not valid.]
[SQL0302] Conversion error on host variable or parameter *N.

From what I've been told, this has been happening for the past week or so. We're not aware of any changes on the i or in any SQL code on the front-end. It seems that there is no single SQL statement that causes this issue, as the error will suddenly appear when performing an SQL statement (but not always). The SQL commands are issued through a JDBC connection.

I did find an APAR issue that sounds like possible cause, however it was found in v5r3 in 2007, and since we went to v5r4 in 2008, that should mean we already have that fix, right?
The APAR: http://tinyurl.com/y9f56df

We are at v5r4.

Any ideas?

Thanks,

Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact