Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I've a TEST bed system with GP 2015R2 that I setup a few month ago for the upgrade UAT of our GP2010R2. When the system was upgraded, GP Utilities automatically re-deployed / upgraded all the Excel / SSRS reports, but this is kind of a bug as it didn't ask you the permissions to do it, and often your deployed report configuration still points to your current production system, which in this case just replaced them all for all the companies.. I was able to re-deploy my reports in GP 2010R2 and there wasn't much damage luckily.
I'm now trying to re-deploy to the proper location all my reports in GP 2015R2 and have no issues with Excel... but the SSRS part just doesn't want to work. Somehow the system thinks they are already deployed and don't want to re-apply them, even they are completely absent from the new SSRS server I setup localy.
As you can see from the screenshot above, the settings are all done as expected, but the system just refuses to redeploy them.
What's in your SY40800 Reporting Tools Setup file? Have you tried clearing that?
Just ran into the same issue today as well. I can't find a way to prevent the SSRS reports on the production system from getting over-written during a test upgrade on a separate server
The SY40800 table contains the exact information from my deployment sites (Excel, SSRS and MR2012)... nothing wrong there.
One way to avoid this (and I forgot all the time before running GP Utilities, because it's not something you do every day :-) ), is to either update the path for all the files in the DYNAMICS..syDeployedReports table or delete all the entries, as this is the place where all the locations are stored. There are 4 different entries identified by the field [ObjectType]:
1. SSRS Report Models
2. SSRS reports
3. Excel Data Connection file
4. Excel Reports
The field [DeployedPath] contains the location of each of the reports... When you delete the entries for a given company, the report configuration wizard should identify which company is missing and re-deploy them... That works perfectly for the Excel reports, but seems to have no effect on SSRS reports...
Be aware that this table may contains thousands of entries, I even found some old entries from past GP servers v 10.0... so it never gets cleaned up when upgrading to new releases, unless you clean it out yourself. You can rely on the field [DeployedVersion] to identify which ones are current... Strangely for GP 2015R2, the [DeployedVersion] holds a version for GP 2013 (12.00.1295), which means they haven't been updated for 2015.
For SSRS, there are also 2 other tables (sySrsReports & sySrsReportDataSources) that hold information, but they contains only definitions to the reports, no company specific information.
[EDIT: corrected the erroneous ObjectType list]
I found out what went wrong... I was able to re-deploy all the SSRS reports for my TEST bed system after realizing that the one table [sySrsReports] containing all the definitions for the SSRS reports was empty (must have been cleared out accidentally by trying to fix the update issue at the time I installed GP 2015)..
This table is very IMPORTANT so never delete its content as it's the reference for the Report Deployment wizard to re-install all the SSRS reports.
Fortunately I had an older backup from the DYNAMICS database, so I recovered the content from there (otherwise you would have to run the GP setup / fix / repair to have them re-installed).
Once the table was filled again with the 353 entries it is supposed to carry, the wizard identified that my SSRS reports were missing and I could re-deploy them correctly.
Unfortunately I can't mark as 'verified' answer my own replies, so I'll leave that the community moderator :-).
Have a good day all.
Hello Béat, we're experiencing the same issue after upgrading to GP2015 R2 except the issue is for the Excel reports. We've reached the point where we cannot refresh our Dynamics database after the upgrade and running a repair on the Dynamics install didn't do the trick. Any other thoughts on what we may be able to do?
Thanks in advance,
Running a GP client repair won't probably fix the problem.. this is not a client issue, but a server side issue with the data in the report tables..
It's hard to tell without more details from your side as to know where your system is stuck.. in the worst case I'd open a support call with your partner or Microsoft to help you fix the issue (especially if it involves clearing out tables in the DYNAMICS DB).
I had this issue, however my resolution was slightly different for what it's worth. In my case, all of the records in the [sySrsReports] table were in tact. It turned out that after I made a backup of the [syDeployedReports] table and then cleared all of the records from this table. Once I re-ran the deployment everything deployed as planned.
Thanks for your insight on this issue Beat. It gave me direction when I previously had none.
After digging a little further, it was simply a server security issue. We're in a Citrix environment and the admin setting up the GP reports did not have access to the Excel reports path from the new front-end Citrix server. After granting access, the reports deployed without issue.
Regarding Béat's post: Béat Bucher responded on 16 Sep 2015 5:14 AM
I'm upgrading to a new server. After getting: "There are no reports to deploy for the selected options.", I followed your advice and deleted all records in DYNAMICS..syDeployedReports, because they were pointing to the old server. It solved my problem. I was then able to deploy the reports onto the new server. Thanks so much!!!
Business Applications communities