web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

(0) ShareShare
ReportReport
Posted on by 3,561

We have recently upgrade from Dynamics GP 2010 to Dynamics GP 18.3

Part of the process is to run a Macro to Transfer each Line fof a Sales Order from Back Order to Order.

Due to the effort to confirm each Line availability, the BO lines being transferred to Order need to be sent to BO if  ot available, hence the reason to run a Macro to do the manual task.

There may hundreds of lines of Items on each BO, and insome cases over 1000 Lines.

After the upgrade we started to noticed that Dynamics GP would crash and close randomly before completing the Transfer to Order, and thereby losing the Data.

The Event log shows an outofmemory condition and we started to investigate the cause.

We have discoverd that the Dynamics GP Application on each machine keeps increasing in Memory when the Sales Order Transfer is occurring, and even when an Order Transfer is Completed the memory still shows high and doesn't drop until logged out of the Application.

We suspect that Dynamics GP is a 32 Bit Application and only uses up to  the 4GB of Memory, and that other 32 Bit Aplications are using the same area of memory, and when that memory Limit is reached the OutOfMemory condition occurs and Dynamics GP Crashes.

As this condition didn't occur in Dynamics GP 2010, we suspect changes over versions has allowed the memory to increase and not allow it to be recovered to the machine.

Any assistance in this area would be appreciated as many Sales Orders are being affected and the requirement to keep rebuilding the Back Orders after the crash is not good for the Customer.

I was able to replicate the issue by creating a 6000 Line Back Order and using a macro on my local computer and sql server.

Thanks,

Mick

Categories:
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

    I suspect you're running into a similar issue that we've seen with Integration Manager which also uses macros for its 'Standard' adapter, when trying to push through a larger volume of data, such as the 6000 line back order you mentioned.

    You're correct in that Dynamics GP is a 32-bit, single thread application and that hasn't changed between Dynamics GP 2010 and Dynamics GP 18.3.

    It's tough to really compare a GP 2010 to GP 18.3 environment as not only are we changing Dynamics GP versions but most likely also Windows OS and SQL Server versions, and in all three cases, newer doesn't necessarily mean faster, in fact, it can mean just the opposite with each adding new features in each version.

    When we see this issue, it pretty much comes down to finding that threshold of, in this case, the maximum number of lines for the sales order from back order to order, that you can push through via this macro you have, before reaching the OutOfMemory condition, then instead of running 1 integration of XXXXX lines or records, run multiple integrations of lesser lines or records to get them to go through.

    There may be more suggestions from the Community as well, so we'll see if others have run into a similar issue and what they've done.

    Thank you,

  • Mick Egan Profile Picture
    3,561 on at
    RE: Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

    Derek,

    Thanks for you thoughts, we have taken the approach to limit the number of records in each Macro, but it means having to restart the Desktop Dynamics GP Application each time as it doesn't give back the memory after each run, and just continues to grow the memory.

    If the memory was released then that would make a difference.

    Thanks,

    Mick

  • Verified answer
    Derek Albaugh Profile Picture
    on at
    RE: Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

    My thoughts are that it is the same type of issue we see with Integration Manager when using the 'standard' adapter, which is basically a macro that does the same steps a user would do if in the Dynamics GP application entering this data.

    The only other option I can mention is to see if eConnect is something you could look at using.  eConnect uses the stored procedures that already exist in the GP databases and can be run outside of Dynamics GP so it's basically just SQL Server/GP databases in the mix.

    I know that there are no plans for making changes to Integration Manager and along those same lines, macros, which are technically considered a 'customization' of Dynamics GP.

    Hopefully the forum community can provide some additional suggestions that they've maybe used with this type of issue.

    Thanks

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

    Hi Mick,

    Another comment related to IM using the GP front-end, is to switch from the new "Toolbar" ribbon to the classic GP menu in the user preferences.. Many users reported having issues when running IM in combination of the ribbon in GP.

    As Derek suggested, if possible (depending on the type of integration) try to switch to the eConnect connector in IM, this would take GP out of the equation..

    Unfortunately eConnect connector doesn't support the full range of integrations that the regular GP connector does..

  • Mick Egan Profile Picture
    3,561 on at
    RE: Dynamics GP 18.3.1173(2020) Crashing OutOfMemory

    Derek,

    Thanks for the advice.

    It was actually a lot more complicated than just using eConnect.

    We needed to consider the following before allowing the Back Order transfer to Order, as we don't want the Sales Order Import process finding issues and having to resolve them at that point of time.  We use Smartconnect, so it makes life a lot simplier to manage the process, We created an Import Table so we could do all the checking before allowing the Order to be created, plus we can send emails when a known issue occurs, some problems we encountered:

    1. Customer is On Hold / Inactive

    2. Customer Credit Limt is reached

    3. The Total of all outstanding Back Orders and the Customer Balance exceeds the Credit Limit, they want to be able to pick which Back Orders can be processed.

    4. An Item on a Back Order had it's "Allow Back Orders" unmarked, and the Item was placed as Discontinued, we need to allow it to proceed and let it be fixed later, and notify the User.

    5. Need to move the Back Order to History after the Order is created.

    6. Need to remove the Back Order from the SOP Work Tables.

    7. The Master Number cannot be duplicated when importing through eConnect, so need to update this after the Order is created.

    8. Send a confirmation Email with the Multiple Back Orders created, so we need to have the Import sort by Customer / Back Order, so the Order is created in a Customer Sequence, so when printing the Picking Lists through the SOP Documents Printing, they can bulk print the Customer by the Order Numbers, without having another Customer is that sequence.

    This process seems to work well, an excel template was created so the User only needs to place the file in the shared directory and the Integration automatically runs so there is no User Interface, they only receive email notifications about the errors, or the New Order Numbers.

    Regards,

    Mick

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,933

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 793 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 537 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans