Connect to database, unable to find Oracle.ManagedDataAccess.Core

Help Activities
, , ,
1

Hi everyone,

I’m trying to convert a process from Windows Legacy to Windows, but I’m struggling with an error I don’t know how to solve.

The dispatcher has a query to find items to populate the queue, the thing is that “connect to database” activity throws an error, even when it’s empty and I try to configure the connection. Here is the error:

image
image552×172 6.09 KB

It doesn’t matter if the activity comes from the Windows Legacy version or if I put a new one, I cannot even configure the connection because I get this error. With Windows Legacy it doesn’t happen.

image

I’ve tried to downgrade and upgrade the database dependencies, but I only have 1.7.0 and 1.7.1 versions, none of those works :frowning:

Do you know how can I fix this?

Thank you so much in advance, have a great day :slight_smile:

2

@angelmonrealr

just to make sure …close the project, delete the folder packages from c:\users\username\.nuget …reopen the project so that dependencies get downloaded again

Also on what version of studio you are on?

cheers

3

Hi Anil,

Thank you for your reply. I don’t have that directory on my machine, not even as a hidden folder…

The UiPath version I have is 23.10.7.

4

@angelmonrealr

username is the current user that you are logged in with…

if not there there you would have configured a different location for .nuget folder…as that folder hosts all the packages you need

also what package feeds are present? you can check in in manage packages → settings

this is official feed if not present add it https://pkgs.dev.azure.com/uipath/Public.Feeds/_packaging/UiPath-Official/nuget/v3/index.json

cheers

5

Hi @angelmonrealr

On top of the above, please confirm that you have the Oracle 64bit driver installed on your machine.

For migration scenario from Legacy to Windows, it is important to mention that the Windows project uses only the 64bit database drivers.

The dependency is also an important factor, of course. The legacy projects used the Oracle.ManagedDataAccess dependency, while the Windows projects use Oracle.ManagedDataAccess.Core dependency.
The the case of Database 1.9.0 package, these are:

The image displays a list of software dependencies for three different .NET versions (.NET Framework v4.6.1, .NETCoreApp v6.0, and .NETCoreApp v6.0) with red arrows pointing to "Microsoft.Identity.Client" and "Oracle.ManagedDataAccess.Core" under .NETCoreApp v6.0. (Captioned by AI)
The image displays a list of software dependencies for three different .NET versions (.NET Framework v4.6.1, .NETCoreApp v6.0, and .NETCoreApp v6.0) with red arrows pointing to "Microsoft.Identity.Client" and "Oracle.ManagedDataAccess.Core" under .NETCoreApp v6.0. (Captioned by AI)342×412 8.86 KB

1 Like
6

Hi again Anil,

Yes, I’ve found the directory with all packages, but even if I delete them, that doesn’t solve the problem. The machines are restarted every day, so all packages have been created today.

I have read another comment about the 64 bit Oracle driver, I don’t have it installed, so I’m gonna try and have it in case that’s the problem.

Thank you so much for your reply :slight_smile:

Have a nice day!

1 Like
7

Hi Maciej,

The machine doesn’t have the 64 bit Oracle driver installed, so I’m gonna ask for it and see if that works.

Thank you so much! :slight_smile:

1 Like