cancel
Showing results for 
Search instead for 
Did you mean: 

APD returns ABAP Error: TSV_TNEW_PAGE_ALLOC_FAILED

Former Member
0 Kudos

Hi

I'm trying to run APD for a virtual cube.

The design of the APD is as follow:

1. Read a Query (FM of a virtual cube query)

2. Filter the value

3. Aggregate the value

4. Output to text file

If I run RSRT to read the query, I'm able to get the query, and it's returning 936,210 rows.

However, when I run it from APD, it threw me the following errors:

Error analysis

The internal table "\CLASS=CL_RSCRMBW_BAPI\METHOD=GET_AXIS_DATA_V2\DATA=LT_MPP"

could not be further extended. To enable

error handling, the table had to be delete before this log was written.

As a result, the table is displayed further down or, if you branch to

the ABAP Debugger, with 0 rows.

At the time of the termination, the following data was determined for

the relevant internal table:

Memory location: "Session memory"

Row width: 652

Number of rows: 5,027,712

Allocated rows: 5,027,712

Newly requested rows: 16 (in 1 blocks)

Any idea what I can do to rectify this?

Your advice is much appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

desgallagher
Contributor
0 Kudos

Hello,

Please read carefully as well the performance information provided in the SAP notes 794257 and 751577, these are very

important when you have memory problems or performance issues with the APD.

Kind Regards,

Des

Pravender
Active Contributor
0 Kudos

Hi,

Its because of memory not available to accomodate the large no of records. Sometimes if you will try to execute the APD multiple time (once it fails), then in few cases it may execute successfully.

you can try 2 things:

First, uncheck the check box "Process data in memory", you can see this in RSANWB ---> GOTO --> Performance settings. Try executing the APD after this.

Even after this if APD does not execute, then reduce the data set size, which means put some filters on the query and then see with how much data APD can execute successfully(Try executing the APD step by step to get the clear picture where exactly it is failing). In this case you may need to execute the APD multiple times for various values in query filters, to get the complete data set.

Pravender

Edited by: Pravender on May 18, 2011 11:55 AM

Former Member
0 Kudos

Hi,

This is a problem related to memory of internal table.

Please check the below links

Hope this helps

Thanks.