Symptom
In transaction SM21 the following error occurs periodically:
Database error -99999 at FET
> CLI0112E Error in assignment. SQLSTATE=22005 row=1 col=4
In the corresponding dev_wX (Dev. Traces), the error shows up like
--------------------------------------------------------------------------------------------------------------------------------------------------------------
C *** ERROR in DB6Fetch[/bas/742_REL/src/dbs/db6/dbdb6.c, 4165] CON = 1 (BEGIN)
C &+ dsql_db6_array_fetch( SQLFetch ): [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 row=1 col=4
C &+
C &+ SELECT DBPARTITIONNUM, MEMBER, SNAPSHOT_TIMESTAMP, BPNAME, sum(POOL_DATA_L_READS), sum(POOL_INDEX_L_READS), sum(P
C &+ OOL_XDA_L_READS), sum(POOL_TEMP_DATA_L_READS), sum(POOL_TEMP_INDEX_L_READS), sum(POOL_TEMP_XDA_L_READS), sum(POOL_
C &+ DATA_P_READS), sum(POOL_INDEX_P_READS), sum(POOL_XDA_P_READS), sum(POOL_TEMP_DATA_P_READS), sum(POOL_TEMP_INDEX_P_
C &+ READS), sum(POOL_TEMP_XDA_P_READS) FROM SAPTOOLS.DBH_STG_TBSPPRF GROUP BY DBPARTITIONNUM, MEMBER, SNAPSHOT_TIMEST
C &+ AMP, BPNAME
C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0
C &+
C &+ Output SQLDA:
C &+ 1 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 2 CT=CHAR T=VARCHAR L=26 P=26 S=0
C &+ 3 CT=CHAR T=VARCHAR L=128 P=128 S=0
C &+ 4 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 5 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 6 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 7 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 8 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 9 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 10 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 11 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 12 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 13 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 14 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+ 15 CT=DECIMAL T=DECIMAL L=12 P=23 S=0
C &+
C &+ ABAP location info 'CL_SQL_RESULT_SET=============CP', 323
C &+
C *** ERROR in DB6Fetch[/bas/742_REL/src/dbs/db6/dbdb6.c, 4165] (END)
B ***LOG BY2=> sql error -99999 performing FET [dbds 583]
B ***LOG BY0=> CLI0112E Error in assignment. SQLSTATE=22005 row=1 col=4 [dbds 583]
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Read more...
Environment
Systems with the database DB2 for LUW (DB6)
Keywords
SM21, EWA , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , SV-SMG-SER , SAP Support Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview