Error:An unknown error has occurred in the HsxDSSecurity object

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<o:p />

• 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

<o:p> 

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.<o:p />

<o:p> 

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.