SQL report (query) stopped working after SCCM 2012 upgrade to R2

Just upgraded our SCCM 2012 server to R2. Now when I try to run the "Computers for a specific user name" report it errors out with the following errors:

An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset DataSet1. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

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


 Stack Trace:
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.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
 An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset DataSet1. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors


 Stack Trace:
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
    at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
    at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
    at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

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

You click ok and then this one pops up:


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
 For more information about this error navigate to the report server on the local server machine, or enable remote errors


 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)

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

Anyone have any ideas or having the same issue?
LVL 1
adml_shakeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Can you run the SQL code in SSMS query to see if you have any "NULL values within aggregate functions" warnings showing up?

If yes try SET ANSI_WARNINGS OFF

Or maybe is something tied to:

http://technet.microsoft.com/en-us/library/dn236351.aspx#BKMK_WhatsNew_Monitoring_and_Reporting

in particular:
"
The following items are new or have changed for reporting in System Center 2012 R2 Configuration Manager:
• Configuration Manager reports are now fully enabled for role-based administration. The data for all reports included with Configuration Manager is filtered based on the permissions of the administrative user who runs the report
"
0
adml_shakeAuthor Commented:
Do you happen to know where that info would be stored?  I know how to run it once in SSMS but I don't know what that query info would be kept on the server.
0
lcohanDatabase AnalystCommented:
You would need to locate the RDL - SSRS report file for "Computers for a specific user name" and try edit it in report builder to see what code (data set properties) is running - may not be so easy to do I know...its all new and supposed to be working.

Actually......looks like the link below will take exactly to the code for that report:

http://social.technet.microsoft.com/Forums/en-US/cf9d4027-c0bd-4ae0-a9aa-86c7358d517f/sccm-2012-sp1-reporting-list-all-computers-in-a-specific-collection-with-hardware-data?forum=configmanagergeneral
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

adml_shakeAuthor Commented:
Okay, so this seems to be a permissions issue based on this
Screen shot of error we get
But looking at the permissions I'm not seeing where the problem could be.  I'm a report admin/user for the SCCM sql server as is everyone else.
0
adml_shakeAuthor Commented:
Finally managed to figure this out.  A few months back we had a SQL corruption problem on our SCCM server and had to create a new Reports Database.  During the install of R2, for some reason it reverted back to looking for the old database.  Once I set it back to the correct database everything seemed to work fine.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
adml_shakeAuthor Commented:
Answer wasn't from any of the provided answers.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.