SAP Knowledge Base Article - Preview

2843681 - Error 'Database error -99999 at FET' reported in SM21

Symptom

The following errors are reported in transaction code SM21:

LINE.jpg
|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
LINE.jpg

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':

LINE.jpg
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)
LINE.jpg


Read more...

Environment

  •  Db2 (DB6) any version
  •  SAP Netweaver ABAP 7.40 
  •  ST-PI 2008_1

Product

SAP Supply Chain Management 7.0

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.