You’re offline. This is a read only version of the page.
Hi All,
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.
*This post is locked for comments
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!!!
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.
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.
===============
Corey Clay
NexTec Group
===============
Hi Kyle,
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).
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,
Kyle
Ok,
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.
Bob,
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]
Hi David,
The SY40800 table contains the exact information from my deployment sites (Excel, SSRS and MR2012)... nothing wrong there.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (