enque/table_size error

[Former Member]

hi,

i have a problem that the enque/table_size is 32000 but the error is lock table overflow?

the enque/table_size is max value?

thanks in advance

Ferhan

[Former Member · Accepted solution]

This parameter defines the size of the lock table that is held in

main memory by the enqueue server.

The size of the lock table limits the maximum number of lock

entries, In the case of an overflow of the lock table, you should check

whether the update server is working correctly, since the lock table

can grow in size very quickly if updates stop. If the cause is not

update problems, you can use this parameter to increase the size of

the lock table.

You can view the fill level of the lock tables using the statistics

functions of lock management (transaction SM12 -> Extras ->

Statistics).

This parameter can be increased up to a maximum of 102400

[Former Member · Accepted solution]

i set the parameter is 64000. but the sap system not open. again set 32000. why can not open?

thanks

[Former Member · Accepted solution]

I did not get you .. did u increase the parameter in RZ10 - instance profile and bounce SAP ? Then only it will be active..Did u check in sm12 if update is active ?

[Former Member · Accepted solution]

last week, i increased the parameter in RZ10, the enque/table_size was 62000 and restart system. then the system was not open. and again the paramater was 32000. the system was open.

thanks

Ferhan

[former_member475159 · Accepted solution]

Hi Ferhan,

You need to set the following parameter in instance profile of application server

enque/process_location = REMOTESA

Please also check the below link

http://help.sap.com/saphelp_webas630/helpdata/en/cb/68edd90237c04aa9591469a4584cd1/content.htm

Also check the SAP note

746138

Thanks

Debdeep

[Former Member · Accepted solution]

what is the current value of parameter ? what u mean by now system is open ?

[Former Member · Accepted solution]

not have a the parameter enque/process_location = REMOTESA in instance. i must to add the parameter in insatabce

thanks.

[Former Member · Accepted solution]

Debdeep,

may I ask what makes you believe that Ferhan is using a Standalone Enqueue Server, as described in your link?

That's a rather rare configuration.

[Former Member]

we set the parameters; and resolved.

abap/buffersize : Program Buffer Size

enque/table_size

ipc/shm_psize_10

ipc/shm_psize_40 Size of shared memory segment

[Former Member]

check note no 746138

do u have application servers: if yes then chage the value of these parameters at application server too

enque/process_location = REMOTESA

enque/serverhost =

enque/serverinst =

Thanks

presu

[Former Member]

yeah. i set them last week...

[Former Member]

we set the parameters;

abap/buffersize : Program Buffer Size

enque/table_size

ipc/shm_psize_10

ipc/shm_psize_40 Size of shared memory segment

and can set enque/table_size 96000.

[Former Member]

Hi,

see sizing of lock table

http://help.sap.com/saphelp_nw70/helpdata/EN/44/5efc11f3893672e10000000a114a6b/content.htm

SurendraJain

[Former Member]

the problem is solved that dev. t-code is bad. .

next week, i will set enq. loca. parameter .

thanks

ferhan

[Former Member]

hi,

i set the parameter enque/process_location = REMOTESA and the enque/table_size was 62000 and restart system. then the system was not open. and again the paramater was 32000. the system was open.

thanks in advance

Ferhan

[Former Member]

. then the system was not open. and again the paramater was 32000. the system was open.

what do you mean by this ?

[Former Member]

the system is SAP PRO sistem...