search cancel

Error: "Test failed. Arithmetic operation resulted in an overflow."


Article ID: 161638


Updated On:


Symantec Products


When using Data Connector, testing an ODBC data source to an Oracle database results in an error: "Test failed, Arithmetic operation resulted in and overflow."

"Errors","--","Arithmetic operation resulted in an overflow.
   [System.OverflowException @ System.Data]
   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)
   at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Altiris.Connector.DataSource.OdbcDataSource.DataSourceData(DateTime lastImport, StringCollection columns, Hashtable args)
   at Altiris.Connector.DataSource.DataSourceBaseItem.LoadDataFromForeignSource(DateTime lastImport, Boolean bEnableDataPreProcessing, StringCollection columns, Hashtable args, Boolean& moreData)
   at Altiris.Connector.Web.DataSource.DataSourceViewData.DisplayDataSourceData(DataSourceBaseItem ds, Boolean bShowRaw)


This is caused by a bug in the 64bit Oracle ODBC Driver on certain versions.

Known version


Installing a patch will solve the issue.

For, apply Patch 10084982 or later.
For, apply Patch 10155844 or later.
For, apply Patch 9966926 or later.
Fixed also in Patch 10098816
Download links and some additional information can be found

Please note: The download links in the linked article require an Oracle account. You may need to contact someone within your organization to gain access to them.


A workaround can be to use an OLEDB data source, as they are not effected by this bug.

Applies To

Windows Server 2008r2
Altiris 7.5