Hi All,
I'm installing SAP ERP EPH5 in HA environment.
The Central Service ASCS installed successfully, however, the enque server cannot be started correctly. (message server can be started)
Here is the output of dev_eqnsrv
--------------------------------------------------- trc file: "dev_enqsrv", trc level: 1, release: "720" --------------------------------------------------- sysno 00 sid PRD systemid 324 (IBM RS/6000 with AIX) relno 7200 patchlevel 0 patchno 110 intno 20020600 make multithreaded, Unicode, 64 bit, optimized pid 16056526 [Thr 01] Wed Feb 15 12:33:00 2012 [Thr 01] profile /usr/sap/PRD/SYS/profile/PRD_ASCS00_PRDAP [Thr 01] hostname P720N1 [Thr 01] Listen successful on port/service sapdp00 [Thr 01] Wed Feb 15 12:33:01 2012 [Thr 01] EnqInitCleanupServer: Shm of enqueue table (rc = 3) does not exist, nothing to clean up [Thr 01] *** ERROR => EnsMemObj::Initialize (else): allocation of 163920080 Bytes failed for the ft table, please c heck parameters enque/max_query_requests and enque/server/query_block_size. Please see SAP note 834589 for parameter configuration suggestions [ensutil.cpp 503] [Thr 01] *** ERROR => main: Server initialisation failed! Errortext:"EnsMemObj: internal error detected at ensutil.cpp:509 Errorinfo: "EnsMemObj::Initialize"" [enservmain. c 248]
Here is the ASCS profile
SAPSYSTEMNAME = PRD SAPSYSTEM = 00 INSTANCE_NAME = ASCS00 DIR_CT_RUN = $(DIR_EXE_ROOT)/run DIR_EXECUTABLE = $(DIR_INSTANCE)/exe SAPLOCALHOST = PRDAP #----------------------------------------------------------------------- # SAP Message Server parameters are set in the DEFAULT.PFL #----------------------------------------------------------------------- ms/standalone = 1 ms/server_port_0 = PROT=HTTP,PORT=81$$ #----------------------------------------------------------------------- # SAP Enqueue Server #----------------------------------------------------------------------- enque/table_size = 64000 enque/snapshot_pck_ids = 1600 enque/server/max_query_requests = 5000 enque/server/max_requests = 5000 enque/async_req_max = 5000 enque/encni/threadcount = 4 rdisp/enqname = $(rdisp/myname) ssl/ssl_lib = $(DIR_EXECUTABLE)$(DIR_SEP)$(FT_DLL_PREFIX)sapcrypto$(FT_DLL) sec/libsapsecu = $(ssl/ssl_lib) ssf/ssfapi_lib = $(ssl/ssl_lib) enque/server/replication = true ipc/shm_psize_10 =236000000
I have tried to increase the max_requests but the server still cannot be started.
Please advise what should i do to make the enque server start again.
Thanks,
Halu
Hi,
Please adopt the parameters based on OSS notes 920979. I had same issue which got resolved with these note
Regards
Purna
Also please refer to 1029237,1043968
Regards
Purna
Hi Purna,
Thanks for the note information.
I have tried to change the parameter as follow
from
enque/table_size = 64000 enque/server/max_query_requests = 5000 enque/server/max_requests = 5000
to
enque/table_size = 500000 enque/server/max_query_requests = 5000 enque/server/max_requests = 17500
But with the similar output as before:
--------------------------------------------------- trc file: "dev_enqsrv", trc level: 1, release: "720" --------------------------------------------------- sysno 00 sid PRD systemid 324 (IBM RS/6000 with AIX) relno 7200 patchlevel 0 patchno 110 intno 20020600 make multithreaded, Unicode, 64 bit, optimized pid 11469002 [Thr 01] Wed Feb 15 13:25:19 2012 [Thr 01] profile /usr/sap/PRD/SYS/profile/PRD_ASCS00_PRDAP [Thr 01] hostname P720N1 [Thr 01] Listen successful on port/service sapdp00 [Thr 01] Wed Feb 15 13:25:20 2012 [Thr 01] EnqInitCleanupServer: Shm of enqueue table (rc = 3) does not exist, nothing to clean up [Thr 01] *** ERROR => EnsMemObj::Initialize (else): allocation of 573720080 Bytes failed for the ft table, please c heck parameters enque/max_query_requests and enque/server/query_block_size. Please see SAP note 834589 for parameter configuration suggestions [ensutil.cpp 503] [Thr 01] *** ERROR => main: Server initialisation failed! Errortext:"EnsMemObj: internal error detected at ensutil.cpp:509 Errorinfo: "EnsMemObj::Initialize"" [enservmain. c 248]
In my case, the enque server cannot be started, there is no process listenon port sapdp00 (3200)
Cheers,
Halu
Hi,
Please try below parameters.
enque/table_size = 300000
enque/snapshot_pck_ids = 1600
enque/server/max_query_requests = 1000
enque/server/max_requests = 8800
enque/async_req_max = 5000
enque/encni/threadcount = 4
enque/server/req_block_count = 2000
enque/enq-queue/size = 5000
enque/server/query_block_count = 2000
enque/server/query_block_size = 20000
Regards
Purna
Hi,
Thanks for the paremeter, however, another error message was occurred:
--------------------------------------------------- trc file: "dev_enqsrv", trc level: 1, release: "720" --------------------------------------------------- sysno 00 sid PRD systemid 324 (IBM RS/6000 with AIX) relno 7200 patchlevel 0 patchno 110 intno 20020600 make multithreaded, Unicode, 64 bit, optimized pid 12779610 [Thr 01] Wed Feb 15 13:52:26 2012 [Thr 01] profile /usr/sap/PRD/SYS/profile/PRD_ASCS00_PRDAP [Thr 01] hostname P720N1 [Thr 01] Listen successful on port/service sapdp00 [Thr 01] Wed Feb 15 13:52:27 2012 [Thr 01] EnqInitCleanupServer: Shm of enqueue table (rc = 3) does not exist, nothing to clean up [Thr 01] ShadowTable:attach: ShmCreate - pool doesn't exist [Thr 01] initialize_global: Enqueue server started with replication functionality [Thr 01] Enqueue: EnqMemStartupAction Utc=1329285147 [Thr 01] EnqLockTableCreate: create lock table (size = 307200000) [Thr 01] EnqLockTableMapToLocalContext: enque/use_pfclock2 = FALSE [Thr 01] *** ERROR => InitEntryMarkedForDel: malloc(1070140) failed [enxxmini.h 222] [Thr 01] ***LOG GEA=> [enxxmini.h 223] [Thr 01] ***LOG GZZ=> InitEntryMarkedForDel: malloc(1070140) failed [enxxmini.h 224] [Thr 01] ***LOG GZZ=> ENSA: PID = 12779610 [enservglob.c 808] [Thr 01] *** ERROR => initialize_global: failed to initialize the enqueue table: rc=8 [enservglob.c 811] [Thr 01] *** ERROR => main: Server initialisation failed! Errortext:"error at server initialisation detected at enservglob.cpp:812 Errorinfo: "initialize_global: failed to initialize the enqueue table: rc=8 "" [enservmain.c 248]
The enqueue table cannot be initialized.
Seems memory cannot be allocated.
Cheers,
Halu
Below URL has more details HA enqueue setup
http://help.sap.com/saphelp_nw04s/helpdata/en/e3/d49d775bf44a8fb37d77478d218b9a/content.htm
Regards
Purna
Hi,
This looks like shared memory issue. Can you try to run "cleanipc <XX> remove" and then start the system.
<XX> is instance number.
Regards,
Vijaya
Hi,
I think you have issues with kernel mismatch between EnQ server instance and CI. This can happen in a clustered environments. After the upgrade, we have to manually copy the kernel files to enq instances.
Please check the kernels in ASCS instance.
Also refer to note 1463227.
Regards,
Ramesh
www.rajamohan.com
Hi ,
Please check the following :-
1) Kernel on both ASCS Lpar and ERS Lpar should be same.
2) Restart the ERS after cleaning all the processes running with <sid>adm.
Thanks
Gaurav
Hello,
We are facing same issue, can you please let me know how did the above issue got fixed ?
Thanks,
Kunal Salunkhe
I had the same issue and was solved checking/correcting the ulimit for the sidadm user
Regards
Andrea