SCCM 2012 R2 Reporting error

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

February 3rd, 2014 3:45pm

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?

Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 5:05pm

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

February 3rd, 2014 5:34pm

Which report gave you the above error?  I know you said you have a few reports with errors.
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 5:39pm

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

February 3rd, 2014 5:42pm

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

Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 5:55pm

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?

February 3rd, 2014 6:12pm

I don't see Invalid Class  in the log

Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 6:20pm

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)

February 3rd, 2014 6:25pm

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.

Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 8:07pm

thanks, I'll try it
February 3rd, 2014 8:21pm

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

Free Windows Admin Tool Kit Click here and download it now
February 4th, 2014 5:12pm

  • 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

  • The error suggest that remote errors has not be enabled on your SSRS server.
    February 4th, 2014 5:32pm

    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.

    Free Windows Admin Tool Kit Click here and download it now
    February 4th, 2014 6:00pm

    what else can I do?
    February 5th, 2014 8:27am

    How is you SSRS setup?

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

    Free Windows Admin Tool Kit Click here and download it now
    February 5th, 2014 2:58pm

    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

    February 5th, 2014 3:34pm

    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

    Free Windows Admin Tool Kit Click here and download it now
    February 8th, 2014 8:30am

    Disabling RBA is not a solution is only hides the problem.
    February 13th, 2014 3:47pm

    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?

    Free Windows Admin Tool Kit Click here and download it now
    March 11th, 2014 10:21pm

    Does anyone else have any other recommendations?


    I have talked to the product team about this and their recommendation is to contact CSS for support.
    March 12th, 2014 1:30am

    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.


    Free Windows Admin Tool Kit Click here and download it now
    March 12th, 2014 4:09pm

    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 have emailed the prod team and I will let you know what I heard back.
    March 12th, 2014 5:36pm

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

    Free Windows Admin Tool Kit Click here and download it now
    March 12th, 2014 5:44pm

    REG:114031211255226
    March 12th, 2014 5:45pm

    Thanks, I have forward it on.
    Free Windows Admin Tool Kit Click here and download it now
    March 12th, 2014 5:53pm

    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

    March 12th, 2014 5:53pm

    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

    Free Windows Admin Tool Kit Click here and download it now
    March 18th, 2014 2:11pm

    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

    March 18th, 2014 3:13pm

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

    Free Windows Admin Tool Kit Click here and download it now
    March 18th, 2014 3:24pm

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

    March 18th, 2014 3:32pm

    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
    Free Windows Admin Tool Kit Click here and download it now
    March 18th, 2014 3:55pm

    In this case our configuration is set to use the Local System. As a test I added our sqlserver computer account to the Windows Authorization Access Group. Same results on my end with Rbac reporting enabled.
    March 18th, 2014 4:10pm

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

    Free Windows Admin Tool Kit Click here and download it now
    March 18th, 2014 4:39pm

    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.

    March 18th, 2014 4:48pm

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

    Free Windows Admin Tool Kit Click here and download it now
    March 18th, 2014 6:02pm

    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.

    March 18th, 2014 6:09pm

    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?

    Free Windows Admin Tool Kit Click here and download it now
    March 7th, 2015 12:03pm

    This topic is archived. No further replies will be accepted.

    Other recent topics Other recent topics