Reports.dic file not working after upgrade

(0) Share

Report

Posted on by Hosstyle

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

I have the same question (0)

All responses (14)

Answers (0)

twelvestrikes 3,657 on at

Like (1)

Report

RE: Reports.dic file not working after upgrade

Hi Matt

This is where patience comes in as there are a few things to try.

First and foremost is to make a backup of any reports and forms dictionaries you have in the P 2016 environment.

I would retry upgrading your reports.dic file as a first step.

Launch Dynamics utilities but make sure you right click and select Run as Administrator. Log in with the 'sa' account.

When you get to the Additional Tasks window, use the drop down and select Update Modified forms and reports and click on Process

The locate launch file window will appear, this pathing should be to the dynamics.set file that you just upgraded to, so in your case, it is the Dynamics.set file for GP 2016. You should check the set file and see where it is pointing to for the location of your reports.dic file. If the reports.dic file is not there then move it to the location or repath the dynamics.set file to the correct location.

click on next

Select the dictionaries that need to be upgraded. So for example, Microsoft Dynamics GP will have the standard AP cheque, SOP forms, Trial balances etc.

Click on the Details button

This must be pathed to the Dynamics.dic file of the version you just upgraded your databases from. If it isn't correct make sure that it is pointing to the previous version's dynamics.dic file

Click on update an the reports dictionary should upgrade.

Now, if for some reason it doesn't, let me know and I will give you something else to try.

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report

RE: Reports.dic file not working after upgrade

Yes, you are as you are trying to update the forms dictionary, not the reports dictionary. The easiest way to do this is to:

1) Open Report Writer

2) Click the Import button

3) Point to the old reports dictionary

4) Click ok to import

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Reports.dic file not working after upgrade

Hi Matt,

Were you able to resolve your problem ?

it is usually a good practice to Export all the customization from GP before starting the upgrade : Dynamics GP main menu > Tools > Customize > Customization Maintenance > Export.

Save all the custom formats (forms & reports) into either a single package, by type or by module. This way if the Dictionary upgrade fails, you can always start with a fresh dictionary and re-import the customizations.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Reports.dic file not working after upgrade

Greetings, today I had the same issue for print from the sales documents transactions after upgrade my GP version. Get into security of modified/changed reports and forms, select your Id apllied to the user, product: all products, type: windows, series: all, and seek the name of the forms with the problems, mark the option buttom empty and problem resolved. I adjunt an image from my configuration but is in spanish, how you can see, the option is unchecked. I post that because in internet i didn't found a solution for that.

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bob Harrison 823 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bob Harrison 823 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

twelvestrikes 3,657 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bob Harrison 823 on at

Like (0)

Report

RE: Reports.dic file not working after upgrade

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

Was this reply helpful? Yes No