SAP Knowledge Base Article - Preview

2842591 - Job 'E2E BI HOUSEKEEPING' reports 'CLI0111E Numeric value out of range'

Symptom

Although job 'E2E BI HOUSEKEEPING' completes successfully with no errors reported in the tcode SM37 job log,  the tcode SM21 system log reports 'CLI0111E Numeric value out of range'.

Inspection of the work process (dev_w) log reveals the error is occurring for the following SQL statement:

LINE.jpg
C Wed May 1 02:02:54 2019
C *** ERROR in DB6Fetch[/bas/745_REL/src/dbs/db6/dbdb6.c, 4212] CON = 0 CACHEID = 171 (BEGIN)
C &+ dsql_db6_array_fetch( SQLFetch ): [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003 row=1 col
C &+ =41
C &+
C &+ SELECT "DT"."SID_0CALDAY" AS "S____003" ,"DT"."SID_0CALMONTH" AS "S____004" ,"DT"."SID_0CALQUARTER" AS "S____005"
C &+ ,"DT"."SID_0CALWEEK" AS "S____006" ,"DT"."SID_0CALYEAR" AS "S____007" ,"D2"."SID_0SMD_LINS" AS "S____008" ,"D2"."
C &+ SID_0SMD_LSID" AS "S____009" ,"D3"."SID_0SMD_SPHH" AS "S____034" ,"D2"."SID_0SMD_LCNA" AS "S____047" ,"D2"."SID_0S
C &+ MD_LCVP" AS "S____048" ,"D2"."SID_0SMD_LMIP" AS "S____049" ,"D2"."SID_0SMD_LMNA" AS "S____050" ,"D2"."SID_0SMD_LMP
C &+ P" AS "S____051" ,"D2"."SID_0SMD_LPNA" AS "S____052" ,"D2"."SID_0SMD_LPRP" AS "S____053" ,"D3"."SID_0SMD_SHOS" AS
C &+ "S____056" ,"D3"."SID_0SMD_SINA" AS "S____057" ,"D3"."SID_0SMD_SITY" AS "S____058" ,"D3"."SID_0SMD_SMDT" AS "S____
C &+ 059" ,"D3"."SID_0SMD_SNNA" AS "S____060" ,"D3"."SID_0SMD_SNTY" AS "S____061" ,"D4"."SID_0SMD_AEX" AS "S____082" ,"
C &+ D4"."SID_0SMD_AMEX" AS "S____084" ,"D4"."SID_0SMD_AEC" AS "S____090" ,"D4"."SID_0SMD_ASID" AS "S____091" ,"D4"."SI
C &+ D_0SMD_ATIM" AS "S____092" ,"D4"."SID_0SMD_AWID" AS "S____093" ,"D2"."SID_0SMD_LCID" AS "S____110" ,"D2"."SID_0SMD
C &+ _LCNR" AS "S____111" ,"D2"."SID_0SMD_LTST" AS "S____112" ,"D5"."SID_0DBH_DBNA" AS "S____236" ,"D5"."SID_0DBH_DBREL
C &+ " AS "S____237" ,"DT"."SID_0WEEKDAY1" AS "S____238" ,"F"."KEY_0DB6_C03H6" AS "S____399" ,"D3"."SID_0DBH_RHOST" AS
C &+ "S____415" ,"F"."KEY_0DB6_C03H8" AS "S____1463" ,"D7"."SID_0DB6_MEMGRP" AS "S____1464" ,"D7"."SID_0DB6_MEMLVL" AS
C &+ "S____1465" ,"D7"."SID_0DB6_MEMPOL" AS "S____1466" , SUM ( "F"."DB6_DTSIZE" ) AS "Z____2832_SUM" , SUM ( "F"."
C &+ DB6_MCFGSZ" ) AS "Z____2833_SUM" , SUM ( "F"."DB6_MHWMSZ" ) AS "Z____2834_SUM" , SUM ( "F"."DB6_SIZE" ) AS
C &+ "Z____1467_SUM" , SUM ( "F"."DBH_CNT" ) AS "Z____027_SUM" , SUM ( "F"."DBH_TIPER" ) AS "Z____2777_SUM" , CO
C &+ UNT_BIG( * ) AS "Z____089_SUM" FROM "/BI0/F0DB6_C03H" "F" JOIN "/BI0/D0DB6_C03HT" "DT" ON "F" . "KEY_0DB6_C03HT"
C &+ = "DT" . "DIMID" JOIN "/BI0/D0DB6_C03H2" "D2" ON "F" . "KEY_0DB6_C03H2" = "D2" . "DIMID" JOIN "/BI0/D0DB6_C03H3"
C &+ "D3" ON "F" . "KEY_0DB6_C03H3" = "D3" . "DIMID" JOIN "/BI0/D0DB6_C03H4" "D4" ON "F" . "KEY_0DB6_C03H4" = "D4" .
C &+ "DIMID" JOIN "/BI0/D0DB6_C03H5" "D5" ON "F" . "KEY_0DB6_C03H5" = "D5" . "DIMID" JOIN "/BI0/D0DB6_C03H7" "D7" ON
C &+ "F" . "KEY_0DB6_C03H7" = "D7" . "DIMID" JOIN "/BI0/D0DB6_C03HP" "DP" ON "F" . "KEY_0DB6_C03HP" = "DP" . "DIMID"
C &+ WHERE ( ( ( ( "DT"."SID_0CALDAY" = 20170805 ) ) AND ( ( "DT"."SID_0CALMONTH" = 201708 ) ) AND ( ( "DP"."SID
C &+ _0CHNGID" = 0 ) ) AND ( ( "DP"."SID_0REQUID" <= 258848 ) ) AND ( ( "D2"."SID_0SMD_LSID" = 42 ) ) ) ) GROUP BY
C &+ "DT"."SID_0CALDAY" ,"DT"."SID_0CALMONTH" ,"DT"."SID_0CALQUARTER" ,"DT"."SID_0CALWEEK" ,"DT"."SID_0CALYEAR" ,"D2".
C &+ "SID_0SMD_LINS" ,"D2"."SID_0SMD_LSID" ,"D3"."SID_0SMD_SPHH" ,"D2"."SID_0SMD_LCNA" ,"D2"."SID_0SMD_LCVP" ,"D2"."SID
C &+ _0SMD_LMIP" ,"D2"."SID_0SMD_LMNA" ,"D2"."SID_0SMD_LMPP" ,"D2"."SID_0SMD_LPNA" ,"D2"."SID_0SMD_LPRP" ,"D3"."SID_0SM
C &+ D_SHOS" ,"D3"."SID_0SMD_SINA" ,"D3"."SID_0SMD_SITY" ,"D3"."SID_0SMD_SMDT" ,"D3"."SID_0SMD_SNNA" ,"D3"."SID_0SMD_SN
C &+ TY" ,"D4"."SID_0SMD_AEX" ,"D4"."SID_0SMD_AMEX" ,"D4"."SID_0SMD_AEC" ,"D4"."SID_0SMD_ASID" ,"D4"."SID_0SMD_ATIM" ,"
C &+ D4"."SID_0SMD_AWID" ,"D2"."SID_0SMD_LCID" ,"D2"."SID_0SMD_LCNR" ,"D2"."SID_0SMD_LTST" ,"D5"."SID_0DBH_DBNA" ,"D5".
C &+ "SID_0DBH_DBREL" ,"DT"."SID_0WEEKDAY1" ,"F"."KEY_0DB6_C03H6" ,"D3"."SID_0DBH_RHOST" ,"F"."KEY_0DB6_C03H8" ,"D7"."S
C &+ ID_0DB6_MEMGRP" ,"D7"."SID_0DB6_MEMLVL" ,"D7"."SID_0DB6_MEMPOL" ORDER BY "S____003" , "S____004" , "S____005" , "
C &+ S____006" , "S____007" , "S____008" , "S____009" , "S____034" , "S____047" , "S____048" , "S____049" , "S____050"
C &+ , "S____051" , "S____052" , "S____053" , "S____056" , "S____057" , "S____058" , "S____059" , "S____060" , "S____06
C &+ 1" , "S____082" , "S____084" , "S____090" , "S____091" , "S____092" , "S____093" , "S____110" , "S____111" , "S___
C &+ _112" , "S____236" , "S____237" , "S____399" , "S____415" , "S____1463" , "S____1464" , "S____1465" , "S____1466"
C &+ , "S____238" /* <OPTGUIDELINES><DEGREE VALUE="ANY"/> </OPTGUIDELINES> */
C &+ cursor type= HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=2, op_type=18, read_only=0
LINE.jpg


Read more...

Environment

  • SAP NW BW 7.x
  • DB2 any version

Product

SAP NetWeaver all versions ; SAP Solution Manager 7.0 ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

arithmetic overflow E2E_HK_CONTROLLER solman solution manager , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BW-BEX-OT , OLAP Technology , How To

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.