x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 1424 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
Kayleigh Creser

Sales Order List Timeout Error

SUGGESTED
Posted By

One of our companies has a huge amount of data and since upgrading from Sage 200 (2011) to Sage 200C (2018), the Sales Order list has been timing out, as it takes too long to bring back the data. I temporarily fixed this issue by archiving a large amount of data, but that is a very time consuming, manual process which does mean a lot of people have to stop working while this is happening. And besides that, it worked fine on the old Sage so I don't see why this should have to keep being done in order to get it working.

We have installed the new Sage on a completely new server, with RDS access, as it should be and that is the only difference between the 2 versions.

Has anyone else has this issue and resolved it?

  • 0
    SUGGESTED

    Well when the system was refreshed, i think they did something with the paging (which is how much of the list is held in memory) - probably for the filter option.  This is probably why when there are really large lists it falls over a bit more.  I have a customer who has hundreds of orders a day and had this issue and the only way was to archive old orders.  They did about 7 years in chunks.  They probably should have been doing this anyway as thats what the system is designed to do - archive old data to keep your list shorter and more relevant. Though this is probably still a bug.

    They also use filters to show current month or week or open - something like that, but they'll probably have to archive some more data at year end.  You could ask your Business Partner to raise a case with Sage regarding it being an issue - as its better potential performance bugs being reported direct to the support team.  Having a look on the bugbase, there are a couple of issues logged

    7889 - 200c - Performance issues with SOP List View - shows as fixed in Winter 2018

    7043 - Sorting list views by column crashes Sage 200 when dealing with large datasets. - shows as outstanding

    I would recommend speaking to your business partner who will be able to liaise with Sage and escalate it for you.

  • 0 in reply to Gary Butler_1

    Thanks Gary, appreciate your reply. I have spoken to our Business Partner and just waiting for them to get back to me. I guess I was hoping someone on here had a miracle cure!

  • 0 in reply to Kayleigh Creser

    No worries, the archiving and filters will help, unfortunately it'll need a change in program code to fixSlight smile

*Community Hub is the new name for Sage City