Only Sage 300 cannot connect to database

A customer runs Sage 300 v 2012 on SQL.  Starting this morning, they have been getting the dreaded 49153 error, intermittently.  Happens on all workstations (3).  But other applications that use SQL (Accellos, for instance) are running with no problem.  

And it is only from the workstations, running Sage 300 from the server presents no issues.  The users are able to access Accellos from these same workstations.  They can access Accellos even when they get the 49153 error.  So the connection to the server seems to be working ok.

It isn't a system idle condition - they can be in the middle of a Sage 300 transaction when the server becomes unavailable.  Luckily, they were able to get all of the AP checks printed today (!) but the database error reappeared within a couple of minutes after it completed.

The IT folks have not made any changes in the last day.  There have not been any changes to Sage 300.  The data volumes for receiving via Accellos are slightly elevated but not above previous loads.

I would suspect an infrastructure issue if all applications became equally unresponsive, but that is not the case.

Any idea where we need to look for a resolution?

  • 0
    This is an infrastructure problem, like a flaky NIC.
  • 0
    Also - check the system database. Other applications may not use it but Sage needs it.

    Jay's suggestion is definitely worth looking at.

    We had an issue in a virtual environment where mid-day server back ups on one server took more than 30 seconds and that was enough to break Sage's database connection which it keeps open all the time that a screen is open. If that connection breaks then any open screen won't work until they are closed and re-opened.
  • 0 in reply to Django
    When you say 'check the system database'...in what way? I am pretty sure that they don't have a process in contention (like a backup). And the error happens not only during transaction processing but also during startup from the login screen. However, you've given me a thought - I will ask them to see if they get the same drops once the Accellos folks have wrapped up for the day.
  • 0 in reply to MClark
    I only mention the system DB because it is usually ignored by third party applications. However, as you've said, it is intermittent.

    It might be worth looking at the database growth settings. Growing by 10 percent when your database is big takes long than simply growing by a static amount, like 200mb, for example. Also - check that your SQL logs (ldf files) are not on the same drive as your database files (mdf files) to eliminate any database reading/writing bottlenecks.
  • 0
    It sounds like an overloaded SQL server or bad network hardware.