In Progress

Error Connect Bizagi Studio with Oracle 19c

When I create a connection with virtualized entity between Bizagi Studio and Oracle this error is showed : "An unexpected error has occured: please try again. The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception".

My version of Oracle is 19c.

Bizagi Studio Version: 11.2.5.1148

ODAC version : ODAC 12c (version 12.2.0.1

File: ODAC122011_x64.zip

Is someone know where I can see this exception ?

(The error attached also this message)

Thank you for your help

Cedric

Comments (2)

photo
1

Dear Cédric,

Thank you for reaching out to us. We are sorry you are experiencing some issues when connecting Bizagi with Oracle. Looking further into this issue we found a client who reported a similar error and here is the answer the Support team gave them:

"According to the analysis that was carried out by our engineering team, we need you to follow the next steps below in order to solve the issue reported:

1- Proceed to uninstall any oracle-related component off the server from the control panel.

2- After that, ensure that there are no entries left for oracle within the computer's environment variables after proceeding with the uninstallation. If there are any left please delete the record. (Image1 and Image2 attached)

3- Proceed to install The Oracle Data Provider for .NET which is installed through "Oracle Data Access Components (ODAC)" since Bizagi requires the ODAC 11g release For a 64-bit Bizagi setup. Please download the 11.2.0.3.0 x64 release for .NET 4.0: https://bizagi.sharefile.com/public/share/web-s376f5238e23d43d8bc8cd7e2a2eb888b

Please perform a new test and let us know the outcome."

So, please consider following the same steps to see if the issue is solved. If it isn't after following the steps, please let us know.

Kind regards,

Laura G

photo
1

Dear Laura,

Please forgive me for the late response, I see that I have not responded to you yet.

Thank you for your response, as well as the link to download and install the ODAC 11g version compatible with the version of Bizagi Sutdio 11.2.5.1148. Indeed now it works very well. Does this mean that ODAC version 12c (version 12.2.0.1 and newer) will no longer be compatible with Bizagi Studio in the future? In advance, thank you for your response.

Cedric