Calculated Data Lock cannot be opened

Products

• CA Business Service Insight

Issue/Introduction

The Calculated Data Lock window cannot be opened by one BSI user. All other BSI users are able to open the Calculated Data Lock window.

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

Since the issue is occurring for just a single user, indicates that there is a problem with the control layout saved for the user.

To resolve this, will need to find the user_id according to the user_name and then proceed to delete the calculated_data_lock layout for that user_id fromr the BSI database directly.

As always, ensure that you have a valid backup of the BSI database and take extreme caution when manipulating any data directly

1.  To select the user ID, run the following query

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

Replace user_name with the user that is having the issue

2.  To delete the layout entry, run the following query

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

Replace [user_id] with the user ID from step #1 above

If the issue still persists, please contact Broadcom Support for further assistance.