on 05-18-2011 3:06 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.