SAP BW :TSV_TNEW_PAGE_ALLOC_FAILED

[Former Member]

Dear All,

While uploading the data through Info Object in BI following Error occurs :

TSV_TNEW_PAGE_ALLOC_FAILED

No more storage space available for extending an internal table.

You attempted to extend an internal table, but the required space was

not available.

The amount of storage space (in bytes) filled at termination time was:

Roll area...................... 2790672

Extended memory (EM)........... 2002743520

Assigned memory (HEAP)......... 621071808

Short area..................... " "

Paging area.................... 24576

Maximum address space.......... 4243028256

So, Please reply me How to solve this issue ?

Regards,

Santosh

[Former Member · Accepted solution]

Hi Santosh,

Reduce the packet size and reload the data again. This will solve the issue.

Regards,

Harish.

[nishant_jain3]

Hi,

this is due to the required space is not available.

if this is not the standard report, try to optimize the sql query which is accessing large amount of data.

It is not recommendable to keep on increasing parameter size in production system.

Best you can try is reduce the packet size and rerun the job. it should work.

if this is not working contact to Basis.

[former_member188080]

check following threads as well

http://scn.sap.com/thread/1628043

http://scn.sap.com/thread/1856744

http://scn.sap.com/thread/1680791

http://scn.sap.com/thread/1273642

This is basis related issue..they will check log and will tell u which table at DB02 or database level is issue.

also they need to extend the internal table space if required..

Thanks and regards

Kiran

[snitwipro]

Hi,

  This is entirely basis related issue. This happens only because of huge data volume and if the application server has no more memory to append the internal table.Get the table name from the Dump overview and check the % memory utilisation for that table in the Tcode DB02 under tablespace section. It is nearly 100% I guess.

   Consult with your basis guys to extend the table space. Then repeat the load.

Cheers

Sourav

[former_member184548]

Hi Santosh

Things you can do o get rid of above problem :

1. Check the logic of data extractor/loader and if you see there is some fine tuning need then do it.

2. provide list of tables which are being used in this extraction or loading and ask your basis team to check there update statstics and index fragmentation

3. See if there is any expensive SQL statement in ST04 which you can tune. Sometimes the SQL statement may choose worng index which it should not. In such cases you may need to see the where clause filed and update statistics of table

4. Check if another heavy activity is running when you are doing your extraction activity. If so then try to schedule load at some different time

5.  If all the above things are fine then increase the value of parameter abap/heap_area_nondia, and ztta/roll_extension.

Thanks

Atul

[Former Member]

Hi Atul,

Current paramaeer size as below :

1) ap/heap_area_nondia  : 2000000000

2) ztta/roll_extension         : 2000000000

Please rfeeply me How much shall I Increase the value ?

If any dependencies is there , i.e Other parameter value also increase ?

Regards,

Santosh

[former_member184548]

Hi Santosh

Parameter change is the last solution recommended by SAP. Please check the other ways to solve the issue and if it is not working then change the below parameter value.

You can increase the

abap/heap_area_nondia  : 4000000000
ztta/roll_extension         : 3000000000

and also increase the abap/heap_area_total current value + 2 GB

[Former Member]

Hi Atul,

Today I change the parameters asyou suggested ,

but restart the server follo. error occurs :

3739) Waiting for Child Processes to terminate.

Instance on host CFLBP01 started

(3739) **** 2012/05/19 15:43:44 Child 3801 terminated with Status 0 . ****

(3801) **** 2012/05/19 15:43:44 No RestartProgram command for program 1  ****

Please reply me How to rectify the same ?

Regards,

Santosh

[former_member184548]

Hi Santosh

Are you able to solve the problem. Have you tried to do cleanipc or host restart. Is the problem still persist. please provide the important logs in work folder

Thanks

Atul

[Former Member]

Hell Atul,

We revert the old parameters , Restart the Host , SAP Instance is UP.

Tablespace is also checked. All tablespace are beow 88%.

Still My problem is not solved.

Regards,

Santosh

[Former Member]

Hi

You can go to transaction DB02 and check the table space availability.

You can inform the basis team to extend the table space.

[Former Member]

Hi,

Usually you get this error, when the memory parameters are not tuned appropriately.

Please inform the basis team to tweak the memory values , and then run the load. It should go fine.

[JasonLax]

This thread is currently in SCN Support which is the support space for SAP Community Network, not SAP products or topics.  Please move it to an appropriate space where topic experts will see and reply to it: SCN Site Index

[JasonLax]

Moving from SCN Support to SAP NetWeaver Business Warehouse