SCCM Reporting Point Error after R2 Upgrade

Benoit LecoursSCCM, SSRS1 Comment

This post explains how to fix SCCM Reporting Point Error after R2 Upgrade. SCCM Reporting Point Error after R2 Upgrade Problem : After upgrading from SCCM 2012 SP1 CU2 to SCCM 2012 R2. You get the following error when running reports : 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-1010946700-728571707-39459515-134623’ to data type int. Removing and adding the “Reporting Service Role” did not fix the issue. SRSRP.log has Invalid Class errors : Invalid class SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0)Could not retrieve the reporting service name for instance ‘RPSERVER’ SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0)Invalid class SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0)Could not stop the reporting service ” SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0)Next security configuration at [07/7/2014 1:52:12 PM] SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0) Resolution:The problem is due to the … Read More