topic Insert record in Application Development and Automation Discussions

Insert record

Former Member — Mon, 24 Dec 2007 07:27:54 GMT

Hi,

Im using LSMW to upload data into custom table.

The file to upload contains 20,000 records.

While upploading after 4000 records i got an error message

' Lock Table Overflow '

Can any one suggest me how to do this.

Regards,

Vimal

Re: Insert record

Former Member — Mon, 24 Dec 2007 07:32:41 GMT

Hi Vimal

This seems to be a problem coz there might not be a dequeue happening for each record being posted. This is casuing the lock table overflow. Please check whether you can dequeue the lock object after each iteration.

~ Ranganath

Re: Insert record

Former Member — Mon, 24 Dec 2007 07:42:27 GMT

Thanks for ur ans.

Can you tell me how to do this dequeue.

I think you can solve this.

Regards,

Vimal

Re: Insert record

Former Member — Mon, 24 Dec 2007 07:46:17 GMT

I hope your basis people might set the limit for the table with 400 records by assigning the memory. So probably what you can do is, before updating to the database. Check the condition like number of records in the table. First move the first 4000 records to new table and append to DB table, now delete the 4000 entries In old table and new table. Now move other 400 records.. mean while you need to lock and unlock the table while ur doing DB operations.

I hope this will help you.

reagrds

raghu

Re: Insert record

Former Member — Mon, 24 Dec 2007 08:02:53 GMT

Hi Vimal

Hope i can do that ! ...

what you have to do foR this is, first get the lock object name. you can get this by going sm12 when running you program parallely in debugging mode. once you have the lock object< use the fm dequeue_<lock_obect> to remove the entry from the lock table, this dequeue fm should be place before a end of first iteration.

~ Ranganath