No more storage space available for extending an internal table - with APD

[Former Member]

Hi,

We have an APD built on a query with no restrictions on Material Stock Cube (0IC_C03) and storing the output file (CSV) in Application Server. Till now its working fine without any issues.

But recently we have changed the query to include 3 more columns (now total 15) to query and one restriction at query level.

Now we are facing issue with APD execution and its running into error messaging "No more storage space available for extending an internal table - TSV_TNEW_PAGE_ALLOC_FAILED".

From the dump, came to know that its due to internal memory issue and not with physical memory, so please guide how to fix this issue.

Thanks in Advance.

regards,

RAO

[Former Member · Accepted solution]

Maybe you can use the Notes: 794257 / 751577 (deals with query).

There is another one: 741864

[Former Member · Accepted solution]

Hi,

Thanks for the info.

We have made changes to APD that its NOT going to use Memory while data process and also tried with Processing data by packages based on Plants with size of 10000. Even then also same problem.

We are able to run the APD without any error in DEV, but not in QA.

I've made changes to query to include one of the display attribute (Price Control) of Plant Material with No Display for Plant Material and included Product Hierarchy in Filter area and restricted to one value. Will it be any impact due to these changes.

Appreciate quick response.

__

RAO

[former_member183012]

Hi PV Rao,

We also faced this issue.

possible solutions

1)As you Basis person to increse memory parameter.

if you are still facing same problem then

Break your APD's means create similar copy of APD and run with diffrent variant which will load small amount  of data each time and you did not face memory issue.

Please try this.

[Former Member]

Hi ,

You can also check SM66, in case any other process is running which is utilizing storage space, either wait for that process to complete or stop that. then run APD.

Regards,

Amit.

[Former Member]

Hi,

I have had similar issue. The performance Setting of unchecking "Process Data in Memory" helps only to a small extent. The APD run is successful in DEV most probably due to the lesser data volume as compared to QA.

You can analyze if there is any scope of improving the design of the APD, check intermediate results at each node, see at which node the APD is failing, check if blank records are filtered out at joins (these can be major source of data explosion), use as much filters as possible in the early stages of APD.

If after doing all these optimization the APD is still failing ask BASIS to increase the parameter for  "Memory allocated to each user" and try scheduling the APD when the memory consumption in the system is relatively less.

Regards,

Sid

[Former Member]

I  faced the same issue. do you guys have any updates?

Thanks