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..