2 Replies Latest reply on May 25, 2012 6:46 PM by beyerch2

    FDM login Error

    Sabbu
      Hi,

      While trying to login to one of our FDM applications we are getting the below error.


      Error: An error occurred logging on to the system.
      Detail: Invalid object name 'tSecUser'.
      Line=select AppSecLevel from tSecUser where UPPER(UserID) = 'HYP_ADMIN'


      Can someone please tell what is the issue and how it can be resolved.

      Thanks in advance.

      Edited by: Neha C on May 25, 2012 7:48 AM
        • 1. Re: FDM login Error
          SH_INT
          Is this error occurring from the standard FDM web login page?
          • 2. Re: FDM login Error
            beyerch2
            tSecUser is a table in FDM that stored user information.

            The error appears to indicate that the table is missing -OR- the account you are using to access the database does not have permission to see that table.

            Connect to the SQL Server, open the database in question (with the database owner account), and confirm if the table exists.

            If the table exists, assign permissions to the user that FDM is using to connect to the database.

            If you do not know what database user has been assigned, locate the file : HyperionFDMApplications.xml which should be stored on the FDM server. You will find the database user defined inside of this file.

            If the table is missing, better check with your IT guys to see if there is a database to restore from, etc.