Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2015R2 SSRS reports...
Microsoft Dynamics GP (Archived)

GP 2015R2 SSRS reports not able to re-deploy in native mode

(0) ShareShare
ReportReport
Posted on by Beat Bucher GP Gee... 28,058 Moderator

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.

Image-2015_2D00_09_2D00_15_5F00_103149.png

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

  • Suggested answer
    JackD Profile Picture
    JackD 20 on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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!!!

  • kmalone43 Profile Picture
    kmalone43 894 on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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.

  • CSC2100 Profile Picture
    CSC2100 10 on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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

    ===============

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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).

  • kmalone43 Profile Picture
    kmalone43 894 on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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.

    Image-2015_2D00_09_2D00_16_5F00_085558.png

    Unfortunately I can't mark as 'verified' answer my own replies, so I'll leave that the community moderator :-).

    Have a good day all.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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]

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    Hi David,

    The SY40800 table contains the exact information from my deployment sites (Excel, SSRS and MR2012)... nothing wrong there.

  • Bob Callanan Profile Picture
    Bob Callanan 789 on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    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

  • davidf. Profile Picture
    davidf. on at
    RE: GP 2015R2 SSRS reports not able to re-deploy in native mode

    What's in your SY40800 Reporting Tools Setup file? Have you tried clearing that?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans