This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

When attempting to register an Oracle Service Instance, the following error appears:

"SmartObject Server Exception: Could not load file or assembly 'SourceCode.SmartObjects.Services.Oracle', Version 4.0.0.0, Culture=neutral, PublicKeyToken=null or one of its dependencies. The System cannot find the file specified"

Symptoms

This error usually appears if the ODAC has not yet been installed from (http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html).

However, the ODAC was installed using the 'Universal Installer (setup.exe)' and the server was restarted.

The 'SourceCode.SmartObjects.Services.Oracle' broker requires the 'Oracle.DataAccess' Version=2.112.2.0 assembly and its dependencies in the GAC to load successfully when attempting to register a service instance.

Image

The ODAC can be installed in two ways:

  1. Universal Installer (setup.exe)
  2. Xcopy installer (install.bat)

If using the Universal Installer, the 'ODP.NET (Oracle Data Provider for .NET) > 'Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level' option needs to be checked during the installation for the needed assemblies to get added to the GAC.

Resolution

Re-install the ODAC using the Universal Installer with the 'ODP.NET (Oracle Data Provider for .NET) > 'Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level' option checked.  Restart the K2 Blackpearl server and retest.

Image