Open Forum

Expand all | Collapse all

A Get/Change First Operation on Table coProcess failed Accessing SQL Data

  • 1.  A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    GOLD CONTRIBUTOR
    Posted Feb 22, 2019 05:27 PM
    Hi, all. I have a company that users have been able to log into for ages without issue but just today, several users started getting the error, "A Get/Change First Operation on Table coProcess failed Accessing SQL Data" when attempting to log into this company. Nothing has changed in the environment that I'm aware of and only a few users appear to be impacted. I've attempted a few things to fix the problem to no avail...

    I tried the instructions at this link... A Get/Change First Operation on Table coProcess failed Accessing SQL Data error message when you log into Microsoft Dynamics GP after moving from one server to another - Microsoft Dynamics GP Community
    Dynamics remove preview
    A Get/Change First Operation on Table coProcess failed Accessing SQL Data error message when you log into Microsoft Dynamics GP after moving from one server to another - Microsoft Dynamics GP Community
    <g class="gr_ gr_458 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" id="458" data-gr-id="458">Issue :</g> A Get/Change First Operation on Table coProcess failed Accessing SQL Data" error message when...
    View this on Dynamics >


    and I've tried resetting the user's passwords which I also found should fix the problem. I'm not sure what else could be causing the issue. If anyone has any info on how to correct these errors, it would be greatly appreciated.





    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    GPUG ALL STAR
    Posted Feb 22, 2019 07:09 PM
    Hi @Jon Godwin,
    Are you 100% positive that nothing has changed in your environment ?  How do those users that are impacted access the GP client ? local setup or remote Citrix / TS server ? The link you provided was addressing a very specific case of the a GP environment that was moved to a new SQL server.. which doesn't seem to be your case.
    Something you could try on the GP client where the users are getting this problem to try to get more infos about the issue, though I'm not convinced it's going to provide much data, is to enable the SQL DEX tracing flag in the DEX.ini file :
    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
    SQLLogAllODBCMessages=FALSE

    Set the value to 'TRUE' for all the 3 entries above in the DEX.ini and start the GP client.

    Microsoft KB article states pretty much the same thing as the link you follow, but telling that the issue is most likely related to the ODBC connexion name of the SQL server (thus my question about how the users access GP) : https://support.microsoft.com/en-us/help/850997/you-receive-the-a-get-change-first-operation-on-table-coprocess-failed



    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    GOLD CONTRIBUTOR
    Posted Feb 25, 2019 03:34 PM
    Hey, Beat. Thanks for the feedback. We're running in a TS environment. I'm a <g class="gr_ gr_99 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="99" data-gr-id="99">poweruser</g> and am able to log in just fine but any users without those permissions are getting the errors above. Nothing should have changed regarding ODBC connections and they use the same server, etc. to access other companies that are working fine.

    ------------------------------
    Jon Godwin
    Database Administrator
    Boulder CO
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    GPUG ALL STAR
    Posted Feb 25, 2019 07:30 PM
    Thanks @Jon Godwin
    For what it's worth, could you try to run the SQL script about setting up GP TEST companies.. ?
    Can you go down the check list and make sure all the settings are correct for this company DB ?
    https://support.microsoft.com/en-us/help/871973/set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microso

    ​I'm having the feeling something is corrupt with regards to the user security on this company DB.
    As another hint, you could install a trial of GPPT and run the Database Validation against this company to check of inconsistencies within the user DB setup.
    https://www.winthropdc.com/products_GPPT.htm

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    GPUG ALL STAR
    Posted Feb 26, 2019 11:12 AM
    You might also want to revisit the Windows Updates section and see if any "helpful" updates were pushed to your server.  I know those have caused me headaches in the past and uninstalling the updates got me right back on my feet.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: A Get/Change First Operation on Table coProcess failed Accessing SQL Data

    Posted 15 days ago
    Hi Jon,

    When the user receives that error, there is usually a "More Info" button on the error window. When you click that, what error message displays? It is usually the information on that 2nd screen that will point me in the right direction.

    Regards,

    Paula Spinweber

    ------------------------------
    Paula Spinweber
    Supervisor, ERP Operations
    SBA Communications
    Boca Raton FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role