hi all,

some report I can open and others I get an error:

Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)

Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
   at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
   at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)

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

Microsoft.Reporting.WinForms.ReportServerException
Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow)

Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
   at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
   at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)

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

Microsoft.Reporting.WinForms.ReportServerException
Conversion failed when converting the nvarchar value 'S-1-5-21-159793906-1513374725-7473742-7662' to data type int.

Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
   at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
   at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession()
   at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters)
   at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)

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

how can I solve this error?

thanks

looks like some data got crossed somewhere

Conversion failed when converting the nvarchar value 'S-1-5-21-159793906-1513374725-7473742-7662' to data type int.

The report things the column is an int when that value isn't going to convert successfully.  As to why that is the cause, I am not sure.

What is the history of this install?  What version are you currently on?

I started with sccm 2012 to sp1 and its worked great, but after I upgraded to r2 I got an error

I am on 2008 r2 & sql 2008 r2

take a look here, it's a similar issue

http://social.technet.microsoft.com/Forums/en-US/ae08aa43-054d-47e7-99fb-c4f101962478/reports-not-working-after-upgrade-to-sccm-2012-r2-?forum=configmanagergeneral

i enter the commend         mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

i still get the same error

i want to get Asset Intelligence report exemple

some of them works and some none

did you take a look at the following logs

To diagnose this on the Reporting Service Point look in the srsrp.log for entries indicating of an Invalid Class

Do you have that same error?

I don't see Invalid Class  in the log

when I enter to that report by right click - edit to sql builder I get

Conversion failed when converting the nvarchar value 'S-1-5-21-159793906-1513374725-7473742-7662' to data type int.
----------------------------
Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow)
----------------------------
An error has occurred during report processing. (rsProcessingAborted)

A few things.

First off it looks like you are trying to access the reports via the console. Access them via the website. Do you still get the error?

BTW, this might be of interest to you.

http://be.enhansoft.com/post/2013/09/10/Should-Configuration-Manager-SSRS-or-ASP-Reports-be-Accessed-from-the-Browser-or-the-Console.aspx

Secondly, Enable remote errors within SSRS/SQL.

http://be.enhansoft.com/post/2013/01/16/Enabling-Remote-Errors-in-SQL.aspx

Third, re-install the RP.

I did what you suggested but I still have an 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

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

I enable the report remote errors, this is the error

• An
  error has occurred during report processing. (rsProcessingAborted)
  
  • Cannot
    read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow)
    
    • Conversion
      failed when converting the nvarchar value
      'S-1-5-21-159793906-1513374725-7473742-7887' to data type int.

How is you SSRS setup?

What service accounts are you using for SSRS and Execution account?

I have the same setup when it was in sp1=worked

so i re-install the RP by your advice and it still not working

i use the configmgr admin account without Execution account

I had the exact same problem.

I found 2 solutions to this, where the first solution was temporary.

1. Try to change the RegKey HKLM\SOFTWARE\Microsoft\SMS\SRSRP\EnableRbacReporting from 1 0. Then run the report again, it should run normally. In my case it did change back to 1 after some time and turned out to be a temporary fix. But it provided an explanation why this happened after the R2 upgrade and actually it breaks the new reports RBAC feature of R2.
2. The second solution I found in this thread:

http://social.technet.microsoft.com/Forums/en-US/ae08aa43-054d-47e7-99fb-c4f101962478/reports-not-working-after-upgrade-to-sccm-2012-r2-?forum=configmanagergeneral

Just read the explanation and run the mofcomp command.

It did the trick for me J

I am facing this exact same situation. My environment was on 2012 SP1 and I just completed the R2 upgrade. According to the installer everything completed successfully. The error is displayed as follows: 

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow)
Conversion failed when converting the nvarchar value 'S-1-5-21-842925246-492894223-1060284298-35702' to data type int. 

Disabling RBAC via the registry key does allow the report to run (EnableRbacReporting set to 0), but I'm not happy with that resolution. Thus far I've attempted re-installing the reporting role AND running the following mofcomp:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

Does anyone else have any other recommendations?

Does anyone else have any other recommendations?

I opened a case after seeing your response. The technician ensured me that the registry key change is indeed the fix. As I understand it if you were leveraging RBAC with SP1 then the R2 upgrade would inherit this issue, requiring the registry key to be manually changed. I was told setting this key to 0 would resolve my issue and not cause any issues with RBAC.

I opened a case after seeing your response. The technician ensured me that the registry key change is indeed the fix. As I understand it if you were leveraging RBAC with SP1 then the R2 upgrade would inherit this issue, requiring the registry key to be manually changed. I was told setting this key to 0 would resolve my issue and not cause any issues with RBAC.

Can you email me (or post here) your case id?

Official email response from the incident:

ISSUE:

=========

•       unable to run reports after upgrading

RESOLUTION:

==========

•       1.Go to regedit

        2.Navigate to ->  Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\SRSP

        3.The RBACReporting needs to be changed form 1 to 0

        4.Click on EnableRbacReporting  change the values from 1 to 0

        5.Restart the SQL / Reporting Service

Hi ImageGuy,

Quick question - what version of SQL Server Reporting Services are you using?

The reason I ask is the mofcomp command in that other thread is version specific to SQL Server 2008 R2. It also assumes you've got SQL Server Reporting Services installed to C:\.  Here are the major versions' command lines:

2008:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

2008 R2:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

2012:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"

Obviously - you'll have to change that as appropriate if SQL Server is installed somewhere else.

Let me know if that works out for you - you'll need to give SSRS a couple of minutes to detect the fixes that the ConfigMgr RSP is doing.

Regards,
Saud

We also had an issue with RBAC reporting being on by default after the upgrade to SCCM 2012 R2. Disabling it worked temporarily but it turned out to be the fact the SQL reporting services account had to be added to "Windows Authorization Access Group" in active directory as per this thread.

I don't know if this is the cause of your specific issue but it may be worth a try to rule it out.

Shaun

@SaudM

We are indeed running SQL 2008 R2 and utilized the command you referenced above:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

After following the steps outlined by the technician we discovered the "EnableRbacReporting" registry key would continue to flip back to 1 after some unknown time interval. I've kept in contact with the technician and thus far nothing we have tried has successfully kept the Rbac Reporting disabled.

I'm glad to see Shaun's post - I will absolutely give this a try and report back my findings.

@Shaun

I'm continuing to learn SQL as I go. How do I know what account is used for SQL reporting services? In our environment the primary site DB and SSRS are on a dedicated server, each with their own instance.

On your reporting services server, open "Reporting Services Configuration Manager" and the first node in the left panel "Service Account" is the one you need to add to the group as per the screenshot below.

Shaun

• Edited by Mollypebble Tuesday, March 18, 2014 3:56 PM

Hmm...interesting...can you share out the srsrp.log from your environment?

It definitely looks like a failure to complete SRSRP setup - because we need some utility DLLs to assist with the RBAC functionalities but they have to be dropped into the SSRS location for 3rd party binaries. We use WMI to find that location and that provider gives us that location. This happens within SRSRP operationally not the setup of SRSRP itself.

Now it possible that in your case it doesn't have anything to do with locating the install path - but something else preventing dropping the latest DLLs.

Trying to help out as I hit the same issue in my lab today due to missing WMI Provider in SSRS. :)

Certainly. Please try the following link:

https://www.dropbox.com/s/jv98g9tosszgjcz/srsrp.log

I've replaced server names / service accounts in the log file.

Curious - this matches my setup's log files (after I fixed things).

Silly question but have you bounced the SSRS service on whatever SQLSERVER.DOMAIN.COM really? :)

Can you check these files for me (these are some of the files we install that give us the SID lookup capabilities for RBAC)?

F:\SMS_SRSRP\SrsResources.dll (it should be version 5.0.7958.1000)

<Location where SSRS is installed>\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\srsresources.dll (should be the same version as the above).

Yep - that service has been bounced a few times troubleshooting this issue.

I checked those 2 files. The version information for the file under F:\SMS_SRSRP is blank... Date Modified and file size seem to match up. The image on the left is coming from the F:\SMS_SRSP directory. The image on the right is from the SSRS install location.

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?