Hyperion Planning: Failed to create security filters for the following Users: xxxxxx

We have faced one issue with one of our customer. Issue is Client side Administrator removed MSAD user which has access Hyperion Planning application. But after deleting that user, Planning Security filters give below error.

When refreshing, this issue we are facing. W

Solution:

We have verified HSP tables for this user like hsp_object, hsp_mru_members, hsp_user_prefs, hsp_pm_out_of_office, hsp_users, hsp_adhoc_opts etc. We may have references in other tables also. But in our case we didn't find any.


Delete from hsp_mru_members where object_id = '123456'
Delete from hsp_user_prefs where object_id = '123456'
Delete from hsp_pm_out_of_office where object_id = '123456'
Delete from hsp_users where object_id = '123456'
Delete from hsp_object where object_name='abdcef'
Delete from hsp_adhoc_opts where object_id = '123456'

Once done, check out you are refresh or not from Planning application.

Note: while deleting entries from these tables, take backup of schema and also check out any primary key, secondary key references are there.

Reference:

Hyperion Planning Unable To Refresh Security Filter Failing on one Specific LDAP User Error:"Failed to create security filter for user " (Doc ID 1961167.1)

Thanks,

Mady