Out of memory issues and ST22 Dump When Running Query in RSRT by changing READ MODE

Purpose :

To troubleshoot Out of memory issues and ST22 Dump When running Query in RSRT by changing READ MODE.

Overview:

You Execute the Query in RSRT and you get the ST22 Dump as below

TSV_TNEW_OCCURS_NO_ROLL_MEMORY,  TSV_TNEW_PAGE_ALLOC_FAILED

This issue happens while running query due to out of memory.

- To solve this, You have followed the instructions in the Note 185185 :  Application: Analysis of memory bottlenecks.

- You have also configured that single user can have maximum memory  but this query still cannot be run,

The issue is still not resolved.

Possible solution:

1. In checking the query in RSRT, the READ MODE used is 'Total Read'.

  (RSRT -> Query-> Technical Information -> Read mode)

2. Try setting  READ MODE X or H and this should allow the data to be read when needed and would significantly reduce the memory usage.

To make the change:

- RSRT -> Query Properties

- The change can also be made within Query Properties in BEX Query Designer.