TSV_TNEW_PAGE_ALLOC_FAILED dump in WDBU: Assortment listing

[Former Member]

Hi all,

when my SD consultants are executing WDBU either in background or foreground we are getting dump:

TSV_TNEW_PAGE_ALLOC_FAILED

details are as follows:

No more storage space available for extending an internal table.

Error anslysis

The internal table "???" 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: 1032

Number of rows: 6729552

Allocated rows: 6729552

Newly requested rows: 8 (in 1 blocks)

how to correct the error:

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

Roll area...................... 2718352

Extended memory (EM)........... 5002852296

Assigned memory (HEAP)......... 2000090624

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

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

Maximum address space.......... 4294967295

earlier the values for

ztta/roll_extension and abap/heap_area_total was 2 GB

for corrections i have made changes in the parameters as follows:

ES/TABLE SHM_SEGS

ztta/roll_extension 5000000000

abap/heap_area_total 5000000000

I have AIX OS and the RAM is 16 GB on this particualr application server, which is central Instance.

the swap space allocated is 40 GB.

please tell me what to do to resolve this particular issues.

regards,

Priya

[markus_doehr2]

> Extended memory (EM)........... 5002852296

> Assigned memory (HEAP)......... 2000090624

This means that you allocate 7 GB of memory - which is almost half of the available memory of the application server.

I'm not familiar with the specific SD application but I would check if you can decrease the amount of data to be processed (e. g. by date).

Markus

[Former Member]

there ios no date selection criteria.

I had a talk with my SD consultants they said selection criteria cant be narrowed down any further, infact they are processing just for 1 site, where as they are required to do it for multiple sites.

Regards,

Priya

[Former Member]

Hi,

The fact it is trying to shove more than 6.7 million rows into an internal is a worry apart from Marcus's comments about the internal memory allocation's which is a server killer....

Try to examine the source data and transaction..

Mark

[Former Member]

how can i examine the source data and transaction?

what all tjhings need to be examined for the same.

Regards,

Priya

[Former Member]

Hi,

Have a look at note: 1141853

Mark

[Former Member]

hi mark,

I implemented the note 1141853 but still the dump is coming.

Regards,

Priya

[Former Member]

Hi,

Have a look on OSS use a the transaction as the search query, there a few notes on it..

Mark

[Former Member]

Hi

The transaction has failed after using up ( Maximum address space.......... 4294967295) GB of memory while running in the background and foreground . as per SAP recommendations , the Work process should be able to perform its activity within the 4 gb available for each WP.

Can you please check with your SD consultants to run the same Tcode with lesser selection of data ( with more selection criterion like date range ) etc and have more number of jobs to get the data , instead of having one job , so that the WP execution is successful with the available max limits of memory.

Thanks

Rishi

[Former Member]

The selection criteria when you go to WBDU T-code are:

Assortment User:

sales organisation - we are specifying it

Distribution channel - we are specifying it

customer no. - site - we are just specifying one site

Assortment List:

Assortment List Type

Control Data:

Donot use cycle - we are ticking this option.

Generate Merged Versions

Parallel Processing

Max Number Of processes

Logon/ server Group - we are specifying the server the instance server.

what else can the selection criteria be narrowed down to.

Also in the dump when it says "The internal table "???" could not be further extended"what is table ??? means.

When i was going through SAP Notes i found few notes : 542669, 959104 , 740976. But these are applicable to ECC 500 and 470.mine is ECC 6.0 and our APPL level is 12.

What do you think can be done in this situation..

we are using just one site.

Regards,

Priya