topic Re: Metadata file Oracle.ManagedDataAccess.dll could not be found - Oracle MDA VBO in Digital Exchange

Metadata file Oracle.ManagedDataAccess.dll could not be found - Oracle MDA VBO

chauhannaman98 — Tue, 09 Apr 2024 09:16:12 GMT

Hi all,

I am using Oracle MDA VBO to get collection from Oracle DB.

But I checked the VBO and there is 1 error that says, Metadata file Oracle.ManagedDataAccess.dll could not be found.

What shall I do? II check the path C:\Program Files\Blue Prism Limited\Blue Prism Automate and there is no such DLL file. Is it stored somewhere else on machine which shall be moved to the main path or DLL file is required to be downloaded?

I am running Blue Prism 7.0.0 on Win11 64-bit.

Re: Metadata file Oracle.ManagedDataAccess.dll could not be found - Oracle MDA VBO

faheemsd — Tue, 09 Apr 2024 11:12:31 GMT

Dear @chauhannaman98

You need to download the Oracle.ManagedDataAccess.dll or else ask your Admin team to share the Oracle.ManagedDataAccess.dll

https://www.oracle.com/database/technologies/odac-nuget-downloads.html

Please move the Oracle.ManagedDataAccess.dll to C:\Program Files\Blue Prism Limited\Blue Prism Automate and refresh the Object or Close and Open the object again so that you will have zero Erros.

Regards,
Syed Faheem

Re: Metadata file Oracle.ManagedDataAccess.dll could not be found - Oracle MDA VBO

chauhannaman98 — Tue, 09 Apr 2024 11:58:49 GMT

Hello @faheemsd ,

Thanks for taking the question.

Can you confirm the path of the DLL file in the ZIP folder: ODP.NET_Managed_ODAC122cR1\odp.net\managed\common\Oracle.ManagedDataAccess.dll?

Re: Metadata file Oracle.ManagedDataAccess.dll could not be found - Oracle MDA VBO

faheemsd — Tue, 09 Apr 2024 12:16:00 GMT

Dear @chauhannaman98

Please copy this Oracle.ManagedDataAccess.dll and paste into the C:\Program Files\Blue Prism Limited\Blue Prism Automate