memory problem

[dudmswl77]

Hi experts,

I have some problem.

Batch program is running at dawn, and I am experiencing a resource bottleneck due to memory issues.

Message text says "No more memory available to add rows to an internal table."

Memory spec
- System physical memory : 64GB
- Memory per ID : 4GB

<My Question>
1. How can i solve this problem?
2. Is there any other ways than increasing the memory??
3. Generally, How much capacity is required to transfer more than 8 million data from SAP to Other program ?

[Sandra_Rossi]

The amount of memory is limited and you can't increase it. Why does your program (if it's custom) consume so much memory? Why can't you make it consume less?

[sumitjais · Accepted solution]

Hi dudmswl77,

You need to check work process trace (refer 2194685 ) and ST22 dump for the analysis.

Batch work processes consume memory in the order- Roll Memory, Heap Memory, Extended Memory.

What are the values for PHY_MEMSIZE,em/initial_size_MB and abap/heap_area_nondia and their usage at the time of the dump? You may have to increase the heap(nondia) memory.

[dudmswl77 · Accepted solution]

Hi Sumit Jaiswal.


| The amount of memory (in bytes) used at termination time was:

| Roll area...................... 0 |

| Extended memory (EM) 4001008232 |

| Assigned memory (HEAP) 4194930864 |

| Short area..................... |

| Paging area.................... 40960 |

| Maximum address space.......... 18446744073709551615 |

| If the error occurs in a non-modfied SAP program, you might be able to find a solution in the SAP Notes system.

If you have access to the SAP Notes system, check there first using the following keywords:

"TSV_TNEW_PAGE_ALLOC_FAILED"

"ZMMCR6014" bzw. ZMMCR6014F01

"GET_COLLECT_DATA"

This is memory usage at the time of dump.

Can you explain how can i resolve this problem?

[sumitjais · Accepted solution]

Your job has used 8G (i.e. 4G heap and then 4G extended) and then terminated. For 8 million data, usage of 8G memory is not unusual.

Could you please share the parameter values for PHY_MEMSIZE,em/initial_size_MB and abap/heap_area_nondia?

[dudmswl77 · Accepted solution]

Thank you for your help.

I'm so sorry but i don't know about how can i get that information ,

"Could you please share the parameter values for PHY_MEMSIZE,em/initial_size_MB and abap/heap_area_nondia?"

Terminal..........

Character set C

SAP kernel....... 745

Created on....... Jan 23 2017 16:12:28

Created at....... Linux GNU SLES-11 x86_64 cc4.3.4 use-pr170123

Database version OCI_112, 12.1.0.2.0, V2, default

Patch level....... 400

Patch text.......

Database............. ORACLE 11.2.*.*.*, ORACLE 12.*.*.*.*

SAP database version. 745

Operating system... Linux

Memory consumption

Roll.... 0

EM...... 4001008232

Heap.... 4194930864

Page.... 40960

MM used. 8180281440

MM free. 8806376

Is this right,,,?

[sumitjais · Accepted solution]

Go to T code RZ11, enter the parameter name and look for current value.

[dudmswl77 · Accepted solution]

phys_memsize

em/initial_size_MB

[dudmswl77 · Accepted solution]

abap/heap_area_nondia

This is parameter details!

[sumitjais · Accepted solution]

Your job has used almost 8 G ( 4 GB limited by abap/heap_area_nondia followed by 4 Gb of the extended memory quota limited by ztta/roll_extension) before it terminated. For 8 million data transfer, this is not unusual memory usage. As you have sufficient memory with application (64 G of which 43 G is extended), you may increase the parameter abap/heap_area_nondia from 4G to 7-8 G i.e. abap/heap_area_nondia = 7516192768 or 8589934592 ( the parameter change requires application restart).

If above does not work, you should fine tune the program to transfer the 8 million data in multiple go.

[dudmswl77 · Accepted solution]

Thank you for your help, experts!

Finally i have one more question.

abap/heap_area_nondia from 4G is not enough for tranafer 3 million data?