Item number change slow

SOLVED

After upgrading to 2022 Sage 300 item number change is sunning extremely slow. Changing one item number was taking 2-3 hours in 2019 and now it would take close to 20 hours. Item valuation is taking forever, my guess is close to 18 hours. Hardware is not an issue since I am running change on 40 cores server and SQL has 60 GB memory.

Any fix for this or just moving to a newer version?

Parents
  • +1
    verified answer

    You need to stop the new Sage Advisor that is running in the background, it makes a huge difference as in 5 minutes turned into 3 hours for a simple account code change.

    You will see on your server Sage 300 advisor environment updater and that it's clogging up your server.

    Look up KB 110298  and follow it to the letter, make sure it's stopped right down to the lowest levels on the file structure.

    I have found this speeds up a lot of other things too.

  • 0 in reply to Eva Paterson

    THANK YOU!!!

    That was it , down to one hour from 20 hours.

  • 0 in reply to chiman

    I also forgot to mention

    In addition to this, one should then also set the AdvisorLogs folder in Shared data as Read-only as well.

     This normally prevents the logs from being generated, even though some background process(es) may continue to run.

    You need to go down to the deepest roots of that folder, disable all inherited permissions for all users, including Owner as well as admin.

Reply
  • 0 in reply to chiman

    I also forgot to mention

    In addition to this, one should then also set the AdvisorLogs folder in Shared data as Read-only as well.

     This normally prevents the logs from being generated, even though some background process(es) may continue to run.

    You need to go down to the deepest roots of that folder, disable all inherited permissions for all users, including Owner as well as admin.

Children
No Data