topic Re: Error while lock object creation in Application Development and Automation Discussions

Error while lock object creation

Former Member — Tue, 26 Jun 2007 07:23:20 GMT

When I tried to create a lock object, I get the following error.

Error: "Total length of lock argument for table XXXXXXXXX longer than 150"

I have 3 tables in which Table1 is the check table for the value tables (Table2 & Table3). During the process of deletion of a record from Table1 (CT) I need the lock tobe established on value tables and then I delete all the corresponding entries in value tables are also deleted.

Would like to know If there is any other std ways of doing this ? and

Solution to overcome the error.

Regards

Karthick

Re: Error while lock object creation

seshatalpasai_madala — Tue, 26 Jun 2007 07:36:13 GMT

Hi,

I think the error is becoz you have given too many LOCK parameters in the lock object. the total length of the PARAMTERS of lock object should not exceed 150.

By default all the KEY fields will be taken as Lock paramters, so your table key's length is more than 150.

Also why dont you create 3 lock objects for each table and then use only KEY's of each table as LOCK PARAMETERS.

Then Lock T1 record first then lock T2 and T3 records, then delete records from T2 and T3.

Then you delete T1 record.

The execute DEQUEUE_ALL.

Regards,

Sesh