My Oracle Support Banner

EPMA Dimension Server Fails to Start with an Error" [EPMA DimensionServer Startup] FATAL Unable To Find The Requested .Net Framework Data Provider" (Doc ID 2479348.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

Hyperion Planning - Version 11.1.2.0.00 and later
Information in this document applies to any platform.

Symptoms

EPMA Dimension server fails to start with an error [EPMA DimensionServer Startup] FATAL Unable To Find The Requested .Net Framework Data Provider

The full error in the EPMA \Oracle\Middleware\user_projects\<instancename>\diagnostics\logs\epma\DimensionServerStartup.log is 

[2018-11-20T10:02:40.622-06:00] [Debug] Starting up Remoting using port 5255
[2018-11-20T10:02:40.996-06:00] [Error] System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
  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)
[2018-11-20T10:02:41.173-06:00] [Debug] Shutting down all Dimension

The above entries show that the connection failed to the relational Oracle or SQL database. A succesful connection to the database which shows the connection after "Starting up Remoting using port 5255" entry is as follows. In this instance to the EPMA Oracle schema 

[2018-10-26T12:53:02.382-04:00] [Debug] Starting up Remoting using port 5255
[2018-10-26T12:53:04.286-04:00] [Info] SQL Connect String:  User Id=HYPEPMA;Password=********;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-UZQD31WWYSZ)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));;Pooling=True;Min Pool Size=1;Max Pool Size=100;Connection Lifetime=0;Enlist=true;Validate Connection=False;Load Balancing=False;HA Events=False;Incr Pool Size=1;Decr Pool Size=5;Connection Timeout=15
[2018-10-26T12:53:06.116-04:00] [Info] Binding to port: 5251

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.