MDA Oracle Blue prism - Bulk copy CSV Error after importing the object
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-22 02:32 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-22 06:27 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-22 07:21 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-22 07:30 PM
Here is the details page of the dll I am using.
https://api.256file.com/download/6150_oracle.manageddataaccess.dll
Thank you.
------------------------------
Ghaith Abdessalem
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-22 08:26 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-22 10:19 AM
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.
Thank you for your help.
------------------------------
Ghaith Abdessalem
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-22 10:30 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-22 03:54 PM
I got my first querry running with the MDA function !
------------------------------
Ghaith Abdessalem
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-22 04:01 PM
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
