Knowledgebase:
EPMA Server Service not Running
Posted by Ben Collins, Last modified by Ben Collins on 16 April 2013 02:40 PM

Symptoms

Unable to start the EPMA Server Service.  The below error is reported in the Event Viewer for EPMA Dimension Server/ EPMA Server:

Hyperion.CommonServices.Exceptions.DataAccessLayerException: To run the Dimension Server, both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settting must be set to 'ON'. Their values are currently 'OFF' and 'OFF' respectively. Please consult the product documentation for details.

Cause

Prerequisite when using MSSQL Server with Hyperion 11.1.2.x was not done. 

Solution

Per the "Oracle® Enterprise Performance Management System Installation Start Here Guide", when creating a Microsoft SQL Server database for use as a repository, ensure that you set these options:

  • Set READ_COMMITTED_SNAPSHOT = ON
  • Set ALLOW_SNAPSHOT_ISOLATION = ON
  • Select the SQL Server and Windows authentication option when you set the security properties for the database.
  • All products support Latin Collation for the SQL Server database. Create a database that is case insensitive and use this statement: SQL_Latin1_General_CP1_CI_AS.

1.  Login to MSSQL Server Management.
2.  Connect to the EPMA Database.
3.  Run the below SQL Statements:

    ALTER DATABASE <DatabaseName>
    SET READ_COMMITTED_SNAPSHOT ON
    GO
    ALTER DATABASE <DatabaseName>
    SET ALLOW_SNAPSHOT_ISOLATION ON
    GO

4. Start the EPMA Server service.

Note: The setting can be located within the following path: <DatabaseName> - Views - System Views - sys.databases

It is worth while to check before AND after the fix has been run

 

Oracle Doc ID: 1501814.1

(0 vote(s))
Helpful
Not helpful

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