Connect to Oracle DB from user machine

Help Robot
, ,
1

hi all,

i have created process that read data from oracle DB once i run it from server that i i built process on it “server that have studio” it run successfully, but if i run it on user machine either attended or from orchestrator i gave below error.

Info: Connection request timed out Oracle.ManagedDataAccess.Client.OracleException: Connection request timed out at OracleInternal.ConnectionPool.PoolManager3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OracleConnectionDispenser3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria) at Oracle.ManagedDataAccess.Client.OracleConnection.Open() at UiPath.Database.DatabaseConnection.OpenConnection() at UiPath.Database.DatabaseConnection.Initialize(String connectionString, String providerName) at UiPath.Database.DBConnectionFactory.Create(String connectionString, String providerName) at UiPath.Database.Activities.DatabaseConnect.<>c__DisplayClass19_0.b__1() at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj) at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) — End of stack trace from previous location — at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) — End of stack trace from previous location — at UiPath.Database.Activities.DatabaseConnect.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken) at UiPath.Database.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager

2

@takyysh

Is that server accessible crom user machine?

You xan check by using cmd and then ping <ipaddressOfServer>

If no access…asl your admin to provide the access

Cheers

3

@takyysh It seems like your process is having a timeout issue when trying to establish a connection to the Oracle database. Make sure you are connected to proper network or check if there are any timeout settings for your oracle connection activity. Check the connection string.

4

Hi @takyysh ,

Try increasing the timeout and let us know if issue persist.

Thanks and regards,
Suraj Setty

5

Hello @takyysh
Try this

  1. Check the DB connection String or create new one on User machine and Test the connection on User machine.
  2. Check the Permission to access the DB on User machine.
  3. Otherwise increa the Timeout Property.
6

Hi @suraj.setty thanks for support
I have add connect timeout =60000 to be 1 minute,but without any help.

7

Hi @Gokul_Jayakumar
Thanks for support,
There is no direct connection between user machine and DB because policy procedure.
But regarding point 1 how i will create connection string on user machine and it doesn’t have UiPath studio.
Regarding timeout what is proper time to add i have added one minute to connection string but without any help.

And the server for dev that is working successfully have access to DB

Is there another approach rather than direct access to DB from user machine

8

Hi @Anuja_Ravikant_Khamitkar
I have added manually 60000 to be one minute without any help

9

Hi @Anil_G
Thanks for support

There is no connection between server and user machine but server has access to DB and user machine doesn’t have. And we cant create connection from user machine to DB because client policy, so if i create connection between user machine and server that have access to DB, it will work??

10

@takyysh

Yes it should…you need a connection to work with

Cheers

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.