MARC archiving

[Former Member]

Dear Experts,

     I have a requirement to archive Article-site combination data from MARC table. In order to archive MARC data, we need to discontinue the articles from specified site first and then archive. I am using "WRF_DIS_SEL" Tcode for discontinuation. The problem is when i have selected "Offline checks" option in that Tcode, some locks were applied on some tables when the articles were being checked. Can anyone tell me what happens when articles are being checked? Which objects will the locks be applied on and will it affect any Transaction?

Thanks in advance.

Regards,

Shanthi

[Former Member]

If you look in sm12 while you are running these checks you will see a list of all objects that you currently have locked.

Any transaction that tries to edit a locked object will be affected in that if anyone tries to use these transaction to edit a locked object they will an error.

[Former Member]

Hi Jarnie,

   Thank you for your quick response. Yes i have checked in SM12. Many objects were locked and they were displayed in SM12 when i ran discontinuation process.

   But my requirement is such that there are many articles to be discontinued for a single store. I have to give multiple articles as input for discontinuation. So the locks will be applied on multiple tables therefore standard transactions will be affected. What is the solution for this?

[FredericGirod]

Do it the night when everybody sleep

regards

Fred

[Former Member]

  okay Fred. Please let me know if there is any other way like removing locking system or some thing else. Thank you

[Former Member]

Most locks are at the item level of the table rather than locking a whole table. So for example with articles only those articles that are being discontinued should get locked which might not be such a problem.

If I were you I'd run this process in a test environment and check for each type of lock in you see in sm12 whether it is locking the entire table or just the items being processed. After this analysis if I still thought this process could cause problem I'd schedule a maintenance window to do this mass discontinuation.

Points are appreciated if you find an answer useful.

[Former Member]

I have checked even that Jarnie. When i gave huge data as input for discontinuation, the lock table was filled up and i got "Lock table over flow" error. Thus i could not edit anything.

    When i gave less input and when the lock table was not filled up, though i didn't get "lock table over flow" error, i was unable to edit other items also though they were not given as input for discontinuation. Means the entire table was getting locked instead of item level. So i was getting error message like so and so item is locked when i tried to edit any other item in the locked table.

[FredericGirod]

It's a very bad idea

Don't forget you try to archive master data, it's not a very common task. SAP must ensure you don't create inconsistencies data. So, play with SM12, but don't forget SAP will not help you when problem arrives ..

Good luck

Fred

[Former Member]

Schedule an outage to do this

[Former Member]

Thank you all.

Regards,

Shanthi Priya

[eduardo_hinojosa]

Hi

Please, see note 127011 - Perform. of article reorg., discontin. of article

I hope this helps you

Regards

Eduardo

[Former Member]

Hi Eduardo,

     Thanks for the info. I have tried unchecking all those options and running discontinuation process but there was no difference in the performance. Our server is busy 24/7. So i can't schedule the discontinuation process. There are around 5 lakh articles in the all the closed stores. I'll try to discontinue 1000 articles at a time but they are getting locked up. What is the solution for this.

Regards,

Shanthi Priya

[Former Member]

Can anyone tell me how the locking mechanism works in this scenario? Sometime in SM12 TCode, i see shared locks some times Exclusive locks. Sometimes i'm able to edit the table values even when it is an exclusive lock some times unable to edit even when it is a shared lock.

Regards,

Shanthi Priya