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

Products

• Symantec Products

Issue/Introduction

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)

Cause

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

Known version
10.2.0.4.0
10.2.0.5.0
11.2.0.1.0
11.2.0.2.0

Resolution

Installing a patch will solve the issue.

For 10.2.0.4.0, apply Patch 10084982 or later.
For 10.2.0.5.0, apply Patch 10155844 or later.
For 11.2.0.1.0, apply Patch 9966926 or later.
Fixed also in 11.2.0.2.0 Patch 10098816
Download links and some additional information can be found http://blogs.msdn.com/b/mariae/archive/2012/07/05/quot-arithmetic-operation-resulted-in-an-overflow-quot-error-running-a-report-that-uses-a-connection-data-source-to-oracle-10.aspx

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