Open Forum

Expand all | Collapse all

Purchasing Module - Slow Performance/Freezes/Errors

  • 1.  Purchasing Module - Slow Performance/Freezes/Errors

    Posted 14 days ago
    Hello,
    We connect to GP via Remote App.

    Over the past couple of months, whenever we are going through the process of posting batches, building batches, printing checks and running EFTs,and when it comes to reports for each step, it is taking an extremely long time to process.  Also, there are times when we are in the middle of a process that we receive errors or GP freezes completely.  At times, this results in voiding of checks because of the freeze, etc.

    Is anyone else experiencing this and if so, have you found a solution.

    Please HELP!

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ShelleyAccounts Payable Manager
    ------------------------------


  • 2.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 13 days ago
    Hi Shelley,
    This is very hard to diagnose on the simple statement that you use GP thru RDP.. You don't say much about the rest of the setup (network, number of RDP users, server infrastructure, etc.).
    There are so many factors that can play into the game, that this is very difficult to help in detail. We could only provide some general guidance without knowing more in depth.
    How long have you been using GP (amount of data accumulated) ? How many users are accessing the system simultaneously. ? What other processes might be running at the same time when batches are posted ?
    I've another client that encounters similar issues with their TS / RDP setup, and there are only about 4-5 GP users at max. But posting a batch may result in GP freezing and/or the session closing on the users.. Though we haven't found out yet the true problem, I suspect network performances, as they do access RDP into the GP application over a WAN connection, which could be a problem when it comes to print reports, as RDP by default links the local printer queues with the TS application server.

    ------------------------------
    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
    ------------------------------



  • 3.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 13 days ago
    Thank you!  These are some great questions, and I'm going to send this to the appropriate person and see what I can find out.  There are only 3 of us that are utilizing the purchasing module.  Accounting does not seem to be experiencing as many issues within the Financial module, so that much we have pinned down.  We just upgraded last November from 2012 I believe to 2018. I just started using GP this past January and it was running better, but within the last two months, it is just horrible.  It is totally affecting our flow in the AP department.  I will be in touch.

    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 4.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    SILVER CONTRIBUTOR
    Posted 13 days ago
    ​Shelley,

    Are you using Mekorma's MICR ?

    OUr company just performed an upgrade of GP to 2016 R2 and we had been using Mekorma's Micr for printing checks. We had no freezing problems when on GP 2010 R2 but when we upgraded to 2016, that is when the horrors began.

    After uninstalling all my 3rd party apps and working in GP and adding the 3rd party apps one at a time, I found that Mekroma was the culprit. After installing Mekorma, things began to slow down and freeze quickly.

    After calling Mekorma, they told me this was a known issue with their Multi Batch Processing which we do not use however it is installed when using Mekorma Micr. Apparently the Multi Batch processing logs every transaction to a SQL table that originates in the AP module thus causing users in AP to feel the performance degradation and not any other module in GP.

    I was instructed to create a SQL job to delete the Multi Batch processing log table and schedule it to run every so many minutes as to not cause the freeze. the tables and SQL commands are below:

    Truncate table MPP71508;
    Truncate table MPP71509

    Hope this helps!! Keep us informed! I'm curious to know if this helps.

    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------



  • 5.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 13 days ago
    Hi Curtis,
    Yes, we are.

    This is very helpful, I will pass this along.

    Is GP running back to normal now?

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 6.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    SILVER CONTRIBUTOR
    Posted 13 days ago
    ​Hi Shelley,

    Yes, after creating SQL job and scheduling it to delete the tables I mentioned every few minutes, the AP department immediately saw a huge difference. We have over 25 AP reps and 69 GP users so you can imagine how quickly the log tables I sent you fill up.

    I would even run the statements I sent you now to truncate (delete) the records from these log tables and test this out.

    I think you will be pleasantly surprised.


    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------



  • 7.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    SILVER CONTRIBUTOR
    Posted 13 days ago
    ​One last thing, If you need to confirm or have Mekroma walk you through this, call and ask for Krista.
    She is the only one that was able to assist with this as no other Mekorma support rep new the issue.

    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------



  • 8.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 10 days ago
    Edited by Mariano Gomez 10 days ago
    Hi @Curtis Cruz, @Shelley Kirk, and @Beat Bucher​​​​​, please go to our website and download the latest build for your corresponding version of Dynamics GP. This build addresses the MPP table issues and also optimizes the login process as it relates to our software. Please let me know if you are still running into any issues after applying this build.

    Also, please note than EZ Print is not supported in terminal services environments. You can disable EZ Print in Terminal Server by editing the corresponding group policy (gpedit.msc):

    Computer Configuration\Administrative Templates\Windows Components\Terminal Services\Terminal Server\Printer Redirection

    ------------------------------
    Mariano Gomez, MVP, Dynamics Credentialed Professional
    Director of Technology Services
    Mekorma
    ROSWELL GA
    ------------------------------



  • 9.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    SILVER CONTRIBUTOR
    Posted 10 days ago
    ​Mariano,

    Thank you so much!
    I will install this in our test environment and test.

    I appreciate you following up with us on this!!


    ------------------------------
    Curtis Cruz
    Database Administrator
    Apex Healthcare Partners LLC
    Montebello NY
    ------------------------------



  • 10.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 10 days ago
    My pleasure! We take performance issues seriously an work to address these as reported by customers and, of course, if we find them to be an issue with our software. Please let me know how it goes.

    ------------------------------
    Mariano Gomez, MVP, Dynamics Credentialed Professional
    Manager of Product Development
    Mekorma
    ROSWELL GA
    ------------------------------



  • 11.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 10 days ago
    Thank you!

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 12.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 13 days ago
    I can concur with @Curtis Cruz on this one.. I too noticed issues after upgrades of the Mekorma products.
    Annoyingly, the older releases of Mekorma would allow you to select which product you wanted to install in GP.. more recently, however they changed the setup application and now it's an all-or-nothing installation, which means you don't have a choice and need all the modules along with Mekorma (4 or 5), even if you don't use them.
    I even recently noticed GP logon / logoff slowdowns with the most recent builds, but was told that Mekorma was aware of that and worked on fixes. That was about 1-2 months back. ​The slowdowns would completely disappear when Mekorma products would be removed from the client.

    ------------------------------
    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
    ------------------------------



  • 13.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 10 days ago
    Hi Curtis,

    So far, what you shared, has fixed our issues!  We are stoked.  I will definitely keep you posted if it changes, but this changed everything!

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 14.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 10 days ago
    Shelly, please see my observations above to you and Curtis.

    ------------------------------
    Mariano Gomez, MVP, Dynamics Credentialed Professional
    Manager of Product Development
    Mekorma
    ROSWELL GA
    ------------------------------



  • 15.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi @Shelley Kirk

    This could be the result of many, many things.

    It could  be and is likely ​the configuration of your Remote App environment and how it is "talking" to the SQL server.  It could be how the remote app was deployed, your internet/network connection etc.

    Do you have any further details on your environment you could share?

    Additionally, you mention the last couple of months... did anything change in your GP environment a couple of months ago?

    ------------------------------
    Jo deRuiter, MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    770-906-4504 (Cell)

    ------------------------------



  • 16.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 7 days ago
    Hi Jo,

    The only change that occurred within the last couple of months was our servers going down, completely, companywide.

    This has been resolved and fixed, but GP was not.  We are back to running like we were before this time.

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 17.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 10 days ago
    Hi Shelly,
    What version and build are you on?  GP2018 or GP2018 R2 for example.

    Thank you,
    Susan​

    ------------------------------
    Susan Gamache
    GraVoc
    Peabody MA
    ------------------------------



  • 18.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 10 days ago
    GP 2018.

    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 19.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 9 days ago
    In addition now, entering invoices in the Payables Transaction Entry screen is extremely lagging and slow, any ideas tips etc?  HELP!  My department can hardly function.

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 20.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 9 days ago
    Shelley,
    This no longer sounds like a Mekorma issue. In your initial post you mentioned GP freezing and errors, but I did not see a screenshot or reference of the errors you mentioned. Typically, prior to fixing the performance issue we had, you'd simple experience delay, but this would not lead errors. Our processes would still complete. It sounds to me you are running into something else, assuming you have already updated your Mekorma software to the latest build as I instructed in my previous reply.

    The question to you is, what changed in your environment *on or before* you started getting these errors? Did you apply a Windows Update, did you upgrade GP to version 2018? If so, what version did you upgrade from? If you did perform an upgrade, was your server capacity revisited? Feel free to reach out to me directly at mariano@mekorma.com

    ------------------------------
    Mariano Gomez, MVP, Dynamics Credentialed Professional
    Manager of Product Development
    Mekorma
    ROSWELL GA
    ------------------------------



  • 21.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 9 days ago
    Edited by Susan Gamache 9 days ago
    ​Hi Shelly,
    There is a known performance issue in the purchasing module in GP2018 RTM that is resolved in GP2018R2. I just bumped into it for a customer last week. Updating to GP2018 R2 resolves it.

    Here's a reference to the fix:
    https://community.dynamics.com/gp/f/32/t/277512

    It may be worth taking a look at updating if you are not already on the latest release.

    Susan

    ------------------------------
    Susan Gamache
    GraVoc
    Peabody MA
    ------------------------------



  • 22.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    SILVER CONTRIBUTOR
    Posted 9 days ago

    Hi Shelley,

     

    Yes, if you did not update the Mekorma software as Mariano suggested,  and you instead followed my steps to delete the MPP tables in the DYNAMICS database, is this delete (Truncate) on a scheduled job to delete records from this table often.

     

    I have schedule set to Truncate data every 1 minute, not sure if you're doing the same.

     

     


    Curtis Cruz
    MS Dynamics GP Administrator

    400 Rella Boulevard, Suite 170
    Montebello, NY 10901
    Office: 845-915-9240
    Mobile:
    631-766-7758

     





  • 23.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    Posted 7 days ago
    Hi Mariano,

    We discovered another user running reports, and after those reports were complete, the performance was back to normal.

    Thank you,
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------



  • 24.  RE: Purchasing Module - Slow Performance/Freezes/Errors

    GPUG ALL STAR
    Posted 2 days ago

    Hi Shelley

    Sounds like you have just found an excuse to upgrade your server hardware. :)

    Regards

    David



    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



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