SmartView Unable to Connect to the Provider [ID 1376223.1] Hyperion Financial Management - Version 11.1.2.0.00 and later Information in this document applies to any platform. Symptoms When you attempt to connect to Hyperion Financial Management (HFM) in Smart View, the following error occurs: "Unable to connect to the provider." When you try to browse the hfmofficeprovider virtual directory, the web browser returns the error message: Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. Cause This issue is caused because at some point Oracle Providers for ASP.NET were installed on the HFM Web Server and then uninstalled leaving an orphan entry in the Machine.config file. Solution Open Machine.Config, which is under C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG file in a text editor such as Notepad, and comment out the 'OracleWebEventProvider' section that looks similar to this: Bracket the above section like this: Repeat for all the HFM Web Servers.

SmartView Unable to Connect to the Provider [ID 1376223.1]

Hyperion Financial Management - Version 11.1.2.0.00 and later
Information in this document applies to any platform.
Symptoms

When you attempt to connect to Hyperion Financial Management (HFM) in Smart View, the following error occurs:

"Unable to connect to the provider."

When you try to browse the hfmofficeprovider virtual directory, the web browser returns the error message:

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

Cause

This issue is caused because at some point Oracle Providers for ASP.NET were installed on the HFM Web Server and then uninstalled leaving an orphan entry in the Machine.config file.

Solution

Open Machine.Config, which is under C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG file in a text editor such as Notepad, and comment out the 'OracleWebEventProvider' section that looks similar to this:
<providers>
<add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
</providers>

Bracket the above section like this:

<providers><!--
<add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
-->
</providers>

Repeat for all the HFM Web Servers.