Skip to Content
avatar image
Former Member

Locking Proble when i run /sapapo/tscube

Hi All

we have upgraded supprt package to SAPKY50017 from SAPKY50013.

Since then when we load data from the Infocube to the Planning Area we are getting error in log stating selection is locked by the User.

Prior to support package implementation there was no error with user lock, even in the business hours when we run /sapapo/tscube we never use to get this locking error.

Please see the following error:

Selection accesses data that is currently locked; user

Message no. /SAPAPO/MA034

Diagnosis

The selection accesses data which is currently locked.

All entries will be reversed.

As a result they appear in the display mode.

Select the function 'lock entries' to see the current locked selections.

Select the function 'new selection' to plan for another selection.

Please help.

Thanks

Deva

Edited by: vdeva79 on Jun 23, 2010 11:46 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 23, 2010 at 10:39 AM

    Hi Deva,

    Please refer SAP Note 1385695 & 1388262 that says earlier there was no locking logic implemented and that may lead to various COM errors from LiveCache.And hence it seems that they have corrected this in SCM 5.0 SP : SAPKY50017

    and hence you are getting this error.

    hope this answers your query...but to solve your problem you may need to contact SAP or write some custom code to achieve the same.

    Regards,

    Digambar

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Deva ,

      Sorry..I don't have the exact custom code ready for this but you can get it done with some ABAP.

      Please refer to SAP notes mentioned in my earlier post and try to tweak on the correction(locking) delivered in those with the help of ABAPer .

      Subsequently I would suggest to consult SAP through OSS if this is not easy going and there are other unknown consequences...

      Also please refer Note 1388262 - Collective note in order to avoid unexpected locking issues

      Regards,

      Digambar

      Edited by: Digambar Narkhede on Jun 24, 2010 5:06 AM

  • avatar image
    Former Member
    Jun 30, 2010 at 09:11 AM

    Hi,

    This error message has been setup to notify incase of any locks existing in the system. We should at no cost override this lock setting.

    Hence the strongest suggestion is not to delete locks from SM12 on a adhoc basis without checking what could be the trouble, also that is not the correct approach to the problem.

    I understand your business requirement is to load data during business hours. But I am sure no business would agree to terminate the user sessions who are currently carrying out some data changes.

    We also have requirements to carry out such data loads during business hours. We have educated our users to stay away from the system while the load is scheduled and have setup messages using System Messages and a ABAP program to use function module th_popup to send out warning messages that load is about to begin.

    Hope this helps.

    Thanks

    Mani Suresh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2010 at 02:51 PM

    Do you have Key Figure specific lock set on your planning area?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2011 at 11:45 AM

    I faced this issue during RLGCOPY. I found that also background jobs working on infocube data (like CVCs) can also block transaction. I scheduled it in sunday morning and after few days I reached realignment.

    Add comment
    10|10000 characters needed characters exceeded