topic Re: call transaction system lock error in Application Development and Automation Discussions

call transaction system lock error

Former Member — Fri, 12 Jan 2007 10:39:36 GMT

Hi friends,

i am uploading data to some transaction using call transaction method with synchronus update.

when i schedule the same program as 2 jobs in the back ground (splitting the file in to 2) most of the records are failed with the error 'SYSTEM_LOCK'.....

any suggession on this? thanks

Re: call transaction system lock error

Former Member — Fri, 12 Jan 2007 10:44:15 GMT

After the first job finishes , then only schedule the 2nd job and checkout if it works

Re: call transaction system lock error

Former Member — Fri, 12 Jan 2007 11:25:48 GMT

if it is one after the other then works very much fine.

here our idea is to reduce the upload time, so we want to run 2 jobs simultaniously.

Re: call transaction system lock error

Former Member — Fri, 12 Jan 2007 11:53:28 GMT

Hi kiran,

You can do the coding like, after executing the First File then only start the Second file,

Normally this won;t happen, i mean the error only comes when you are using the same values in the same time, so may be your filwe is contains the same, so it is better run the first file, after completing the first one then only start the processing the second file

Regards

Sudheer

Re: call transaction system lock error

Former Member — Fri, 12 Jan 2007 15:48:16 GMT

my program is taking 8 hours to upload 100,000 records, so my idea to break that into 2 jobs so that we will reduce the time.

any ideas

Re: call transaction system lock error

Former Member — Fri, 12 Jan 2007 15:52:11 GMT

Instead of call transaction, use the session method. Run as many sessions simultaneously as you want. You will still get lock errors, but you will be able to resolve them by re-submitting the error sessions. Some may have to be submitted more than once.

Rob

Re: call transaction system lock error

Former Member — Mon, 15 Jan 2007 13:52:31 GMT

thank you very much, could you tell me normally how much time will take to upload 100 000 records using LSMW?? the transaction has 12 screens to process.

thanks Rob

Re: call transaction system lock error

Former Member — Mon, 15 Jan 2007 14:40:23 GMT

That would depend on a number of factors - the transaction you are using, your hardware platform and other system activity while the load is going on. So no, I can't tell you how long this will take.

But if you load say 1,000 records into your QA system (and multiply by 100), this should give you a rough idea of how long. The Production load will take more or less time depending on hardware and system usage.

Rob

Re: call transaction system lock error

Former Member — Mon, 15 Jan 2007 15:09:31 GMT

normally when call transaction is used it locks the transaction and starts posting the data so that duplicates doesnot occur. What u can do is first run the first file and after it gets finished run the second file. This way it won't give any errors and also almost all records will be posted to SAP.

Re: call transaction system lock error

Former Member — Mon, 15 Jan 2007 20:26:07 GMT

thank you for the information Rob and ramesh.

Re: call transaction system lock error

Former Member — Mon, 15 Jan 2007 20:31:27 GMT

You're welcome Kiran. If your question is answered, please close the thread.

Rob

Re: call transaction system lock error

Former Member — Tue, 16 Jan 2007 13:39:07 GMT

thanks to everyone,