Lock table overflow in SAP

[chandrasekhar_pandiri]

We are tyring to execute a transaction and it is giving the error Lock table overflow, Though the enque/table_size parameter is set to 96,000 KB which i guess good enough.

Can you please suggest.

Thanks,

Chandu

[mercedes_fernandez · Accepted solution]

Hello Chandu,

how many records this transaction is locking?

SAP Note 746138: Analyzing lock table overflows, describes how to analyze this issue.

Are you using Standalone enqueue? If that's the case check that the enqueue table size is defined in the ASCS instance.

kind regards,

Mercedes

[chandrasekhar_pandiri · Accepted solution]

I am not sure how many records it is going to lock, as it depends on funcitonal team selection criteria and even facing the issue for a single day selection also.

And i go through the note already but did not find any thing related to this.

Thanks,

Chandu

[mercedes_fernandez · Accepted solution]

Hello Chandu,

in the file ENQHISOVR (as described in the note) you could see how many records the transaction locks.

Are you using Standalone enqueue?

kind regards,

Mercedes

[chandrasekhar_pandiri · Accepted solution]

Yep, we are using stand alone one.

[mercedes_fernandez · Accepted solution]

Hello Chandu,

which value does it have parameter enque/table_size in the ASCS profile?

did you look into file ENQHISOVR?

kind regards,

Mercedes