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

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

• SAP NW BW 7.x
• DB2 any version

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