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.
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
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 220.127.116.11, Culture=neutral, PublicKeyToken=null or one of its dependencies. The System cannot find the file specified"
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=18.104.22.168 assembly and its dependencies in the GAC to load successfully when attempting to register a service instance.
The ODAC can be installed in two ways:
- Universal Installer (setup.exe)
- 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.
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.