MAIN_SHDCRE/SUBMOD_SHDDBCLONE/ADJUSTCHK_EHPI - EXSORT_NOT_ENOUGH_MEMORY

[Former Member]

Hello Friends

We are upgrading our ECC 6.0 system to EHP7 sp02.

We are using SUM tool for the same and SUM version is 1.0 SP11, AIX 6.1 TL09, ORACLE 11.2.0.3

Our environment is installed as CI DB on different servers.

I am in preprocessing stage and in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/ADJUSTCHK_EHPI I am getting dump EXSORT_NOT_ENOUGH_MEMORY.

i have already followed 193529 - Sort as of 4.5A/EXSORT_NOT_ENOUGH_MEMORY but no success.

Our memory parameters are as below.

em/initial_size_MB            8184       MB

em/blocksize_KB               4096       kB

em/address_space_MB           4092       MB

ztta/roll_extension           2000000000 Byte

abap/heap_area_dia            4000000000 Byte

abap/heap_area_nondia         2000000000 Byte

abap/heap_area_total          6000000000 Byte

abap/heaplimit                40000000   Byte

abap/use_paging               0

Please suggeat if I am missing something.

Regards

SS

[Former Member · Accepted solution]

Hi Guys,

Thanks for your replies.

Problem got resolved.

SAPSTARTSRV was running with limited ulimits of SIDADM. I had to kill that process and restarted with SIDADM which was haing ulimit -a as unlimited. ans restarted the SAP system and continued with SUM. No more memory errors.

[divyanshu_srivastava3 · Accepted solution]

Hi,

I think I told you to check ulimits.

Divyanshu

[Former Member · Accepted solution]

Hi Divyanshu,

But issue was ulimit -a at os level  was showing unlimited. But when I checked at SAP level that too with sapcontrol then it gave the real issue and I had to restarte the SAPSTARTSRV. Even it was not helping.

And in last killing the sapstartsrv and restaring helped.

Thanks for your help.

Regards

SS

[Former Member]

Hi All.,

Thanks for the inputs. Our kernel is 720_REL sp401. Kernel upgrade is last option.

Gaurav I had already checked the notes suggested by you but no success.

But I checked the below and felt that some parameters setting should help in this.

I have opened this with SAP and will update the thread accordingly.

Meanwhile if someone has any other inputs then please share.

Regards

SS

[Former Member]

Hi SS,

Can you please check SHMMIN, SHMMAX, SHMMNI or SHMSEG values which may also cause problems.

Please paste values.

Regards

KSK

[Former Member]

Hi KSK,

Thanks for reply. Please see below values. I hope you were asking the same. Let me know if you need something else.

ES/SHM_DISC_BLK_MIN = 0

ES/SHM_DISC_SEG_MIN = 10

ES/SHM_DISC_BLK_MAX = 4

ES/SHM_DISC_SEG_MAX = 4096

ES/SHM_SYS_FREE_MAX = 20

ES/SHM_DISC_BLOCK_PER_SEG = 2

ES/SHM_DISC_SEG_INIT_CNT = 100

ES/SHM_IDLE_SEGMENT = 10

ES/SHM_MAX_PRIV_SEGS = 15

ES/SHM_MAX_SHARED_SEGS = 1

ES/SHM_PROC_SEG_COUNT = 16

ES/SHM_SEG_COUNT = 8192

ES/SHM_SEG_SIZE = 4096

ES/SHM_USER_COUNT = 8182

rdisp/PG_SHM = 8192

rdisp/ROLL_SHM = 16384

Regards

SS

[former_member182657]

Hi,

Please share kernel details and if possible try to upgrade the kernel to the latest available as already suggested by   and retry the phase .Meanwhile follow SAP Notes  1563583 - SYSTEM_NO_TASK_STORAGE, DBIF_RSQL_NO_MEMORY, EXSORT_NOT_ENOUGH_MEMORY

1147109 - Heap memory shortage

323816 - AIX: User limit settings

Hope this will help you.

Regards,

Gaurav

[divyanshu_srivastava3]

Hi,

Can you paste the stage logs and upload full dump.

Divyanshu

[Former Member]

Hi Divyanshu,

Thanks for reply. Please see attached full dump. Also what to you mean by stage logs ?

Do you need any log file from SUM directory ?

Regards

SS

EXSORT_NOT_ENOUGH_MEMORY.txt.zip

[divyanshu_srivastava3]

Hi,

Can you change the value of "abap/heap_area_nondia "

Reduce it to 1500000000 Byte, for now

Change ulimit data of sidadm to unlimted.

Then restart and try again

Regards,

Divyanshu

[Former Member]

Hi Divyanshu,

ulimit -a for sidadm was already unlimited. And reduced the ,abap/heap_area_nondia to 1500000000 Byte.

But it still failed.

ulimit -a

time(seconds)        unlimited

file(blocks)         unlimited

data(kbytes)         unlimited

stack(kbytes)        unlimited

memory(kbytes)       unlimited

coredump(blocks)     unlimited

nofiles(descriptors) 32000

threads(per process) unlimited

processes(per user)  unlimited

Regards

SS

[divyanshu_srivastava3]

Can you check in the dump ?

Goto Internal notes in your dump and tell the value.

No more XXXXXXX bytes could be allocated for the sorting.  

Divyanshu

[Former Member]

No more 8388608 bytes could be allocated for the sorting.

This is correct as per note 193529 .

System tries to allocate 8MB chunks from heap memory. But question is why it not able to access heap memory because ST02 still shows Heap available even after reducing the nondia

Regards

SS

[divyanshu_srivastava3]

Hi,

I think this could be because of the kernel, as this all is now taken care by the kernel itself. May be an update to current level may solve the problem.

Also, what the maximum heap size per process ?

Can you check this "memlimits -v off".

We cannot run this DIALOG.

Refer: 789477 - Large extended memory on AIX (64-bit) as of Kernel 6.20

May be some adjustment might work.

Regards,

Divyanshu

[Reagan]

Update the SAP kernel to 720 EXT version and repeat the phase in SUM.

Regards

RB