Symptom
The following errors are reported in transaction code SM21:
|2019/08/16|14:10:44|DIA |053|100|Database error -99999 at FET
|2019/08/16|14:10:44|DIA |053|100|> CLI0111E Numeric value out of range. SQLSTATE=22003 row=1
With the work process log (dev_w) showing the data triggering the error being fetched from Db2 catalog table syscat.indexes, column 12 which is 'first4keycard':
C *** ERROR in DB6Fetch[/bas/749_REL/src/dbs/db6/dbdb6.c, 4180] CON = 1 CACHEID = 36 (BEGIN) C &+ dsql_db6_fetch( SQLFetch ): [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003 row=1 col=12
C &+ C &+ SELECT substr(indschema,1,30) as indschema, substr(indname,1,40) as indname, substr(tabschema,1,30) as tabschema,
C &+ substr(tabname,1,40) as tabname, uniquerule, colcount, nleaf, nlevels, firstkeycard, first2keycard, first3keycard,
C &+ first4keycard , fullkeycard, clusterratio, clusterfactor, create_time, stats_time FROM syscat.indexes WHERE tabsch
C &+ * = ? AND tabname = ? C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0
C &+ C &+ Input SQLDA:
C &+ 1 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ 2 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ C &+ Input data:
C &+ row 1: 1 WCHAR I=12 "SAPPSC"
C &+ 2 WCHAR I=30 "/SCDL/DB_STATUS"
C &+ C &+ Output SQLDA:
C &+ 1 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ 2 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ 3 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ 4 CT=WCHAR T=VARCHAR L=256 P=384 S=0
C &+ 5 CT=WCHAR T=VARCHAR L=2 P=3 S=0
C &+ 6 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 7 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 8 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 9 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 10 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 11 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 12 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 13 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 14 CT=LONG T=INTEGER L=4 P=4 S=0
C &+ 15 CT=DOUBLE T=FLOAT L=8 P=8 S=0
C &+ 16 CT=WCHAR T=VARCHAR L=52 P=78 S=0
C &+ 17 CT=WCHAR T=VARCHAR L=52 P=78 S=0
C &+ C &+ ABAP location info 'CL_SQL_RESULT_SET=============CP', 93
C &+ C *** ERROR in DB6Fetch[/bas/749_REL/src/dbs/db6/dbdb6.c, 4180] (END)
Read more...
Environment
- Db2 (DB6) any version
- SAP Netweaver ABAP 7.40
- ST-PI 2008_1
Product
Keywords
overflow /SDF/DLD_SQL_H_DB6 /SDF/DLD_SQL_DB6
, 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