Error migrating to 7.6 SR4

dani

Hi,
We have migrate our development platform that was based on Windows 2008 64bits Metastorm 7.6 SR3 from Oracle 11GR1 to 11GR2.

As a consequence of this change, we have been forced to migrate to 7.6 SR4 as it's compatible with Oracle 11GR2

We have uninstall the Oracle Client 11R1 Patch 9166858 to install the new 11R2, regarding the Metastorm documentation, it's mandatory.

After upgrade the client, apply the Metastorm patch and execute the migration scripts, the engine doesn't start and the following message is shown on the Event Log

The .NET database connector failed to initialize: 
System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, 
PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

File name: 'Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342'

   at Metastorm.Engine.Database.OracleDatabaseConnector.IsEngineActive(String engineName)

   at ManagedConfiguration.StartDatabaseConnection(HStatus* , HServerData* serverData, CStringT<wchar_t\,StrTraitMFC_DLL<wchar_t\,ATL::ChTraitsCRT<wchar_t> > >* configOutput)

 

=== Pre-bind state information ===

LOG: User = DOMAIN\user

LOG: DisplayName = Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342

 (Fully-specified)

LOG: Appbase = file:///C:/Program Files (x86)/Metastorm BPM/Engine/

LOG: Initial PrivatePath = NULL

Calling assembly : Metastorm.Engine.Database, Version=7.5.0.769, Culture=neutral, PublicKeyToken=0fa3cc64eebf4c8b.

===

LOG: This bind starts in default load context.

LOG: Using application configuration file: C:\Program Files (x86)\Metastorm BPM\Engine\Application.Config

LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.

LOG: The same bind was seen before, and was failed with hr = 0x80070002.

Can you help me to understand what is wrong?

Thanks

Regards

Christian Sennewald

Hy

does anybody has an answer for this issue.

We are facing with the same problem at the moment.

 

thanks and kind regards

 

Chris

Jacob_Eastman

The issue is that the new version of Oracle driver has a different version from the assembly that BPM is looking for:

System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, 
PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

 

To resolve this, first lookup the version of your Oracle.DataAccess in the GAC (C:\WINDOWS\Assembly). You will need to right click -> Properties to see the full version number. Make a note of the number.

 

Next, open your ~\Metastorm BPM\Engine\application.config. Add the following section at the end of the file just before the closing tag. Be sure to replace the *.*.*.* below with the version number you found in the GAC

 

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <probing privatePath=".\dotnetbin;.\dotnetlib"/>
        <dependentAssembly>
            <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" /> 
            <bindingRedirect oldVersion="10.1.0.200" newVersion="*.*.*.*" /> 
        </dependentAssembly>
    </assemblyBinding>
  </runtime>