Data Locked

[Former Member]

Hi All,

When i am trying to send data through input schudule , it gives a message data is locked.Is there any method to remove the data locking from the production environment without deleting transactional data.

[i045436]

The data remain into lck tables when a submission has not properly finished.

[sorin_radulescu]

It is important to know the version of SAP BPC.

Data locked message is coming

1. The submission status is approved or submitted and you have to change the submission status to be able to unlock before to send data.

2. SG - send governor process fail and you have some records into Lck"Nameofyourapplication" from database "Yourappset".

In this case you have to stop the input data into that application for all the users for few minutes and to delete the records from Lck"naeofyourapplication". After that you will be able to send data for that combination where you were receiving Data Lock error message.

The SAP BPC version is important because the tables Lck...can have another name function by version of SAP BPC.

Regards

Sorin Radulescu

[Former Member]

I've run across this error before as well. I'm not sure why, but every once in a great while I get this error especially on new installations. Not sure if this is the case or not. Anyway, I can only speak to BPC 5.1. So if you have this issue in 5.1, and you are unable to edit work status, then you can log into SQL Server Management Studio - Database Engine, then find the dbo.lck"appname" table and delete the lock records for the time periods you want to unlock. You may have to run a full optimization after that, but I don't recall off hand.

Edited by: Michael Hutchins on Mar 11, 2009 4:45 PM