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:
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
Read more...
Environment
- SAP NW BW 7.x
- DB2 any version
Product
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.