lock table overflow

[Former Member]

Hi,

We are getting lock table overflow error for our ECC system.

below  is the error.

[Thr 140076079828384] Tue Nov 25 07:22:47 2014

[Thr 140076079828384] *** ERROR => EnqueCluster: ArgTable overflow

[enxxmenq.h   2011]

[Thr 140076079828384] ***LOG GEA=>  [enxxmenq.h   2031]

[Thr 140076079828384] ***LOG GZZ=> EnqueCluster: rtc=16 [enxxmenq.h  

2032]

[Thr 140076079828384] *** ERROR => EnqueCluster: ArgTable overflow

[enxxmenq.h   2011]

[Thr 140076079828384] ***LOG GEA=>  [enxxmenq.h   2031]

[Thr 140076079828384] ***LOG GZZ=> EnqueCluster: rtc=16 [enxxmenq.h  

2032]

[Thr 140076079828384] *** ERROR => EnqueCluster: ArgTable overflow

[enxxmenq.h   2011]

[Thr 140076079828384] ***LOG GEA=>  [enxxmenq.h   2031]

[Thr 140076079828384] ***LOG GZZ=> EnqueCluster: rtc=16 [enxxmenq.h  

2032]

enque table size is appropriatly set in system.

enque/table_size : 500000

When we checked in SM12 >> statistics, maximum number of lock entries

value are as follows.

Maximum Number of Lock Entries 56415

Maximum Fill level         56415

Not sure why Max Number of Lock entries are showing so low even though

enough value is set in enque/table_size.

Environment Description.

SAP Version : ECC 6.0 EHP6

Installed on HA environment.

Kernel : 721 patch 201

Br,

Koushal Solanki

[AbhishekGupta1 · Accepted solution]

Hi Koushal,

As you mentioned that you are using HA solution, I think you will be having separate ASCS profile.

check if you have mentioned enque/table_size parameter only in ASCS profile and its value is 500000.

As per my understanding, some other value is mentioned in default profile which is picked up and showing you different result then expected.

For changing this value in ASCS profile, you don't need to restart whole system, just freeze cluster and restart ASCS services which should come up with in a minute.

Regards,

Abhi

[Former Member]

Hi Abhishek,

I will try to take restart and check if it will solve the issue.

Br,

Koushal Soalnki

[former_member188883]

Hi Koushal,

What is the value for enque/table_size. ?

Regards,

Deepak Kori

[Former Member]

Hi,

As i have mentioned in my post.

enque table size is appropriatly set in system.

enque/table_size : 500000

Br,

Koushal Solanki

[former_member188883]

Hi Koushal,

It looks to be  more of a SAP kernel issue. You existing kernel patch is 201.

Could you please update the same to 334 and check the results.

Regards,

Deepak Kori

[Former Member]

Hi,

Other system which are on same kernel patch level are working fine.

there Max Number of Lock entries are showing correctly.

and this production system so we cant patch kernel to latest one.

Br,

Koushal Solanki

[Sriram2009]

Hi

Could you check the SAP KBA 1565578 - Lock Table Overflow

1903553 - Standalone Enqueue Server (ENSA) and snapshot packages

97760 - Enqueue: Performance and resource consumption

BR

SS

[Former Member]

Hi Sriram,

Thanks for you reply.

I have already gone through given notes.

In all notes they are mentioning to increase the value enque/table_size, which is already high in our case.

Issue is that even after this much high value "Max Number of Lock entries" is very less i.e. 56415

Br,

Koushal Solanki

[Sriram2009]

Hi

Is this any major data upload is going on the system? or you can do full restart and then check the system, usage of lock table.

In which OS are you having cluster?

BR

SS

[Sriram2009]

Hi

Check this SCN thread

BR

[Former Member]

Hi,

Enqeue server is on Linux host.

This is production system so we cant take restart immediately.

Br,

Koushal Solanki

[Sriram2009]

Hi

Its already in Cluster environment so you can move the cluster resource to node 2, do the restart node 1 and same way in other node 1 I thing you may require to perform off peak time. and then check the lock overflow

BR

SS

[alwina_enns]

Hello Koushal,

in which profile enque/table_size is set? It should be set in the profile, which is read by the enqueue service.

Regards,
Alwina