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)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

On : 11.1.2.3.000 version, Hyperion Planning

Hyperion Planning unable to refresh Security filter

One of the user left the company and once we refresh the security filter it gives an error



ERROR
-----------------------
Failed to create security filter for user :xyz

com.hyperion.planning.HspRuntimeException: Failed to create Security Filters for the following users: xyz.
at com.hyperion.planning.olap.HspCubeRefreshTask.buildSecurityFilters(HspCubeRefreshTask.java:633)
at com.hyperion.planning.olap.HspCubeRefreshTask.run(HspCubeRefreshTask.java:241)
at java.lang.Thread.run(Thread.java:662)

Tried Planning utilities Provision Users and Update Users  to flush the user with no luck 

--------------------------------------------------------------------------------------------------

D:\Oracle\Middleware\user_projects\epmsystem2\Planning\planning1>ProvisionUsers.cmd /ADMIN:<User> /A:<Application Name>
EPM_ORACLE_INSTANCE (D:\Oracle\Middleware\user_projects\epmsystem2) is set from JVM property[EPM_ORACLE_INSTANCE].
Enter password:
Planning locale: en_US
Thu Jan 08 11:11:56 PST 2015 :: [Thu Jan 08 11:11:56 PST 2015] Starting synchronization.
using java.library.path: D:\Oracle\Middleware\EPMSystem11R1/products/Planning/lib64
EPM_ORACLE_HOME (D:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "EPM_ORACLE_HOME".
using Java property for Hyperion Home D:\Oracle\Middleware\EPMSystem11R1
For non-DP app, Request dimension not needed


Loaded Version of Essbase RTC: 0xb1221
Thu Jan 08 11:12:41 PST 2015 :: [Thu Jan 08 11:12:41 PST 2015] Expense: Synchronizing all users with user provisioning.
Query Failed: SQL_DELETE_USER:[269427]
java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The DELETE statement conflicted with the REFERENCE constraint "FK_HSP_CNI_AUTID".

The conflict occurred in database "Database_Name", table "dbo.HSP_CELL_NOTE_ITEM", column 'AUTHOR_ID'.
       at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
       at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)

Update user failed to update the SID for the specific user xyz as the user is no longer there in the LDAP

Changes

 XYZ was removed from the ldap and de-provisioned from the shared services 

as the user had left the company

And 

Same error if user has Ad Hoc options set up.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.