Hello,
I’m following one guide (Create an RPA Flow that Connects to DB2 Data in UiPath Studio) to configure access to DB2 DB on uipath, here are the steps:
NOTE - using UiPath Community version
- I download the IBM DB2 ODBC Driver, install it and configure it , test connection successfully.
- Configure “Connect” activity, and test connection successfully.
- Exception report when executing “Execute query” activity, error msg as title
RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HY000] Exception has been thrown by the target of an invocation.
Server stack trace:
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method,
Boolean needReader,
Object methodArguments,
SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method,
Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at UiPath.Database.DatabaseConnection.ExecuteQuery(String sql,
Dictionary`2 parameters,
Int32 commandTimeout,
CommandType commandType)
at UiPath.Database.Activities.ExecuteQuery.<>c__DisplayClass38_0.b__0()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md,
Object args,
Object server,
Object& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg,
IMessageSink replySink)
Exception rethrown at [0]:
at UiPath.Database.Activities.ExecuteQuery.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)