Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Reports.dic file not w...
Microsoft Dynamics GP (Archived)

Reports.dic file not working after upgrade

(0) ShareShare
ReportReport
Posted on by Hosstyle 95

Hello All,

Hopefully this is dead simple and I'm just being foolish.  

We upgraded our GP2013 install to GP2016 R2.  When the users try to run their custom reports they get a message "Can't access this report because the dictionary containing it is not loaded".  I tried pointing the Dynamics.set file to the correct location and then updating the custom forms in GPutils.  I get the message in GPutils that "there are no forms present that need to be updated"  But then if I start GP, I get the message that the "reports.dic needs to be updated"   I seem to be stuck in a loop here, any thoughts?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Reports.dic file not working after upgrade

    I have seen situations were a year-end update was applied, but one was US and the other was Canadian so even though the version looks the same it is not. Standardizing using the same GP client will resolve the issue.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Reports.dic file not working after upgrade

    I like the suggestion from Richard, in fact this is how I have been doing updates for many years.  This way you always ensure that the Report.dic is the most current format - importing from the old reports.dic into the new framework has almost never failed.

    Good luck.

  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Reports.dic file not working after upgrade

    Hi Bob

    Click on apply, let the update apply.

    When you launch Dynamics Utilities, be sure to right click and select run as administrator.

    Let Dynamics utilities synchronize the workstation (or server) to the settings in the database.

    When finished, you have a choice to either exit or launch Dynamics GP.

    Choose launch Dynamics GP so that it launches.

    If at any time you are prompted to include new code, select yes.

    Once you do the above steps to both the server and workstation, You can then import the report package file.  As Beat has mentioned that you must have sole access to the reports.dic in order to import the report package.

    You should now have both server and workstation(s) on the same build of Dynamics GP and they should now be able to read your reports.dic file.

    The above suggestion is based on your original post where you mention that you made a backup of your reports.dic file and also exported the reports to a package file.

    My assumption is that you are importing the reports package into the newly updated Dynamics GP and not just placing the backed up reports.dic file into the environment for the workstation and server to read.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Reports.dic file not working after upgrade

    If I may add my two cents here, I would start by putting a working copy of REPORTS.DIC to the local GP program folder(C:\Program Files (x86)\Microsoft Dynamics\GP2016. Make sure your DYNAMICS.SET file is pointing locally.Also, make sure your DYNUTILS.SET file points locally as well. I always upgrade from the local folder and never from a network share. It would be helpful to also export your reports to a package file.Something else you could try would be to delete REPORTS.DIC and then do a fresh import of this package file. This will insure that the structure of DYNAMICS.DIC matches that of REPORTS.DIC.  Then perform your upgrade. After upgrading your reports copy your REPORTS.DIC file back to your network share. You could also try setting SYNCHRONIZE to TRUE in your DEX.INI file. It sounds like somehow you have different structures between your reports dictionary and DYNAMICS.DIC.Worst case scenario is to uninstall GP from the workstations and reinstall using the same installation package.

  • Bob Harrison Profile Picture
    Bob Harrison 807 on at
    RE: Reports.dic file not working after upgrade

    The update is a .msp file and there is no Run as Administrator option, just Apply.

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Reports.dic file not working after upgrade

    Hi Bob

    I am in agreement with what Beat said to do.

    But lets assume that your dex.ini pathing for the reports.dic file is located in the same place for the workstation and the server.

    Could you please try to install the year end update again? Make sure to right click and select Run as administrator when installing (if able to) and make sure that when you launch Dynamics GP after you have installed the year end update to use Run as Administrator.

    Then try the process again with the reports.

    If that doesn't work I have another trick you can try.

  • Bob Harrison Profile Picture
    Bob Harrison 807 on at
    RE: Reports.dic file not working after upgrade

    Béat Bucher

    I wish you were correct.

    Both installs are 16.00.0864 and the reports.dic version create either way is 16.0.864.

    No matter which one, server or workstation, is used to create the file it is created in the same location. So the SET file must be correct.

    So I can't understand where the mismatch is coming from.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Reports.dic file not working after upgrade

    Hi Bob,

    This tells me 2 things: either of your GP clients (server or workstation) are not on the same version build (18.3.1200 for  example for the GP YE update), or you're pointing your DYNAMICS.SET to different REPORTS.DIC files, but according your remark, it's not the case.

    So I'd bet on the first issue.

    One thing that is critical.. When importing a .package file of saved REPORTS or FORMS, you need to have an exclusive access to the shared dictionaries, or your import will simply not work.

    if all the DYNAMICS.SET launch files share the same location for the core GP module (0), then it should work, unless the clients are on different versions.

    //yourserver/GPShare/Data/REPORTS.DIC

    //yourserver/GPShare/Data/FORMS.DIC

    as an example.

    The Dex.ini does normally not play any role in this customizations.

  • Bob Harrison Profile Picture
    Bob Harrison 807 on at
    RE: Reports.dic file not working after upgrade

    Maybe someone can explain what is happening. We export the modified reports to a package file and rename the reports.dic. We then upgrade the server and workstations.

    If we import the modified reports from a workstation, all of the workstations work, but the server says reports.dic needs to be upgraded. If we import on the server, the server works, but all workstations say the fie need to be upgraded.

    The reports.dic is on a network share and both the SET file and dex.ini point to the file. We compared the reports files that were created and the permissions are identical.

    Why do the server and workstations think they are on different versions?

    This was after the 2020 year-end update for GP2016. 

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Reports.dic file not working after upgrade

    Hi Jose,

    with your solution, you're nor solving the actual problem :-).. you just swept it under the carpet..  

    If the system is looking for a modified report, because the security was set so, then there is probably a good reason behind it.. Defaulting the security back to the regular report might get you rid of the error message, but not solve the problem.

    There is a process to follow when upgrading from GP version to a newer one and carry up the modified Forms & Reports, so they would still work with the version.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans