Question Status

Verified
Jon asked a question on 14 May 2014 4:31 PM

After an upgrade to GP 2013, upon the first run of the program (as Administrator) I get the following error:

From here, I can click Ok but I get nothing but a white screen. I have to close GP which strands my log in, causing me to have to delete it the next time I open GP 2013.

I have installed the same modules that were used in GP 10, and every ISV but one that is being handled by that company has been installed. I cannot import customizations as I cannot get to Customization Maintenance after I try to log in.

 

Any ideas on what dictionaries could be missing? Could it be a Windows permissions error with the Dynamics folder?

Reply
Verified Answer
Jonathan Fear responded on 15 May 2014 10:43 AM

The best thing for this error is a Dexsql.log. When the error is on the screen if you look at the log file there will be a call on the SY10800 table that looks like this:

{ CALL DYNAMICS.dbo.zDP_SY10800SS_1 ( 'DEFAULTUSER', 0, 210, 2 ) }

In this case the user I was logged in as had the DEFAULTUSER modified forms and reports ID, they were accessing a window (window is 2, report is 23) from Microsoft Dynamics GP (prodid 0), with a security id of 210. This tells me that my Dynamics.set file should be pointing to a Forms.dic file and in this case it was not.

Reply
Suggested Answer
Kirk Livermont responded on 14 May 2014 4:49 PM

Hi Jon,

Have you already upgraded the report dictionary using GP Utilities? If not this link might help you resolve this.  community.dynamics.com/.../modified-dictionary-upgrade.aspx

Regards,

Kirk

Reply
Suggested Answer
Kirk Livermont responded on 14 May 2014 5:15 PM

Make copies of the dictionaries and put them on the new server or a network share. Then update the paths in the dynamics.set file to point to the copies (step 2). From there you should be able to launch utilities and upgrade the copies.

Kirk

Reply
Suggested Answer
Tom Mathew responded on 14 May 2014 9:31 PM

Copy forms.dic and reports.dic from a working machine to the problematic one. After that run the utilities with the task as synchronize forms and reports.

If the reports and forms are not upgraded use the following link

community.dynamics.com/.../modified-dictionary-upgrade.aspx

Reply
Suggested Answer
Kirk Livermont responded on 14 May 2014 4:49 PM

Hi Jon,

Have you already upgraded the report dictionary using GP Utilities? If not this link might help you resolve this.  community.dynamics.com/.../modified-dictionary-upgrade.aspx

Regards,

Kirk

Reply
Jon responded on 14 May 2014 5:09 PM

Thank you for the link, I have a question about step #6. As GP 2013 is installed on a different server than the production GP 10.0 environment that I do not want to disrupt, how would I point the utility to the Dynamics.dic file? I tried to copy it to the new server but I got a message that this was not the valid dictionary for the forms and reports when I run utilites.

Reply
Suggested Answer
Kirk Livermont responded on 14 May 2014 5:15 PM

Make copies of the dictionaries and put them on the new server or a network share. Then update the paths in the dynamics.set file to point to the copies (step 2). From there you should be able to launch utilities and upgrade the copies.

Kirk

Reply
Kirk Livermont responded on 14 May 2014 5:17 PM

Sorry I should have more taken a little more time to re-read step 6.

I believe you are just verifying that utilities has the correct path to your copies in step 6.

Reply
Richard Wheeler responded on 14 May 2014 7:34 PM

Since this was an upgrade, are you sure you are running GP 2013 and not GP 10? Make sure you are running the correct one by going to Start->Programs->Microsoft Dynamics->GP 2013. Also, check the DYNAMICS.SET from GP 10 and compare it to the DYNAMICS.SET file of GP 2013 to make you installed and upgraded all the GP add-ins.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Suggested Answer
Tom Mathew responded on 14 May 2014 9:31 PM

Copy forms.dic and reports.dic from a working machine to the problematic one. After that run the utilities with the task as synchronize forms and reports.

If the reports and forms are not upgraded use the following link

community.dynamics.com/.../modified-dictionary-upgrade.aspx

Reply
Jon responded on 15 May 2014 5:34 AM

The Set file has all of the same GP modules installed. Is it possible that an ISV not yet installed that also includes DexToNet could be the problem? That is the only difference between GP 2013 and GP 10 that I can think of in the Dynamics.set file as the GP 10 file of course has those entries and dictionaries.

Reply
Richard Wheeler responded on 15 May 2014 6:47 AM

Can you paste in here a copy of your GP 2013 DYNAMICS.SET file?

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Jon responded on 15 May 2014 7:49 AM

24

0

Microsoft Dynamics GP

258

Project Accounting

309

Fixed Assets

949

FieldService

1042

Interfund Management

1157

Collections Management

1493

SmartList

1632

Cash Flow Management

1755

Company Archive

1838

Technical Service Tools

1878

Excel-Based Budgeting

2277

Purchase Order Enhancements

2377

AnyView

2404

Mekorma MICR

2416

Control Account Management

2547

Enhanced Commitment Management

2992

CopierSeries

3104

Advanced Security

3278

Report Scheduler

3830

SmartList Builder

4612

Advanced Go Tos

5597

HITB Report

6499

Dynamics Online Services

7156

Mekorma Products Manager

Windows

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Dynamics.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/FORMS.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/REPORTS.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/PA258.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/PAFORM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/PAREPT.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/fam.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F309.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R309.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/SrvcAdv.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/FRMS949.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/RPTS949.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/IFund.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/1042FORM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/1042RPTS.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/CPRO.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F1157.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R1157.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/EXP1493.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/EXP1493F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/EXP1493R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/CFM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CFMFORM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CFMRPTS.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/COARCHVE.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F1755.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R1755.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/TAUTIL.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F1838.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R1838.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/XLBudget.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/XL1878F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/XL1878R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/POE2277.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/POE2277F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/POE2277R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/AV2377.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/AV2377F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/AV2377R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/MICR.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/MICRFRM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/MICRRPT.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/CAM2416.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CAMFORM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CAMRPTS.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/ECM2547.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ECM2547F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ECM2547R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/QK2992.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/QDF2992.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/QKR2992.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/AdvSecur.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ADVS_FRM.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ADVS_RPT.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/RPTSCHED.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F3278.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R3278.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/SLBuild.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F3830.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R3830.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/advgoto.dic

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F4612.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R4612.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/HTB5597.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/HTBF5597.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/HTBR5597.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/DO6499.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/DO6499F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/DO6499R.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/MEP7156.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/MEP7156F.DIC

:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/MEP7156R.DIC

Reply
Richard Wheeler responded on 15 May 2014 8:04 AM

You have products from Professional Advantage and Mekorma and Accountable Software. You must have a modified form that is being reference but is not loaded. First make sure all the DIC files you see listed here are on your computer. Everything is local so they will be in your GP 2013 program folder. If you can get into GP and then go to Tools->Setup->System->Alternate Forms and Reports you could set all of your forms to be the unmodified versions one by one until you find the one that is missing.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Verified Answer
Jonathan Fear responded on 15 May 2014 10:43 AM

The best thing for this error is a Dexsql.log. When the error is on the screen if you look at the log file there will be a call on the SY10800 table that looks like this:

{ CALL DYNAMICS.dbo.zDP_SY10800SS_1 ( 'DEFAULTUSER', 0, 210, 2 ) }

In this case the user I was logged in as had the DEFAULTUSER modified forms and reports ID, they were accessing a window (window is 2, report is 23) from Microsoft Dynamics GP (prodid 0), with a security id of 210. This tells me that my Dynamics.set file should be pointing to a Forms.dic file and in this case it was not.

Reply
Jon responded on 15 May 2014 1:32 PM

Jonathan, your answer ended up being closest. DEFAULTUSER for "sa" was trying to pull windows from an ISV which was not loaded.

Reply
Jon responded on 15 May 2014 1:34 PM

Thank you everyone for your help. After loading GP with a blank security ID for "sa"  with no modified forms and reports and reimporting customizations, I think we are all good here. Strangely, other users using DEFAULTUSER on the same server are not experiencing the problems "sa" was.

Reply