Answered

ODP.net problem - Studio installation

Hi all,

I have two virtual machine one is windows 8.1 64-bit and other is centos 6.6 32-bit. On centos we have oracle 11.2.0.1.0 32 bit.

Before installing bizagi studio I installed ODP.net both 32-bit and 64-bit on windows. After ODP.net installation, I installed the stuio. Lastly, when I try to create new project, it asks the db connection details, I properly entered them but it exits abnormall throws Oracle.DataAccess.dll error. What am I missing?

Best Answer
photo

Dear Serman,

In order to work correctly, please uninstall both ODP.net x32 and x64. Then only install again x64-Bit because Bizagi x64 Bit only works with ODP.net X64 Bit. and if you are working with Bizagi x32 then only need to install ODP.net x32.

Please check these articles:

Regards

Comments (5)

photo
0

Dear Serman,

In order to work correctly, please uninstall both ODP.net x32 and x64. Then only install again x64-Bit because Bizagi x64 Bit only works with ODP.net X64 Bit. and if you are working with Bizagi x32 then only need to install ODP.net x32.

Please check these articles:

Regards

photo
0

Hello Juan,

At first I installed both of them according to article below:

http://help.bizagi.com/bpmsuite/en/index.html?installing_oracle_data_provide.htm

"Recall that you will need to run both the 32-bit and 64-bit ODAC release on a 64-bit Bizagi Studio installation." There are some inconsistencies in your stuio and engine help content, please correct them.

Nevermind, before all these installations, I had got backup my windows64-bit and centos32bit ora-11g vm in case of clean installation need.

Therefore I boot win8, centos from backup and as you suggested I installed only the ODP.net x64 and then check the ora client whether it is able to connect to oracle or not(both tnsnames and ezconnect). It has succeeded. Afterwards, I installed Bizagi x64.

Lastly, I have tried to create new project via oracle. I have checked "If BizAgiAdmin user is not created" and "Create Oracle Instance automatically" and entered service, dbauser dba pass inputs properly:

service: 192.168.176.128:1521/bizagi

dba user: sys

pass: password

but I am still getting following error: "The type initializer for 'Vision.DA.COracleDataProviderBase' threw an exception" and the detail:

System.

BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.File name: 'Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' at Vision.DA.COracleDataProviderBase.Dispose(Boolean disposing) at Vision.DA.COracleDataProviderBase.Finalize()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].cleardot

Regards

photo
0

Dear Serhan,

Please follow up the article where explains step by step how to create_a_project_in_oracle.

regards

photo
0

Dear Juan,

Thank you for your prompt answers.

The problem was not about following up the articles I think, it was related to between 32bit oracle and 64bit ODP.net. After installing all the components in same architecture(either 32-bit or 64-bit arch), the problem resolved.

Regards

photo
1

hi,

We have installed all the components in same architecture i.e 64bit but still same error: 'type initializer for 'Vision.DA.COracleDataProviderBase'

Kindly help to resolve.