07-22-2009 5:25 AM
Hi All,
I have a code that updates condition records in MEK1 from an excel sheet. The no of records in an excel sheet can go up to 60 k records. If i try to upload 5000 records, the coditions records are saved successfully. But then, if I try to upload 10000 records i get a error saying " Condition blocked by user " . On debugging I found out that the user id is mine. That is, same id as the person who is trying to upload records. The transaction is not open in any window as well.
My question is, why do we encounter this error and is there any limit to number of records that can be uploaded at a time in MEK1?
Thanks in advance,
Sapna
07-22-2009 5:34 AM
Hi Sapna,
I am sure about any limit for uploading condition record. But as per your message, if you able to save 5000 records successfully, then use "COMMIT" after 5000 records and upload records in intervals of 5000 reocrds.
Thanks & Regards,
Anil Salekar
07-22-2009 5:41 AM
Hi,
Check duplicates records in your file itself.
It might be giviing error d\Due to duplicates record.
Thanks,
Balu
07-22-2009 5:52 AM
Hi Anil,
I am using BDC to update records in MEK1. There are unique 10k records in the excel file. No duplicates. And only 1198 records are getting saved. (Sorry for saying 5k, It was a mistake in my previous post.
07-22-2009 6:04 AM
Hello,
You should issue a synchronous commit (COMMIT WORK AND WAIT) for every 1000 records. Then you should not have any locking and saving issues.
Thanks,
Venu
07-22-2009 6:02 AM
Hi Rao,
For blocking you can commit in intevals or you can use wait command but it will take extra time but your records will update in one go,when a condition record is created,then after you try to update for same material or plant thats the reason its blocking,you can either use wait or adjust your excel files and avoid duplication of materials or whatever you are using in sequential manner.