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

"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