Cannot read the next data row for the data set MyDataSet

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  April 28, 2010 at 1:01 pm

  #138718

  Getting below error while running the report in SQL Server 2005 SP3 Reporting services. Here, the DataSource is Oracle.

  Cannot read the next data row for the data set MyDataSet., ;

  System.Data.OracleClient.OracleException: ORA-06502: PL/SQL: numeric or value error

  ORA-06512: at "abc.Table", line 92

  Please advice

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  April 28, 2010 at 7:06 pm

  #1159369

  Hi,

  The error is "An arithmetic, numeric, string, conversion, or constraint error occurred."

  This could be data type conversion (or truncation) error. You need to map data types properly between Oracle and SQL Server.

  I would be able to help more if you could send the query that you use in your data set in Reporting Services report.