Calculated Data Lock cannot be opened

Document ID : KB000092835
Last Modified Date : 24/04/2018
Show Technical Document Details
Issue:
The Calculated Data Lock window cannot be opened but only for 1 user. All other users are able to open the Calculated Data Lock window.
Resolution:
 
That this is only failing for one user shows it's a problem with the control layout saved for the user. To solve this, we'll need to find the user_id according to the user_name, then Delete the calculated_data_lock layout for that user_id.

1--select the user id

select user_id from t_users
where user_name = '[user_name]'

2--delete the layout entry from t_control_layout

delete from t_control_layout
where user_id= [user_id]
and
page_id='Oblicore.Web.Admin.EngineManagement.CalculatedDataLock.CalculatedDataLockList'

This should then clean it up and allow the user to access the page again.