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:
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
GKontos
Comments