Sage 100

 View Only

  • 1.  Error 33 during Purge Completed Purchase Orders utility

    Posted 08-09-2024 18:17
      |   view attached

    I'm running the above utility.  Currently there are ~28k purchase orders in the open PO file that it is chugging through.  The utility was running for about 2.5 hours and then the following error occurred:  "Insufficient system memory available".  From there I clicked the Info button.  That's when it broke out to code and all that I can see is "Error 33" which in the providex manual says that "The operating system has denied a request for additional memory. Either the amount of memory being requested exceeds system capacity or the memory is in use."

    I am right now sitting at broken out to code (like you see in the screenshot I have attached).  Customer is on version 2022 PU3 premium.  Thanks in advance to anyone that can help.  



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------


  • 2.  RE: Error 33 during Purge Completed Purchase Orders utility

    Posted 08-09-2024 19:25

    Hi Jane,  I have run into similar cases like this.  Appears that the routine maxed out the memory on the system (bad comparison but like when you try to load Physical Count when there are a ton of items).    Since this is a purge routine, I would just close out and restart it.  You can check to see if the count of POs in history has changed (most likely has).    Start up the routine again and there will be less records for it to go through.  Might take more than one pass to get rid of all of them.     Another thought - as they are on premium, you could remove the history from the SQL tables directly if you are game for doing that.   One of the pluses of being on premium..



    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------



  • 3.  RE: Error 33 during Purge Completed Purchase Orders utility

    Posted 08-09-2024 20:09

    Thanks @Robert Osborn!  I got out of the error and have restarted the utility.  Before I restarted it there were ~20k purchase orders already deleted, so I'm sure this will complete on this second attempt.

    This can be moved out of urgent support.



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------

    Original Message


  • 4.  RE: Error 33 during Purge Completed Purchase Orders utility

    Posted 08-10-2024 09:25

    Update: I restarted the utility, and it completed, but no more records were deleted. When the error occurred on my first run attempt, it must have been done running through records, it just couldn't exit out of the program gracefully. 



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------

    Original Message


Related Content