SAP Knowledge Base Article - Preview

1967896 - Basic recipe for troubleshooting memory problems with BW Bex Queries (Information for support)


A BW Bex Query terminates with a memory related dump such as TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET or SYSTEM_NO_ROLL.

When facing memory problems with Queries, the main problem is that more data is requested than the current memory configuration allows.

In rare cases, SAP BW development can optimize the processing of the Queries because the data is requested in a suboptimal way.

Your initial analysis and SAP support's analysis will require the following ingredients:

  1. Ingredients for analysis:
    1. Memory required at the time of the dump and current memory configuration
    2. Technical ID of the Query; steps to replicate the dump
    3. Number of records/cells expected for this Query
    4. Reduced Query and Bex statistics
    5. List of memory intensive features the Query is using

For further analysis directions are required:

2. Directions for analysis

If the use of mass data cannot be avoided, you need:

3. Alternatives and Workarounds



  • SAP Netweaver - All Versions
  • SAP BW/4HANA - All Versions


SAP BW/4HANA all versions ; SAP NetWeaver all versions


"TSV_NEW_PAGE_ALLOC_FAILED" "STORAGE_PARAMETERS_WRONG_SET" "SYSTEM_NO_ROLL" "troubleshooting" "memory" "memory issue" , KBA , BW-BEX-OT , OLAP Technology , BW-BEX-ET , Enduser Technology , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , 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.