bmarxhau
Active Member
Just converted our DV810 business data/control tables to Unicode, deleted SQLPKGs, and now having errors when running pre-payroll, other UBEs seem fine.
From the jde.log of the R07200:
630 Tue Jul 19 17:46:18.014768 dbdrv_log.c196
OS400QL009 - OpenSQLCursor:ReOpen SQL cursor: Crsr122. QSQLMSG *LIBL - SQL0302 - Conversion error on input host variable or parameter &2
630 Tue Jul 19 17:46:18.080648 jdb_drvm.c1139
JDB9900176 - Failed to reset db request
630 Tue Jul 19 17:46:18.111152 jdb_exef.c3706
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.
630 Tue Jul 19 17:46:18.116512 dbdrv_log.c196
OS400QL009 - OpenSQLCursor:ReOpen SQL cursor: Crsr122. QSQLMSG *LIBL - SQL0302 - Conversion error on input host variable or parameter &2
630 Tue Jul 19 17:46:18.117104 jdb_drvm.c1139
JDB9900176 - Failed to reset db request
630 Tue Jul 19 17:46:18.117672 jdb_exef.c3706
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.
From the job log of the R07200:
CPD4374 Diagnostic 40 07/19/05 17:46:17.554832 QQQSRVE1 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QQQOOOSETS
From procedure . . . . . . : QQQSNDPMSG
Statement . . . . . . . . . : 3531
To module . . . . . . . . . : QSQOPEN
To procedure . . . . . . . : OPQRYDBM
Statement . . . . . . . . . : 13905
Message . . . . : Field HVR0003 and value 3 not compatible. Reason 8.
Cause . . . . . : The attributes of variable field HVR0003 in query record format FORMAT0001 are not compatible with the attributes of value number 3. The value is *N. The reason code is 8.
The reason codes and their meanings follow: 8 -- Value contains double-byte character data that is not valid.
SQL0302 Diagnostic 30 07/19/05 17:46:17.779448 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QSQOPEN
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 17844
To module . . . . . . . . . : QSQOPEN
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 17844
Message . . . . : Conversion error on input host variable or parameter *N.
Cause . . . . . : Host variable or parameter *N or entry 3 in an SQLDA contains a value that can not be converted to the attributes required by the statement. Error type 7 occurred.
Error types and their meanings are: 7 -- Double-byte character set (DBCS) data that is not valid.
Planning to perform RCLSTG(*DBXREF) and delete QGPL/QZDAPKG just prior to an IPL tonight, but open to other suggestions if anyone has encountered this. Seems hauntingly familiar...
Brent
iSeries V5R2, E1 8.10, TR 8.94_L1
From the jde.log of the R07200:
630 Tue Jul 19 17:46:18.014768 dbdrv_log.c196
OS400QL009 - OpenSQLCursor:ReOpen SQL cursor: Crsr122. QSQLMSG *LIBL - SQL0302 - Conversion error on input host variable or parameter &2
630 Tue Jul 19 17:46:18.080648 jdb_drvm.c1139
JDB9900176 - Failed to reset db request
630 Tue Jul 19 17:46:18.111152 jdb_exef.c3706
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.
630 Tue Jul 19 17:46:18.116512 dbdrv_log.c196
OS400QL009 - OpenSQLCursor:ReOpen SQL cursor: Crsr122. QSQLMSG *LIBL - SQL0302 - Conversion error on input host variable or parameter &2
630 Tue Jul 19 17:46:18.117104 jdb_drvm.c1139
JDB9900176 - Failed to reset db request
630 Tue Jul 19 17:46:18.117672 jdb_exef.c3706
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.
From the job log of the R07200:
CPD4374 Diagnostic 40 07/19/05 17:46:17.554832 QQQSRVE1 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QQQOOOSETS
From procedure . . . . . . : QQQSNDPMSG
Statement . . . . . . . . . : 3531
To module . . . . . . . . . : QSQOPEN
To procedure . . . . . . . : OPQRYDBM
Statement . . . . . . . . . : 13905
Message . . . . : Field HVR0003 and value 3 not compatible. Reason 8.
Cause . . . . . : The attributes of variable field HVR0003 in query record format FORMAT0001 are not compatible with the attributes of value number 3. The value is *N. The reason code is 8.
The reason codes and their meanings follow: 8 -- Value contains double-byte character data that is not valid.
SQL0302 Diagnostic 30 07/19/05 17:46:17.779448 QSQRUN3 QSYS *STMT QSQRUN3 QSYS *STMT
From module . . . . . . . . : QSQOPEN
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 17844
To module . . . . . . . . . : QSQOPEN
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 17844
Message . . . . : Conversion error on input host variable or parameter *N.
Cause . . . . . : Host variable or parameter *N or entry 3 in an SQLDA contains a value that can not be converted to the attributes required by the statement. Error type 7 occurred.
Error types and their meanings are: 7 -- Double-byte character set (DBCS) data that is not valid.
Planning to perform RCLSTG(*DBXREF) and delete QGPL/QZDAPKG just prior to an IPL tonight, but open to other suggestions if anyone has encountered this. Seems hauntingly familiar...
Brent
iSeries V5R2, E1 8.10, TR 8.94_L1