SAP Knowledge Base Article - Preview

2654916 - DB2 LUW FEMS pushdown SQL0101N The statement was not processed because a limit such as a memory limit, an SQL limit, or a database limit was reached. SQLSTATE=54001

Symptom

  • dev_w## log
              C  *** ERROR in DB6Fetch[/bas/745_REL/src/dbs/db6/dbdb6.c, 4128] CON = 0 (BEGIN)
              C  &+     dsql_db6_array_fetch( SQLFetch ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0101N  The statement was not processed beca
              C  &+     use a limit such as a memory limit, an SQL limit, or a database limit was reached.  SQLSTATE=54001
              C  &+
              C  &+     WITH  /* Query with 775 FEMSes, 159 TERMs, 108 HIERs, 2 GROUPBYs on Z<object> */    "T_VIEW_0001P" AS (  SELECT . . .

  • BEx Analyzer Message Window
              Error reading the data of InfoProvider Z<object>      
              Errors occurred during parallel processing of query 31, RC:3
              Error while reading data; navigation is possible

  • BW - output test
              ESQL0101N The statement was not processed because a limit such as a memory
              EError reading hte data of InoProvider Z<object>
              EError while reading data; navigation is possible
              ICL_SQL_RESULT_SET >> Row:  Inc:  69 Prog:  NEXT_PACKAGE
              'No application data found

  • ST05 SQL Trace
              Category                            ABAP Programming error
              Runtime Errors                  STRING_OFFSET_TOO_LARGE
              Except.                               CX_SY_RANGE_OUT_OF_BOUNDS
              ABAP Program                 CL_ST05_TRACE_PROCESSOR_SQL===CP
              Application Component   BC-TWB_TST-P-PA

             
  • sometimes same FEMS pushdown queries succeed, thus above errors are intermittent

Read more...

Environment

  • DB2 LUW 11.01.0202 linux 64bit
       converted BLU cube objects to FLAT

  • SAP NETWEAVER BI 7.5 SP10
       BW FEMS (Form EleMent Selection) pushdown query

Product

SAP NetWeaver 7.5

Keywords

KBA , flat, infocube, conversion, rsrt , BW-SYS-DB-DB6 , BW DB2 Universal Database , 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.