Hello,

Any reports under asset intelligence are no longer working and getting the below error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset DataSet1.

(rsErrorReadingNextDataRow)
For more information about this error navigate to the report server on

the local server machine, or enable remote errors

Details:

System.Web.Services.Protocols.SoapException: An error has occurred

during report processing. --->

Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedExceptio

n: An error has occurred during report processing. --->

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException

: Cannot read the next data row for the dataset DataSet1. --->

System.Data.SqlClient.SqlException: Conversion failed when converting

the nvarchar value 'S-1-5-21-725345543-1060284298-1708537768-11650' to

data type int.
   at

Microsoft.ReportingServices.Library.ReportingService2005Impl.GetReport

Parameters(String Report, String HistoryID, Boolean ForRendering,

ParameterValue[] Values, DataSourceCredentials[] Credentials,

ParameterInfoCollection& Parameters)
   at

Microsoft.ReportingServices.WebServer.ReportingService2005.GetReportPa

rameters(String Report, String HistoryID, Boolean ForRendering,

ParameterValue[] Values, DataSourceCredentials[] Credentials,

ReportParameter[]& Parameters)

-------------------------------
Microsoft.ConfigurationManagement.ManagementProvider.SmsException
An error has occurred during report processing.


Stack Trace:
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterP

resenter.GetParameters()
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterP

resenter.LoadParameters(IReport report, Collection`1

navigationParameters, IResultObject resultObject)
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportView

erPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs

e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object

argument)

-------------------------------

System.Web.Services.Protocols.SoapException
System.Web.Services.Protocols.SoapException: An error has occurred

during report processing. --->

Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedExceptio

n: An error has occurred during report processing. --->

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException

: Cannot read the next data row for the dataset DataSet1. --->

System.Data.SqlClient.SqlException: Conversion failed when converting

the nvarchar value 'S-1-5-21-725345543-1060284298-1708537768-11650' to

data type int.
   at

Microsoft.ReportingServices.Library.ReportingService2005Impl.GetReport

Parameters(String Report, String HistoryID, Boolean ForRendering,

ParameterValue[] Values, DataSourceCredentials[] Credentials,

ParameterInfoCollection& Parameters)
   at

Microsoft.ReportingServices.WebServer.ReportingService2005.GetReportPa

rameters(String Report, String HistoryID, Boolean ForRendering,

ParameterValue[] Values, DataSourceCredentials[] Credentials,

ReportParameter[]& Parameters)


Stack Trace:
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterP

resenter.GetParameters()
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterP

resenter.LoadParameters(IReport report, Collection`1

navigationParameters, IResultObject resultObject)
   at

Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportView

erPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs

e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object

argument)

I have reffer various article and made sure right account is added under SRS, SQL database, Administrator etc

tried removing \adding asset intelligence role ..various reboot but no help.

Please suggest..

Are you sure it is only the AI reports or it is all of the default reports?

Most of the default reports are working... I tried most of them.. found issue only with AI and related to end point protection.

That is interesting, usually it is an all or nothing. I would reinstall your reporting point to see if that fixes the problem.

For me it looks like SQL management provider was not properly registered in WMI, you could try removing the AI role,  then remove reporting point, Wait 15 minutes, Add it back again.

Thanks for reply Prajwal... I would try that, any chance for me of loosing some thing by that move.. like my custom reports?

This have always worked and only recent change I have done is applied SP2.

You will not lose you custom report if you remove the reporting point. If you are concern about it download a copy of the report, so you can load it later. 

Thanks but this did not solve the issue yet.

1. removed AI and Reporting point role

waited for 30 mins and rebooted the machine

2. added both roles - rebooted and still the same:

An error has occurred during report processing. (rsProcessingAborted)

• • Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow)
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

How are you accessing the reports? Via the Console or webinterface?

Have you enabled Remote errors?

http://www.enhansoft.com/blog/enabling-remote-errors-in-sql

Do you have any errors in SRSRP.log?

How are you accessing the reports? Via the Console or webinterface? - Tried both same issue

Have you enabled Remote errors? - dont have that option in my SQL 2012

Do you have any errors in SRSRP.log? - Nope, not at all. It even says "Confirmed the security policy for folder [/ConfigMgr_TOR/Asset Intelligence]." and "Successfully checked that the SRS web service is healthy on server"

Hi Beadmin, Please specify , did the issue resolved or you are still facing the same.

Probably above discussion is not clear enough.. I still have same issue going on and searching for suggestion / solution.

• Edited by Beadmin 21 hours 35 minutes ago

Probably above discussion is not clear enough.. I still have same issue going on and searching for suggestion / solution.

• Edited by Beadmin Wednesday, August 05, 2015 10:17 AM

To be clear:

• Only a few reports are affected by this issue.
• There are no errors within the srsrp.log
• You have enabled report errors

If all of this is true then you show open a case with CSS. There is nothing more we can do to help you.

This is working now.

Now I do have some of the reports double, which were not working before. (probably because of add remove of the role)

I deleted all one with older dates and left the working one.

• Marked as answer by Beadmin 20 hours 28 minutes ago
• Edited by Beadmin 20 hours 18 minutes ago improved