Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error registering tabl...
Microsoft Dynamics GP (Archived)

Error registering table GL_Account_MSTR after GP 10.0 SP5

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have two terminal server environments.  One on WIN Server 2003 and one on WIN Server 2008 R2.  One is load of GP UK English and one is US English.  Both have a separate Reports.dic.  I ran the new GP 10.0 SP5 and the Reports.dic seemed to upgrade fine on the UK English install but the US Install is giving me the following errors when running some reports more specifically the GL Detail and Summary TB:  "Error registering table GL_Account_MSTR" and when you click "Ok" it says "Table Open Error" and won't print the report. 

I researched a number of threads online and have tried the following fixes: 1) Creating a new Reports.dic and exporting the reports and importing them back in which resulted in a few reports coming up with the error of "Key: Unable to set property Table to GL_Account_MSTR".  We need these modified reports so I am hoping to alleviate the error.  I didn't find any other info online that looked ultra pertinent to this issue.  I am getting the same error after posting RM finance charge waiving but that is likely due to the modified reports printing after the posting. 

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Ryan,

    Try starting the software with 'run as administrator'.

    Kind regards,

    Leslie

    PS you can delete all of those winspool lines. If you get ahold of the Support Debugging Tool you can keep your .ini file clean.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Hi Ryan, I don't see anything wrong with your dex.ini file. You could delete the winspool entries just to tidy it up a bit, but they are no big issue and certainly shouldn't b the cause of your issues.

    Have you tried printing the reports at another machine? Can you successfully launch Utilities at another machine?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    [General]

    Initial=FALSE

    Synchronize=FALSE

    AutoDisplayUpdate=TRUE

    AllowBCPTest=FALSE

    DynHelpPath=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\

    DexHelpPath=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\

    Word Macro File=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\Letters\WordIntegration.dot

    Letters Directory=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\Letters\

    Workstation=WINDOWS

    Workstation2=Windows

    WindowMax=TRUE

    BTInterface=NoLoad

    Pathname=DYNAMICS/dbo/

    FileHandler=SQL

    SQLQueryTimeout=0

    SQLProcsTimeout=0

    DPSInstance=1

    NoPrintDialogs=FALSE

    BuildSQLMessages=FALSE

    OLEPath=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\Notes\

    ReportDictionaryPath=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\

    FormDictionaryPath=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\

    UpdateLogin=https://mbsupdates.microsoft.com/taxupdate/login.aspx

    SQLLogSQLStmt=FALSE

    SQLLogODBCMessages=FALSE

    SQLLogAllODBCMessages=FALSE

    SQLRprtsTimeout=0

    ReportViewMode=0

    NextEntryID=27159

    NextGroupID=10281

    DYNOLD258=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Version10.0.836.0Backup\PA258.DIC

    DYNOLD0=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Version10.0.836.0Backup\Dynamics.dic

    DYNOLD949=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Version10.0.836.0Backup\SrvcAdv.DIC

    DYNOLD309=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Version10.0.836.0Backup\fam.dic

    LastYearEndUpdate=11/14/2008

    LastTaxCodeUpdate=06/22/2009

    Dictionary Version=10.00.1579

    SQLLastDataSource=Dynamics32bit

    SQLLastUser=curtiscarman

    ZoomFontUnderline=True

    ZoomFontColor=Blue

    MagnifyScreenOutput=125

    DYNOLD=C:\Program Files (x86)\Microsoft Dynamics\GP$GP 10.0 US\Data\Dynamics.000

    ReportLayout=162,23,800,668

    LayoutToolbox=1,1,156,382

    RWLayoutPropertiesSheetTab=1

    RWLayoutPropertiesSheet=964,33,270,349

    RWLayoutPropertiesSheetVisible=TRUE

    IMPath=C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 10\Microsoft.Dynamics.GP.IntegrationManager.exe

    IMExecPath=C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 10\Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe

    TS009winspool=0;0

    NoteWindow=276,-13,332,357

    TS030winspool=0;0

    WindowPosX=177

    WindowPosY=436

    WindowWidth=640

    WindowHeight=480

    TS007winspool=0;0

    TS081winspool=0;0

    TS077winspool=0;0

    TS022winspool=0;0

    TS002winspool=0;0

    TS092winspool=0;0

    TS001winspool=0;0

    TS016winspool=0;0

    CPW2:winspool=0;0

    IP_172.17.9.212winspool=0;0

    TS066winspool=0;0

    TS017winspool=0;0

    TS011winspool=0;0

    TS024winspool=0;0

    TS065winspool=0;0

    TS021winspool=0;0

    TS019winspool=0;0

    TS072winspool=0;0

    TS010winspool=0;0

    XPSPort:winspool=0;0

    TS064winspool=0;0

    TS084winspool=0;0

    TS083winspool=0;0

    TS006winspool=0;0

    TS071winspool=0;0

    TS087winspool=0;0

    TS027winspool=0;0

    TS090winspool=0;0

    TS086winspool=0;0

    TS026winspool=0;0

    TS094winspool=0;0

    TS138winspool=0;0

    CheckWordLength=115

    IP_172.17.17.138winspool=0;0

    TS005winspool=0;0

    IP_172.17.17.136winspool=0;0

    TS008winspool=0;0

    TS082winspool=0;0

    TS128winspool=0;0

    TS028winspool=0;0

    TS134winspool=0;0

    TS076winspool=0;0

    TS025winspool=0;0

    TS013winspool=0;0

    TS020winspool=0;0

    TS012winspool=0;0

    TS080winspool=0;0

    TS095winspool=0;0

    TS068winspool=0;0

    TS069winspool=0;0

    TS067winspool=0;0

    TS074winspool=0;0

    TS014winspool=0;0

    TS029winspool=0;0

    TS018winspool=0;0

    TS073winspool=0;0

    TS015winspool=0;0

    TS003winspool=0;0

    TS078winspool=0;0

    TS085winspool=0;0

    TS129winspool=0;0

    TS070winspool=0;0

    TS031winspool=0;0

    NoPrintDialogs=TRUE

    TS093winspool=0;0

    TS133winspool=0;0

    TS150winspool=0;0

    TS136winspool=0;0

    TS023winspool=0;0

    TS079winspool=0;0

    TS089winspool=0;0

    My Documents\*.pdfwinspool=0;0

    TS088winspool=0;0

    TS137winspool=0;0

    TS075winspool=0;0

    TS143winspool=0;0

    TS148winspool=0;0

    TS091winspool=0;0

    TS004winspool=0;0

    TS135winspool=0;0

    TS139winspool=0;0

    TS192winspool=0;0

    TS140winspool=0;0

    ST_MachineID=S-TERM4-SLC-SVO

    ST_SetDefault=TRUE

    TS132winspool=0;0

    TS147winspool=0;0

    TS152winspool=0;0

    TS145winspool=0;0

    Documents\*.pdfwinspool=0;0

    USB001winspool=0;0

    TS155winspool=0;0

    TS210winspool=0;0

    TS144winspool=0;0

    TS213winspool=0;0
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Can you post the contents of the dex.ini or PM me and you can then email it.

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Yes - that was one of the BCP error fixes that was in the document.  Plus I don't see why the ODBC has anything to do with the error because we have been using this install of GP 10 for about a year with no issues.  I haven't changed ODBC settings since that time.  I still think the dex.ini is possibly referencing a wrong path or has an entry from the one I copied that is not condusive to the one I am having issues with. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Hi Ryan,

    Did you verify your ODBC? SQL Native Client...and no tick boxes ticked on any of the set up windows?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    * Yes I changed Synchronize = TRUE then launched Utilities.

    * I get the BCP message right when I launch Utilities and it doesn't seem to get to the Sync part. 

    * I had to turn the Sync = FALSE so I can have users login and do work today.  It won't let them get into GP if I leave it at TRUE.

    * The following is the BCP error:

    An error occurred while using the BCP utility - data was no correctly copied to the server.  Please verify your ODBC settings and that BCP has been correctly installed.  GP Utilities will now exit.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Hi Ryan,

    • Is this what you did? Changed the Synchronise to be TRUE in the dex.ini file, then launched Utilities?
    • Did you get a message that GP was Synchronising...before Utilities atarted its BCP complaining?
    • When do you get the BCP error messages? - on launch of Utilities, or when its synchronising or etc..?
    • Look at the Dex.ini file now - is Synchronise = TRUE or FALSE?
    • Can you now print your reports without getting an error?
    • If Synchronise in Dex.ini is still = TRUE, change it back to FALSE and try launching Utilities - do you still get BCP errors?
    • Can you post some of the BCP errors to give us an idea what is happeneing.

    Leslie...any ideas?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Leslie and Ian,

     Thanks for your help.  I tried synchronizing and now I am getting BCP errors when I try to launch GP Utilities.  I went through a number of the fixes on the BCP KB article but it doesn't seem to be helping.  In general can you explain why you think I am getting the original error?

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Error registering table GL_Account_MSTR after GP 10.0 SP5

    Hi all,

    Ian is straight on correct. You probably copied the .ini file from a workstation that had already been synchronized. Each workstation needs to go through this process in order to synch up the dictionary with your account format.

    Kind regards,

    Leslie

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans