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

• 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

• 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

KBA , flat, infocube, conversion, rsrt , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem