I have migrated HFM App from DEV to UAT and after that smart-view throwing error:
Opening Excel sheet ---> Smartview tab--> Shared connection--> Provided URL--->When selected 'HFM' in dropdown--> Throwing Error
Error: unable to connect to provider
Version: 11.1.2.2
Excel Version: 2010
Note: SmartView is working good for Essbase, Reports & Planning
In DEV smartview is working for all components
Oracle provided solution: Kb 1376223.1
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
Oracle Providers for ASP.NET were installed on the HFM Web Server and then uninstalled leaving an orphan entry in the Machine.config file.
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.
But here there is no file "Machine.Config" is available in the provided location.
Please help us!
Thanks!