1 Reply Latest reply: Dec 10, 2012 2:12 AM by hyperionEPM RSS

    EPMA startup error

    beyourbest
      Fresh install on a supported version of Windows server...I get this error,

      The Hyperion EPMA server service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

      I see this in the Windows event log,

      [EPMA Server Startup] ERROR Exception occurred in the DAL. Error Message: 'Invalid object name 'sys.databases'.'. SQL command or stored proc: SELECT snapshot_isolation_state, is_read_committed_snapshot_on
      FROM sys.databases
      WHERE name = @p_dbName
      Params:
      p_dbName = HYPSS
      System.Data.SqlClient.SqlException: Invalid object name 'sys.databases'.
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
      at System.Data.SqlClient.SqlDataReader.get_MetaData()
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
      at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
      at System.Data.Common.DbCommand.ExecuteReader()
      at Hyperion.DataAccessLayerCore.DALDatasetCommand.get_Reader()


      Any suggestions?

      Thanks,
      Jz
        • 1. Re: EPMA startup error
          hyperionEPM
          Hello,

          Are you using SQL as a database ?

          If so, did you run the following queries on the database that you are using for EPMA -

          ALTER DATABASE EPMA SET READ_COMMITTED_SNAPSHOT ON;
          ALTER DATABASE EPMA SET ALLOW_SNAPSHOT_ISOLATION ON;

          Regards,
          HyperionEPM