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 JUNE 01, 2017

Applies to:

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

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:admin /A:FinPlan
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 "Hyp_ExpPrd", 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms