Calculation Manager Error "Could not connect to Dimension Server" (Doc ID 1563466.1)

Last updated on MAY 06, 2016

Applies to:

Hyperion Planning - Version 11.1.2.1.600 and later
Information in this document applies to any platform.
May 2016

Symptoms

When attempting to open the Calculation Manager and accessing a business rule, the following error occurs.

Could not connect to Dimension Server.
Please make sure that the required services are started.
http://ddr-hypessbnp.ensco.ws:19000/HyperionPlanning/servlet/HspAppManagerServlet:
Connection refused: connect.

In the Windows Event Viewer, the following error message is recorded:

Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot Initialize the Session Manager.--->Hyperion.CommonServices.Exceptions.DataAccessLayerException: To Run Dimension Server, both Allow_Snapshot_Isolation and Read_Committed_Snapshot database settings must be set to 'ON'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms