9 Replies Latest reply: Nov 22, 2013 6:38 AM by Madhu.M RSS

    EPMA Service Fails to Start > Connection String? Database Type '' no supported

    GCR

      Windows logs says EMPA Dimension Server fails to start with SVR_ERR_CONFIG_UNSUPPORTED_DB_PROVIDER: Database Type '' is not supported.

       

      I've reconfigured EPMA and even re-installed EPMA.  Where do i find the SQL Connection string used by the GetSqlConnectionString() method?  Seems odd that the database type is empty??  Ideas?

       

      From the diagnostics/logs/epma/DimensionServer.txt

      -------------------------------------------------

       

         at Hyperion.DimensionServer.Service.Main.Start()[2013-09-03T13:17:02.099-07:00] [EPMADIM] [NOTIFICATION:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Utility.ChannelUtility] [tid: EPMA Server Startup] [ecid: disabled,0] Listening using IPv4[2013-09-03T13:17:05.094-07:00] [EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: EPMA DimensionServer Startup] [ecid: disabled,0] SVR_ERR_CONFIG_UNSUPPORTED_DB_PROVIDER:Database Type '' is not supported.    at Hyperion.DimensionServer.Configuration.Configuration.GetSqlConnectionString(String sqlVendor, String sqlDatabasePort, String sqlDatabaseName, String sqlServerName, String sqlLogon, String sqlPassword, String jdbcUrl, Boolean useSIDForOracle)

         at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()

         at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(Boolean restorePastInstanceSessions, Boolean enableCaching)[2013-09-03T13:17:05.125-07:00] [EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: EPMA DimensionServer Startup] [ecid: disabled,0] SVR_ERR_CONFIG_UNSUPPORTED_DB_PROVIDER:Database Type '' is not supported.    at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(Boolean restorePastInstanceSessions, Boolean enableCaching)

         at Hyperion.DimensionServer.Process.Program.InitializeSessionManager()

         at Hyperion.DimensionServer.Process.Program.StartDimensionServer()

         at Hyperion.DimensionServer.Process.Program.Main(String[] args)[2013-09-03T13:17:05.297-07:00] [EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: EPMA Server Startup] [ecid: disabled,0] SVR_ERR_PROCESS_DID_NOT_START:Process 'D:\oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin\EPMA_ServerEngine.exe' could not be started.    at Hyperion.DimensionServer.Service.Main.StartProcess(String applicationName, String arguments, String startupEventName, String terminateEventName, String logFileName, Int32 timeout, ProcessInfo& pi)

         at Hyperion.DimensionServer.Service.Main.StartServerEngineProcess(UInt16 serverPort, UInt16 netJniPort)

         at Hyperion.DimensionServer.Service.Main.Start()[2013-09-03T13:17:05.297-07:00] [EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.DimensionServer.Service.Main] [tid: EPMA Server Startup] [ecid: disabled,0] Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Process 'D:\oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin\EPMA_ServerEngine.exe' could not be started.

         at Hyperion.DimensionServer.Service.Main.StartProcess(String applicationName, String arguments, String startupEventName, String terminateEventName, String logFileName, Int32 timeout, ProcessInfo& pi)

         at Hyperion.DimensionServer.Service.Main.StartServerEngineProcess(UInt16 serverPort, UInt16 netJniPort)

         at Hyperion.DimensionServer.Service.Main.Start()