Locking Proble when i run /sapapo/tscube

[Former Member]

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

[digambar_narkhede · Accepted solution]

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

[Former Member · Accepted solution]

Hi Digamber

Thanks for your reply.

We need and our business drives to run /sapapo/tscube in the business hours.How to rectify this issue?

Please give advice abt custom code.

Thanks

Deva

[Former Member · Accepted solution]

Hi All

Intially in the batch jobs we used to get com routine error for that reason we have upgraded our support package.

Now we are facing locking problem while running /sapapo/tscube. Is there any other support package or notes which can be appilied to rectify it?

or Shall we create a program to delete lock entries fro sm12 before loading data to the planning area?

Please advice.

Thanks

Deva

[digambar_narkhede · Accepted solution]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

sanjeev

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

Key Figure lock is not set in the locking logic tab of planning area.

Detailed lock is flagged.

Thanks

[Former Member]

Can you try it with the KF specific lock and see if it makes a difference?