SSRS Report not Returning all data CRM 2013 on Prem

(1) Share

Report

Posted on by Jerett Crumbley

188

I've had a rather curious thing occur today after some security patches were installed over the weekend. Some of our SQL SSRS Reports started only returning one line of data. It has been working for a few months prior and has not changed so that eliminates the report itself having a problem. My next thought is maybe the data didn't come down from our data warehouse due to the updates that were occurring. So I then ran the SQL Profiler to capture the query that the report is generating and I ran the query alone and it then returns all the data expected. This eliminates not having the data. At this point I'm at a little bit of a loss. Has anyone see anything like this before and has any suggestions?

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: SSRS Report not Returning all data CRM 2013 on Prem

Hi, I uninstalled latest patches from the server which has SSRS reporting extensions installed and it fixed the issues.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SSRS Report not Returning all data CRM 2013 on Prem

I have similar issues with Dynamics 365 on-prem. Some of the SSRS reports are returning "rsProcessingAborted" error and some others are returning only a subset of the data. Planning to roll back patches installed on SSRS server.