My Oracle Support Banner

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:

Hyperion Planning - Version and later
Information in this document applies to any platform.


On : 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

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(



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


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

as the user had left the company




Same error if user has Ad Hoc options set up.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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