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

Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:24:43 GMT

Hi Experts,

We are facing an issue in our production. Something is causing table(VBAP)s to get locked up in the production.

The last chnage we have moved into the sytem is some change which issues large fetches from VBAP table. there was a bug in the code which didnot check for the internal table being initial before using it in the select query with for all entries.

Please let me know if this bug would cause table lock?

As far as i understand this should only give time out error.

Awaiting your replies.

Thanks and Regards,

Anjali

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:31:07 GMT

You are correct. This bug wont cause table lock( I have never seen table select causing lock ).

But say if you have create a table lock manually through program and then in next step you are doing this select then this lock will be there till your progran reach the step where you have unlocked the table.

Have you checked SM12 who is locking the table. there you can get more details.

Edited by: Anurag_n on Mar 29, 2010 4:31 PM

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:37:45 GMT

Hi Anurag,

The main thing we are not updating any table in that program neither are we modifying anything in VBAP. We are only fetching it and putting it on an invoice. this is basically a print program. Would this be any basis issue..?

Regards,

Anjali

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:41:38 GMT

HI Anjali,

Check SM12 t code is the only thing I can suggest right now. There you can get who is causing the locl and also lock argument. Then you can investigate more

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:42:44 GMT

Well, is the program doing any locks anyway?

Rob

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:53:17 GMT

Hi Rob,

No, this particular program is not locking the table at any point. Also, this is our requirement:

We have a contract , if it is active in status then we need to print certain details on an invoice. This error is happens at the point when u save the changes made to issue output screen. once it saves, it goes on in an infinite loop and locks the table. this issue is reported only in one contract, the rest of them works fine.

Regards,

Anjali

Re: Problem with Table Lock

Former Member — Mon, 29 Mar 2010 14:56:49 GMT


> No, this particular program is not locking the table at any point. 
> This error is happens at the point when u save the changes made to issue output screen. once it saves, it goes on in an infinite loop and locks the table.

This seems like a contradictory statement.

Rob