Hi All,
Here when i try to start EPMA Service i am unable to start and throws an error : hyperion epma server service on local computer started and then stopped. When i check with EventViewer, i have seen this error
ERROR1:
[EPMA Server Startup] ERROR SVR_ERR_PROCESSMGR_CANT_INIT_SESSIONMGR:Cannot initialize the Session Manager.Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Hyperion.CommonServices.Exceptions.DataAccessLayerException: To run the Dimension Server, both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settings must be set to 'ON'. Their values are currently 'OFF' and 'OFF' respectively. Please consult the product documentation for details.
at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion, Boolean onlyLoadKnownTables)
at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion)
at Hyperion.SessionManager.DAO.SessionManagerDataAccessLayer..ctor(NameValueCollection settings)
at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.Initialize(String rdbmsVendor, String rdbmsConnParams, Int32 rdbmsCommandTimeout, Boolean logAllSQL)
at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)
--- End of inner exception stack trace ---
at Hyperion.DimensionServer.Service.Main.InitializeSessionManager()
at Hyperion.DimensionServer.Service.Main.Start()
ERROR2:
Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Hyperion.CommonServices.Exceptions.DataAccessLayerException: To run the Dimension Server, both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settings must be set to 'ON'. Their values are currently 'OFF' and 'OFF' respectively. Please consult the product documentation for details.
at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion, Boolean onlyLoadKnownTables)
at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion)
at Hyperion.SessionManager.DAO.SessionManagerDataAccessLayer..ctor(NameValueCollection settings)
at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.Initialize(String rdbmsVendor, String rdbmsConnParams, Int32 rdbmsCommandTimeout, Boolean logAllSQL)
at Hy...
But i have set both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settings ON
This is the query which i have used
ALTER DATABASE epmdb SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE epmdb SET ALLOW_SNAPSHOT_ISOLATION ON;
Even though i am unable to start, same error was reflecting.
Can any one suggest me what can i do to resolve this.
Thanks in Advance.