Knowledgebase: HFM
Error:An unknown error has occurred in the HsxDSSecurity object
Posted by Priya Doyle on 08 November 2010 05:48 PM
Modified 03-NOV-2010

Symptoms

Error: "An unknown error has occurred in the HsxDSSecurity object"

Changes

Security role changes made to the SQL Login account used by Hyperion Financial Management

Cause

Security role changes made to the SQL Login account used by Hyperion Financial Management

Solution


To verify the issue, use SQL Enterprise manager



  • Locate the database and expand to see Tables

  • Review the Owner and Type columns

  • All User Type objects must be owned by the same user

  • System Type object must be Owned by �dbo�

  • If User Type objects are also owned by �dbo� then the HFM SQL login account must be a member of the System Administrator role

 


The above error will result when User Type objects are owned by �dbo� as well as a SQL Login User account and can be specific to some applications depending on when the login role changes were made.


 


To resolve this error, MS SQL DBA must manually change ownership of all User Type objects to either �dbo� or to the proper MS SQL Login account.  Please consult MS SQL Books on line for further information.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: