System.Data.Odbc.OdbcException: ERROR [HY000] no more data in current reader

Help Studio
, ,
1

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:

  1. I download the IBM DB2 ODBC Driver, install it and configure it , test connection successfully.
  2. Configure “Connect” activity, and test connection successfully.
  3. Exception report when executing “Execute query” activity, error msg as title
    RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HY000] no more data in current reader.

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)

thx much !

2

Hi @yajyao !
From my researches, I found the following information:
“The “No more data available to read” error is a generic error message that the driver generates when there has been a network problem such as a dropped connection.
This error can occur in several different situations involving query timeouts, firewall timeouts, network misconfiguration and defects.”

Would you mind checking outside of UiPath Studio if the query returns something ?

3

Try to open ports 1433 and 1434 on firewall between SQL server and PC.
Do you have any issues if you connect to DB via SSMS from this machine ?