Announcement

Collapse
No announcement yet.

Act 2007 Hanging

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Act 2007 Hanging

    Hi, posting here in the hope that we can resolve this one, tried the actual act forums and not got too much success solving an issue where Act stops responding.


    We have ACT by Sage 2007 (9.0) Version 9.0.1.162, Hotfix 1, English (United Kingdom) and also Sage Line 50 Accounts version 12.01.0034. We have recently had an issue where the users’ search windows hang or pause for around 10 to 15 seconds or so. The Act windows do not completely clear, as if the PCs CPU is running at 100%, which it isn’t, and the next window with the customers information on it does not draw or fill with details clearly until this delay has passed. Once at this point, there is much less slowness using Act and Sage together to create orders or invoices.

    We run the Act SQL server on an IBM Eserver with a 3Ghz Xeon CPU running Windows 2000 Server SP4 with about 2GB of RAM, and it has proved perfectly adequate as there are only 5 users and about 13,000 records in the database. It links to Sage Line 50, based on another shared drive on the same server, with the ‘Accounting Program’ tab in the Act record, from which the users create new records and orders. This system has been running perfectly quickly, with almost instantaneous responses for about 2 years.

    This happens on every search but is worst on a post code search, which is unfortunately the users’ initial process. The users first response to an incoming telephone call is to look up the customer on the database by post code, and this has started to impact the usefulness of Act in that the users have to tell the customer to wait until the system 'catches up', and brings up the customers details. This can take from a few seconds to more than 20 and has become a major issue.

    We recently had a problem where Act was crashing a few times a day on every PC, after some Windows Updates were installed, but when a procedure outlined on this forum was followed, uninstalling Dot Net 2, 3, and 3.5, then reinstalling only Dot Net 2 from the Act CD, this problem was resolved. However, the slowness and window hanging has continued to adversely affect the users.

    Any assistance much appreciated….

  • #2
    Re: Act 2007 Hanging

    Have you contacted SAGE support?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Act 2007 Hanging

      Hi,

      Thank you for your response. Yes, we have spoken to Sage support, and a couple of hours of checking service pack levels, uninstalling / reinstalling client side, and opening the demo database without the issue repeating did not resolve our problem with our database of 13,000 customers. They agreed that we did not have an unduly large amount of data though, even if their suggested solution was to upgrade.

      Best regards

      Comment


      • #4
        Re: Act 2007 Hanging

        Originally posted by technotopiary View Post
        Hi,

        Thank you for your response. Yes, we have spoken to Sage support, and a couple of hours of checking service pack levels, uninstalling / reinstalling client side, and opening the demo database without the issue repeating did not resolve our problem with our database of 13,000 customers. They agreed that we did not have an unduly large amount of data though, even if their suggested solution was to upgrade.

        Best regards
        Do yourself a favor and get a better accounts package. Iv had some bad experiences with Sage namely an upgrade i did recently. Was an absolute nightmare because Sage version 12 isnt backwards compatible with Sage 11 databases. The conversion process stalled and completely annihilated the database.

        Even when i did get it working with our TS2008 server and on all the clients there were a number of random and nagging issues because of service pack levels and bugs within the Sage software and the plethora of updates. Myself personally im not a fan of Sage at all and hate having to even deal with it.

        Comment


        • #5
          Re: Act 2007 Hanging

          Hi again

          Thank you, but the users needs are addressed by their current version of Act, so we are stuck with Act 2007 for the present, and purchasing an alternative will not solve this issue for them.

          Some further information about the server and our attempts to solve this problem. We used to have ACCPAC on this server, running on Pervasive SQL, but I stopped both services, relational & transactional, a year or two ago, when Act's SQL 2005 Express was installed, and they have been disabled for a while now, pre-dating this issue.

          We have run the usual Act, Tools, Database Maintenance, Check and repair, which performs its Integrity Check successfully, then the Database Reindexes, and no errors in the Event viewer, with no change to the issue so far.

          We have also installed SQL Server Management Studio [ SQLServer2005 _ SSMSEE.msi ] but to no avail, as there is no maintenance utility included with the Express Edition of SQL 2005, apparently. The external consultant that installed Act for the company used 2005 Express Edition, which I assume is usual practice.

          As a result of lack of any obvious SQL based maintenance tools, we also tried ExpressMaint.exe, but we are unable to get it to attach to the Act7 SQL database. It quotes the error ' SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections ' but when checked under Surface Area Configuration tool, both local and remote connections are allowed. This failure to attach occurs both with and without the SQL database running in Single User mode.

          Thanks again for your assistance..

          Comment

          Working...
          X