This discussion is archived
9 Replies Latest reply: Nov 22, 2013 4:38 AM by mady RSS

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

GCR Newbie
Currently Being Moderated

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()

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points