Solution for EPMA Server Service startup issue in EPM 11.1.2.4.0

安装了EPM System 11.1.2.4.0 Foundation, EPMA, OHS, RA, CM.

When I try to start the EPM by EPM_INSTANCE\bin\start.bat, I found the 'Oracle Hyperion EPMA Server' service 没起来, 一怒之下, 我track epma server log(location: EPM_INSTANCE\diagnostics\logs\epma\DimensionServer.log), error如下:

[EPMADIM] [ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.CommonServices.Exceptions.BaseException] [tid: EPMA DimensionServer Startup] [ecid: disabled,0] Unable to find the requested .Net Framework Data Provider. It may not be installed.
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)

After google, the below link helps:

https://community.oracle.com/message/13001762#13001762

EPMA Process Manager Fails To Start with Error: "Unable to find the requested.Net Framework Data Provider" (文档 ID 1305023.1)

SOLUTION

Download ODAC121024Xcopy_x64.zip from following website:  http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

1. Download the ODAC (xcopy version) zip file to a directory for staging ODAC products.

2. Unzip ODAC (xcopy version) zip file to expand the contents.

3.  The following directories will be created:

	64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
	64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
	64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
	64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
	64-bit Oracle Provider for OLE DB 12.1.0.2.0
	64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
	64-bit Oracle Instant Client 12.1.0.2.0

The install.bat will also be extracted to the same location as the ODAC zip file, which is used to install and configure a specific product.

4. Execute install.bat to install and configure ODAC products.  To install all ODAC products, execute the following: 

install.bat all c:\oracle odac

Each product can be also be installed and configured individually.  As an example, executing the following will install only ODP.NET 2:

install.bat odp.net20 c:\oracle odac

EPMA Server Service Does Not Start - Failed to find or load the registered .Net Framework Data Provider (文档 ID 1567895.1)

SOLUTION

After executing the below commands, the error should disappear and the EPMA Server service should start successfully:

Note: The below commands are generic sample commands as paths in customers' environments can differ.

cd C:\Oracle\app\product\11.2.0\client_1\ODP.NET\bin\4\
OraProvCfg.exe /action:gac /providerpath:C:\Oracle\app\product\11.2.0\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll

cd C:\Oracle\app\product\11.2.0\client_1\ASP.NET\bin\4\
OraProvCfg.exe /action:gac /providerpath:C:\Oracle\app\product\11.2.0\client_1\ASP.NET\bin\4\Oracle.Web.dll

 

for MS SQL Server: 

you need to make sure that the EPMA-database is configured as:
ALTER DATABASE databaseX1
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE databaseX1
SET READ_COMMITTED_SNAPSHOT ON