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

[GhaithAbdessale]

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
------------------------------

[GeoffHirst]

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
------------------------------

[GeoffHirst]

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
------------------------------

[GhaithAbdessale]

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
------------------------------

[GeoffHirst]

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
------------------------------

[GhaithAbdessale]

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
------------------------------

[GeoffHirst]

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
------------------------------

[GhaithAbdessale]

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

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

[GeoffHirst]

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