topic RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object in Product Forum

MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GhaithAbdessale — Wed, 16 Mar 2022 14:32:00 GMT

Hello,
I have recently imported "Oracle MDA - Utility - 1.1.0" as an object to blue prism in order to use it for automating querries.
I have also placed the Oraclemanagedaccess.dll in the blueprism automate folder.
But I have faced the following problem with the "Bulk copy Csv" stage
Error details :
Stage: Bulk Copy CSV Data
Type: Error
Action: Validate
Description: Compiler error at line 7: The type or namespace name 'OracleBulkCopy' could not be found (are you missing a using directive or an assembly reference?)
Repairable: No

can anyone help me to solve this problem ?

------------------------------
Ghaith Abdessalem
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GeoffHirst — Wed, 16 Mar 2022 18:27:00 GMT

HI Ghaith,

Thank you for using Blue Prism.

Firstly, can you check that you are using Oracle V21c or later? This feature requires at least that version of Oracle to work correctly. Resultantly, you may have a previous release of the managed data access dll.

Come back to us if you need more assistance.

Once again, thank you for being a SS&C Blue Prism customer.

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
Blue Prism
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GeoffHirst — Wed, 16 Mar 2022 19:21:00 GMT

Hi,

Sorry the image above is a little small. This is the details page of the DLL and it shows the version you need.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
Blue Prism
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GhaithAbdessale — Wed, 16 Mar 2022 19:30:00 GMT

Hello Geoff,
Here is the details page of the dll I am using.

I have downloaded it from the following link :
https://api.256file.com/download/6150_oracle.manageddataaccess.dll

Thank you.

------------------------------
Ghaith Abdessalem
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GeoffHirst — Wed, 16 Mar 2022 20:26:00 GMT

Hello Ghaith,

The version I have came from Nuget. You can get it here https://www.nuget.org/packages/Oracle.ManagedDataAccess/

This might only be familiar to you if you are also a .NET developer. The file that you will get from here is a filetype of nupkg. Please let me know if you need any further assistance with working with this file.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GhaithAbdessale — Thu, 17 Mar 2022 10:19:00 GMT

Hello Geoff,
Thanks, I have downlaoded the file from nuget. then I have extracted the dll.
I no longer have the Bulk copy error or any other error on the MDA oracle object.
I started to set a connection
but then when I launched a simple querry I got the following error.
As I was debugging step by step I found that the error appeared in the following stage :

Thank you for your help.

------------------------------
Ghaith Abdessalem
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GeoffHirst — Thu, 17 Mar 2022 10:30:00 GMT

Ghaith,

This kind of message is prevalent when Blue Prism cannot locate a DLL. Now, what I would ask is, did you install the nuget dll into the Blue Prism folder whilst Blue Prism was running?

What I would suggest is to close down Blue Prism, retry and let me know the outcome.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GhaithAbdessale — Thu, 17 Mar 2022 15:54:00 GMT

Thank you a lot Geoff,
I got my first querry running with the MDA function !

------------------------------
Ghaith Abdessalem
------------------------------

RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

GeoffHirst — Thu, 17 Mar 2022 16:01:00 GMT

Ghaith,

That's really great to know. As always, come back to us here if you need any further help.

Thank you for being an SS&C Blue Prism customer.

regards

Geoff Hirst

SR DX Engineer, Integration and Enablement, Blue Prism Digital Exchange

Re: RE: MDA Oracle Blue prism - Bulk copy CSV Error after importing the object

gkori — Fri, 09 May 2025 04:01:34 GMT

HI Ghaith,

I am also getting the same error So can you please let us know how this was resolved after replacing the DLL file?