Simply Accounting error 50

Hi
I have a problem with a database that is located on a server and shared.
Every few days people complain that they can't open one of the company. It's not always the same. Some time they can open Company A and not B and some time company B but not A
When it happen no body can open that specific database until I reboot the server.
The error is 50 Sage 50 Cannot open the database because the database engine reported an error. Sage 50 Has detect a firewall which may be blocking files that are require by Sage 50. Please ensure that any necessary files has been added to your firewall list of permited programs.

I verify that Simply is allow on all machines and the fact that rebooting the server fix the problems it tells me that the problem is at the server level and not at the PC.
Any ideas what can cause it?
LVL 2
infedonetworkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
Simply Accounting is never simple.
What version?
We are presently Sage 50 Quantum Accounting Version 2015 Update C.
Cripes knows there are enough versions and updates.
What server?  Or is it a workstation serving the data out?
How many licenses do you have -- and do you ever have more users than licenses?

Is a reboot the required element?
Or does stop/starting the Sage 50 data connection service -- which these days is a glorified MySQL installation do the job?

Is anybody crashing Simply or crashing their machines when this occurs?
An improper Simply shutdown can leave an orphan process on the server that can make it insist that a company is still in use when its not

How's your network infrastructure?  All databases hate flaky routers.

What kind of network are you running?  I have more than one thing that doesn't play nice with the Windows Firewall -- so I have group policies in place that turn it off for servers and workstations when they are on the domain network.

Have you turned off the firewall on the server ad the workstations and tested when this error occurs to see if it is actually a firewall issue like the message says and not some other oddball Simply glitch?

Post a lot more detail!
0
pcelbaCommented:
This does not seem to be firewall problem because it would block everything not just part of data randomly...

What database engine is used for Simple Accounting?
If the Sage database is accessed as a file on the server then this behavior could point to SMB2 and/or oplocks settings and network admin should help. If the database is Client-Server then the error points to significant problems in your data engine/database itself.

Unfortunately, here are no Sage experts available at EE and the best choice is to ask at Sage forum directly. Look at their knowledge base first: https://support.na.sage.com/selfservice/microsites/msbrowse.do?UMBrowseSelection=SG_SAGE50_U_S_EDITION_1

If your problem does not correspond to any KB entry ask Sage experts directly. Sage is paid product so their support staff should be more responsive than EE forum driven by volunteers... BUT Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. So please contact your Sage Business Partner or network administrator.
0
Nick67Commented:
@pcelba
The Asker has said that the Simply error mentions the firewall

What database engine is used for Simple Accounting?
That depends upon version.
Simply goes back nearly 30 years, and commands 80% of the Canadian market.
The oldest versions (DOS-based) I don't know -- they may well have been a Paradox engine.
For quite some time, the .SDB format was in fact an MS Access-based file and engine
Around 2009, Simply switched to a transmogrified MySQL engine.
The install action ask the user if you will be sharing data or only accessing data.
The MySQL engine gets blown in if you say you will be sharing the data.

If your problem does not correspond to any KB entry ask Sage experts directly
ROFLMAO
We pay the ransom for both payroll updates and support.  I don't think phone support has ever successfully helped us with anything -- despite the $1000's spent annually and the years on the phone.  And if you don't pay the blood money, you don't get access to the KB  -- but since Simply doesn't have a useful search algorithm in place -- and certainly isn't accessible to search engines  -- the KB isn't all that helpful.

As for what Simply can and cannot screw up "This does not seem to be firewall problem because it would block everything not just part of data randomly... "  I learned last century when you had to turn off hardware acceleration on Compaq Presario desktop video cards to prevent Simply from blue-screening the unit not to make any reasonable assumptions about what an accounting program can screw up.

Simply can screw up literally anything
Your link to the US KB has a Pervasive error article as its first entry -- but I can confirm the Canadian version is still MySQL.

If only the accountants didn't actually like Simply...
Sigh.
0
Nick67Commented:
You aren't using Google Drive, OneDrive, DropBox or iCloud to keep things safe are you?
Or any other kind of Cloud backup solution?
Because that is not supported and will cause problems

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=13650&sliceId=1&cmd=displayKC&dialogID=367998&docType=kc&isLoadPublishedVer=&stateId=368001&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl
0
infedonetworkAuthor Commented:
This is sage 50 2015 Canadian edition.
I have the database installed on SBS 2011
The original problem was that nobody could open any database so after investigation more I realized that the backup may have block the connection managed. I then switch acronis and I enable VSS.
Since then it never happen again than both database can't be open. Only one at the time.
Rebooting the server fix the problem. I believe that just restarting the connection manager does it to.

I disable the firewall on the workstations and on the server was already done. I will monitor for the next week to see what happen.
0
Nick67Commented:
And, one hopes that the server hosting the companies AND all the workstations using them are running the same version and release of Simply, because that will blow stuff up real good if you aren't

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=16350&sliceId=1&cmd=displayKC&dialogID=367998&docType=kc&isLoadPublishedVer=&stateId=368001&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl
0
infedonetworkAuthor Commented:
I use live drive to cloud backup
0
Nick67Commented:
This is sage 50 2015 Canadian edition.
I have the database installed on SBS 2011


Task manager is your friend.
Have a look at this article to see how to identify rogue Simply processes

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=14176&sliceId=1&cmd=displayKC&dialogID=368355&docType=kc&isLoadPublishedVer=&stateId=368356&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

That may or may not be applicable here, but knowing that the Simply company process is mysqld-nt.exe and how and when it is acceptable to kill it is a happy thing to know regardless.
0
Nick67Commented:
I use live drive to cloud backup
That may be your grief, then.
Database files can get really pissy if two processes (the LiveDrive sync and MySQL) try for simultaneous access.

I can see wanting your accounting data backed up safely -- but you just cannot get that to happen while its in use

If you can schedule LiveDrive for off-hours, your problem may abate.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.