2109881 - APD: Bex Query with active Bex conditions causes memory and performance problems | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2109881 - APD: Bex Query with active Bex conditions causes memory and performance problems

Symptom

1) Executing an APD with a datasource based on a BEx query runs into memory and performance problems, the following descriptions have been sent:

  • APD with query as source exhausts memory such as TSV_TNEW_PAGE_ALLOC_FAILED dumps
  • APD performance issue after upgrade to 730 or 740
  • APD long processing followed by TIME_OUT dumps
  • APD doesn't run though when query has an active condition
  • APD Issue: No more storage space available
  • APD does not return result (strange MDX statement)

2) Report  RKEBW3RE causes performance issues in backend BW system:

  • CL_RSR_MDX_FILTER_SETXX long runner

Read more...

Environment

SAP BW 7.x

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

memory, TSV_TNEW_PAGE_ALLOC_FAILED, performance, runtime, TIME_OUT, RKEBW3RE, CL_RSR_MDX_FILTER_SETXX, RSCRM_BAPI, APD, RSANWB , KBA , apd , BW-EI-APD , Analysis Process Designer , BW-BEX-OT-MDX , MDX,OLAP-BAPI,OLE DB for OLAP , BW-EI-RTR , Retraction , CO-PA-TO , Tools , 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.