"Arithmetic operation resulted in an overflow" Error running a report that uses a connection data source to Oracle 10

If you are using Reporting Services to create reports that connects to your Oracle 10 server, you might find yourself with the following error:  “Arithmetic operation resulted in an overflow”   The StackTrace would be the following: System.Data.Odbc.OdbcStatementHandle.RowCount(System.Data.Odbc.SQLLEN ByRef) System.Data.Odbc.OdbcDataReader.GetRowCount() System.Data.Odbc.OdbcDataReader.FirstResult() System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior,System.String, Boolean, System.Object[], SQL_API) System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior,System.String, Boolean) System.Data.Odbc.OdbcCommand.ExecuteReader(System.Data.CommandBehavior) System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(System.Data.CommandBehavior) System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(System.Data.CommandBehavior) Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(Microsoft.ReportingServices.DataProcessing.CommandBehavior) Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery() After struggling to find…

0