Execute Query throws an Arithmetic operation resulted in an overflow error

News Knowledge Base
1

Unable to execute the query from UiPath Database activities(1.5.0). Getting error in Execute Query: "Arithmetic operation resulted in an overflow." However, it is able to execute queries on Oracle DB.

Issue Description:

Unable to execute query from UiPath Database activities(1.5.0). Getting error "Execute Query: Arithmetic operation resulted in an overflow."

Whereas it is possible to execute queries on Oracle DB.

Oracle ODBC Driver - Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2]

Microsoft Windows x64 (64-bit)

Retrieving data using a .NET ODBC application may fail with:

'Arithmetic operation resulted in an overflow'. This can occur with a call to ExecuteReader on the OdbcCommand object, the fill method of the OdbcDataAdaptor object and others.

For Example, calling ExecuteReader on a OdbcCommand Object Fails With:

Exception Type: system.overflowexception

Error: Arithmetic operation resulted in an overflow.

Source: System.Data

StackTrace:

at System.Data.Odbc.OdbcStatementHandle.RowCount(SQLLEN& rowCount)
at System.Data.Odbc.OdbcDataReader.GetRowCount()
at System.Data.Odbc.OdbcDataReader.FirstResult()
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)

Root Cause:

Bug impacts 10.2.0.4.0, 10.2.0.5.0 and 11.2.0.1.0 but not 11.1.0.7.0 as of Patch 32.

Resolution:

  • Apply a recent patch set to 10.2.0.4.0 or upgrade the Oracle ODBC driver from a previous version to 11.2.0.1.0 on x64.