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



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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.