Lock table overflow issue

[Former Member]

Hi All,

When we are trying to archive object on production system.Due to this it happens that the lock table contains between 10000 and

12000 lock entries. Many times the system returns a lock table overflow and the process hangs.I see logs in sm21 with

"Lockt able over flow"'internal lock administration error.

Could you please suggest hoe to resolve the issue.I have gone through couple of notes but still i didnt found any solution for it.

Envinorment:

sap netweaver 2004s, BI_CONTENT: 703

oracle:10g

Windows platform.

Thank you in advances

[former_member189546]

Hello,

Please see the following Notes also this type of problem with

possible causes included:

#13907 System error in lock handler, lock table overflow

#79084 Syslog: Error when writing the lock handler file

The maximum size for enque/table_size is 102,400.

regards,

John Feely

[Former Member]

first check lock sm12 than chek check sm21 in error message in showing perameter value so action on....

"Check the value of the parameter enque/table_size via RZ10.

Consider changing it to the max value of 32000 and then restart SAP."

regards

priya

[Former Member]

Dears,

Thank you all for reply,

I have compared the parameters as per Note 950612 and also collected enque stats:

Current values:

Dev

Enque/table size = 4096

abap/shared_objects_size_MB= 20

Qas:

Enque/table size = 4096

abap/shared_objects_size_MB= 20

Prd:

Enque/table size = 8192

abap/shared_objects_size_MB(not set in production system)

======================================

Statistics Value

Enqueue Operations 77867680

rejected 75625922

Error occured 28084

Dequeue Operations 1999489

Error occured 0

Dequeue All Operations 207391

Cleanup Operations 0

Backup Operations 6

Read Operations 4266

Compress Operations 0

Verify Operations 0

Records written 10379

to the backup file 14

Maximum Number of Lock Owners 10365

Maximum Fill level 27

Current Fill Level 0

Maximum Number of Lock Arguments 10365

Maximum Fill level 10364

Current Fill Level 0

Maximum Number of Lock Entries 10365

Maximum Fill level 10364

Current Fill Level 0

Update; Fill Level at Maximum 1

Current Fill Level 0

Time in Lock Table /Seconds 895.479540s

Wait for Lock Table /Seconds 199.534515s

Time in Lock Server /Seconds 0.000000s

Please let me know how to analyze /calculate the lock table size?

Regards,

[Former Member]

"Check the value of the parameter enque/table_size via RZ10.

Consider changing it to the max value of 32000 and then restart SAP."

I too prefer that.

[Former Member]

Hi,

if the expanditure of the lock table until its maximum of 32.000 is still not sufficient - if the overflow still appears - you can simply try to packet your archive objects into multiple smaller pieces and execute them sequential. Therefore you should find out how much archive objects will produce how much lock objects in the lock table.

Hope this helps.

Andreas

[Former Member]

Hi,

Are you following any sap notes or directly increasing lock table size according your enviornment.

Please let me know.I am also facing same issue.

Regards,

Deve

[former_member204746]

Check the value of the parameter enque/table_size via RZ10.

Consider changing it to the max value of 32000 and then restart SAP.