0 Replies Latest reply: Apr 10, 2012 9:05 AM by User722567-Oracle RSS

    EPMA Dimension server won't start using SSL enabled Database

    User722567-Oracle
      Has anyone had any luck configuring EPMA 11.1.2.2 or 11.1.2.1 EPMA Dimension server with a JDBC SSL connection? I am using the following url to configure my SSL-enabled database:

      jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=slc00qox)(PORT=1529))(CONNECT_DATA=(SERVICE_NAME=slc00qox.us.oracle.com)))
      and the Dimension server won't start. Other Foundation, Essbase and Reporting repository connections work with same URL. Getting an error in Event Log:

      Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Hyperion.CommonServices.Exceptions.SessionManagerException: Session Manager could not start because database connectivity could not be established. ---> Oracle.DataAccess.Client.OracleException ORA-12537: TNS:connection closed at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
      --- End of inner exception stack trace ---
      at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
      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()
      at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

      AND

      [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.SessionManagerException: Session Manager could not start because database connectivity could not be established. ---> Oracle.DataAccess.Client.OracleException ORA-12537: TNS:connection closed at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
      --- End of inner exception stack trace ---
      at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
      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()