ARA.ApplicationContentMigrator : Could not load assembly: Oracle.DataAccess

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Our customer update ARA from V12.1 to CDA 12.2, They got below an issue while running  ApplicationContentMigrator
 

2018-08-01 10:04:55,242 ERROR : NHibernate.HibernateException: Could not create the driver from Automic.Ara.Utilities.DbCleanup.OracleDataClientDriverCustom, ApplicationContentMigrator, Version=9.0.0.0, Culture=neutral, PublicKeyToken=null. ---> System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.Exception: Could not load assembly: Oracle.DataAccess
   bei Automic.Ara.Utilities.DbCleanup.AssemblyUtils.LoadAssembly(String name, Assembly referencedBy, Boolean throwOnFail) in E:\BuildAgent\work\bondrelease\9.0.0\Projects\DBCleanup\DbCleanup\SessionFactoryBuilder.cs:Zeile 212.
   bei Automic.Ara.Utilities.DbCleanup.OracleDataClientDriverCustom..ctor() in E:\BuildAgent\work\bondrelease\9.0.0\Projects\DBCleanup\DbCleanup\SessionFactoryBuilder.cs:Zeile 88.
   --- Ende der internen Ausnahmestapel�berwachung ---
   bei System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   bei System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   bei System.Activator.CreateInstance(Type type, Boolean nonPublic)
   bei System.Activator.CreateInstance(Type type)
   bei NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary`2 settings)
   --- Ende der internen Ausnahmestapel�berwachung ---
   bei NHibernate.Connection.ConnectionProvider.ConfigureDriver(IDictionary`2 settings)
   bei NHibernate.Connection.ConnectionProvider.Configure(IDictionary`2 settings)
   bei NHibernate.Connection.ConnectionProviderFactory.NewConnectionProvider(IDictionary`2 settings)
   bei NHibernate.Cfg.SettingsFactory.BuildSettings(IDictionary`2 properties)
   bei NHibernate.Cfg.Configuration.BuildSettings()
   bei NHibernate.Cfg.Configuration.BuildSessionFactory()
   bei Ventum.Bond2.ApplicationContentMigrator.ApplicationMigrator..ctor(String connectionString, DatabaseType databaseType, ConnectionInfo aeConnectionInfo) in E:\BuildAgent\work\bondrelease\9.0.0\Projects\ApplicationContentMigrator\ApplicationContentMigrator\ApplicationMigrator.cs:Zeile 28.
2018-08-01 10:04:55,258 ERROR : Unknown exception: Could not create the driver from Automic.Ara.Utilities.DbCleanup.OracleDataClientDriverCustom, ApplicationContentMigrator, Version=9.0.0.0, Culture=neutral, PublicKeyToken=null.

 

Environment

Database Version ORACLE 12.1.0.2.0 - 64bits Production

Cause

Dupplicated version of ORACLE client and ODAC

Resolution

- Check current version of ORACLE database
- Remove current ORACLE client 
- Install ODAC from below link