Server Error in BSI application

book

Article ID: 141802

calendar_today

Updated On:

Products

CA Business Service Insight OBLICORE GUARANTEE

Issue/Introduction

Server Error in '/' Application.


Configuration Error

 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.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 76: <add assembly="Infragistics2.WebUI.Shared.v7.3, Version=7.3.20073.38, Culture=neutral, PublicKeyToken=7DD5C3163F2CD0CB"></add>
Line 77: <add assembly="Infragistics2.WebUI.UltraWebGauge.v7.3, Version=7.3.20073.38, Culture=neutral, PublicKeyToken=7DD5C3163F2CD0CB"></add>
Line 78: <add assembly="Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89B483F429C47342"></add>
Line 79: <add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add>
Line 80: <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>

Source File: C:\inetpub\wwwroot\Oblicore\web.config    Line: 78

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' could not be loaded.

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
 
 

 
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3429.0             
---

 

Cause

ODAC version incompatibility

Changed from ODAC122010Xcopy_32bit to ODAC112040copy_32bit to get this working

Environment

Release : 8.35

Component : CA Business Service Insight

Oracle 12c

Windows 2016 OS

Resolution

If the environment that you are running on single tier and Windows 2016 OS. Please do follow below steps and let me know the behavior if still facing the issue.

1.Uninstall existing odac and reInstall odac112040 attached to the case. i.e. ODAC112040Xcopy_32bit.zip
2. Steps to install odac
      a.Extract the zip file to any directory (in this case c:\ODAC112040) and install it by running it's batch file as below:
      b."install.bat all c:\ODAC112040 myhome true"
3.Update the odac path in environment variables and add the mentioned paths ODAC ,followed by 'bin' path
example: c:\ODAC112040 and then c:\ODAC112040\bin
4.Check and Add ORACLE_HOME if not exists(example:C:\app\Administrator\virtual\product\12.2.0\dbhome_1)
5.Check and Add TNS_ADMIN if not exists(example:C:\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin)
6.Remove the ORACLE Client path  from the path variables if exist unless if you have multi Tier environment i.e. "C:\app\client\Administrator\product\12.2.0\client_1\bin"
7.Shutdown oblicore component services
8.Comment out requireSSL in the web.config(C:\inetpub\wwwroot\Oblicore)

"<!--<httpCookies httpOnlyCookies="true" requireSSL="true"></httpCookies>-->"

9.restart iis.