Lock Table Overflow with workflow

Former Member — Tue, 22 Feb 2011 09:34:01 GMT

Hi,

We have a invoice workflow which was running successful for many months in production.

Suddenly the start event of the custom workflow(SWFDEVENA - disabled in this table) was deactivated by a dump which says

"Lock Table Overflow"

Short text of error message:

Lock table overflow

Long text of error message:

Diagnosis

This table overflowed when trying to enter SAP locks in the lock

table.

System Response

The locks could not be set.

Did anyone face this before. Really couldnt correlate how this table entries changed from X to SPACE(Deactivation) during this dump ?

How can we avoid this from happening again

Thanks and Regards,

Kavitha

Edited by: Kavitha Subash on Feb 22, 2011 10:37 AM

Moderator message: please use more descriptive subject lines for your posts.

Edited by: Thomas Zloch on Feb 22, 2011 1:14 PM

Edited by: Kavitha Subash on Feb 22, 2011 2:45 PM

Re: Lock Table Overflow with workflow

Former Member — Tue, 22 Feb 2011 14:00:45 GMT

Sometimes if there is an exception/ runtime error in the process you'll have the w/f de-activated. The reason is because of the setting in the event linkage SWE2. Here if the "Behavior Upon Error Feedback" is set to "System Defaults" and "Deactivation of Linkage" then for any runtime error/exceptions during workflow the event linkage gets de-activated. If the issue is not persistent activate the workflow event linkage or Change the setting to "Do Not Change Linkage" option, with this option atleast you'll not have your w/f event linkage deactivated. If this is happening consistently then you need to find out the root cause of this exception.

Regards

Ranganath

topic Re: Lock Table Overflow with workflow in Application Development and Automation Discussions

Lock Table Overflow with workflow

Re: Lock Table Overflow with workflow