Link to home
Start Free TrialLog in
Avatar of paynster
paynsterFlag for United States of America

asked on

Quickbooks Database Server Manager services crashes when file is opened

Over the weekend, we applied the updates on our 2008 R2 Standard server. This server is a virtualized machine. We use this machine to run our QuickBooks Database Manager software and store the quickbooks file.

After rebooting server, we can no longer open any of our QB files. All services come up normally. However, if any client workstations opens any QB file, the QuickbooksDB23 service immediately stops and the client starts receiving a variety H202 errors or (-6000, -301). This makes sense since that this point, the Database manager service is no longer running.

I contacted support who completely uninstalled the server manager from the server, ran their "clean up" tool, reinstalled the entire application including the front end and tested again with the same error and result. We even tried to open the file from the server directly and it didn't work. It doesn't matter if you try to open the file in single user or multi user mode. The application does allow you to put in credential for the QB file so it doesn't immediately crash the service until after you try to authenticate. (I am logging in as admin in the file).

Their resolution was that QB is not support on a VM because it's too unstable. The work around was to copy it to a local workstation and open it in multi user mode there. For whatever reason, that worked and they want QB to be on physical server not a virtualized one. This install of QuickBooks has been installed on this server for at least 2.5 years and has been on several versions of Enterprise without issue.

My guess was that it was due to a MS update that came down. I uninstalled each patch that was applied (and for the most part had to restart the server in between each patch), tried it again in between each patch removeal and it still didn't work. All of .NET 4.5 is off of the server. I've attach a list of patches that I removed from the weekend update.

The following error keeps getting logged each time someone tries to open the file. I have researched this thing to death and I can't seem to find anything regarding this issue. What support told me is that the QB service is trying to make a registry entry each time someone opens the file and is getting denied (which didn't make sense to me). However, I dropped the local Quickbooks account it creates in order to run the QuickbooksDB23 service in to the local administrator group on the server and tried it again but it's still the same error.

Right now the file is still loaded on a workstation. I was wondering if anyone can help me with this error. I have no idea what SQLANY has to do with QB or how to correct this.

Thank you.
Log Name:      Application
Source:        SQLANY 11.0
Date:          2/16/2015 6:21:22 PM
Event ID:      1
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      JBCSVR01.jbc.local
Description:
The description for Event ID 1 from source SQLANY 11.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

QuickBooksDB23
*** ERROR *** Assertion failed: 100904[1bb5ff83bcf04b159c01cba79ee6f579] (11.0.1.2584)
Failed to redo a database operation (id=4, page_no=0x575f5, offset=0x7dc) - Error: Cannot access file 'C:\Users\

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLANY 11.0" />
    <EventID Qualifiers="0">1</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-02-17T01:21:22.000000000Z" />
    <EventRecordID>23033</EventRecordID>
    <Channel>Application</Channel>
    <Computer>JBCSVR01.jbc.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>QuickBooksDB23</Data>
    <Data>*** ERROR *** Assertion failed: 100904[1bb5ff83bcf04b159c01cba79ee6f579] (11.0.1.2584)
Failed to redo a database operation (id=4, page_no=0x575f5, offset=0x7dc) - Error: Cannot access file 'C:\Users\</Data>
  </EventData>
</Event>
Updates.txt
Avatar of John
John
Flag of Canada image

So the workaround shows the database is probably OK and that the QB installation on Workstations is also OK.

With respect to the error and the use of database and server manager on a virtual machine:

It should work on a VM. I have done that for years at one client.

At another client with the database and server manager on a real machine, I got the same / similar error.

The resolution above was to adjust the firewall settings. You can download the Network Troubleshooter from Intuit and run it and then see if your firewall is blocking access.

Please let us know.
Avatar of paynster

ASKER

Do you have the link to that by chance. I'll google it and see if I can find it.
Here is the Intuit link for the troubleshooter.

http://support.quickbooks.intuit.com/support/networking/

Please let us know if you make some progress.
Thank you. When I try to run this, the option to fix Network connectivity is greyed out. It wants me to pick a file and then it will look at both. See attachment. I will pick one of our files and try it to see what happens.  I also doubled checked the firewall settings like you suggested. The firewall on the server isn't turned on. See attachment.

I'll run the tool and post what it finds.
FileDoctorOptions.JPG
Firewall.JPG
So it finished and it said "your file can't be repaired". The file has been used for three days by on another machine so I don't think this error is correct. I ran this on the server (the hosting machine). Did I need to run this on a workstation for the network connectivity option to show up?
FileDoctorMessage.JPG
Same error if I run this from a workstation.
ASKER CERTIFIED SOLUTION
Avatar of John
John
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

We did put the company file on a local machine already. That's how the users are currently able to work. The only work around support could come up with was to move it to a workstation (again, they wanted it on a physical machine versus virtualized) and have the workstation host it from there.

When we moved it off the server, we never had to do a repair on it. We just moved the qbw file and had the workstation host it out to the users. It worked with out issue. Do you want me to move that copy and the associated files back to the server to see if it can open it?
Before you move it back, it is good housekeeping to do a rebuild. Once done (successfully let us assume) keep a copy locally and then copy it back to the server and see (after the steps to fix Server Manager) if you can open it.
Ok sounds good. I will have to do this after hours since the users are now in the file but I'll update this later tonight and let you know. Thank you.
Ok so I took  the local copy of the file, backed it up with the data verify on and did the rebuild. I then copied just the .qbw file back out to the server but put it in a new location. I updated the database manager with the location and issued a scan. I then opened QB on the local server in multi user mode and it seems to work. No idea why.

I'm re-apply the updates I removed, I'll reboot the server and try it again. If it works, I'll try to open it from another workstation so that more then one person is in it. I'll keep you posted. Thanks.
did the rebuild. ..... server in multi user mode and it seems to work  <-- Doing a rebuild is a good thing to do when a database is giving issues.

Make sure QuickBooks is up to date, reapply any updates you removed, and please let us know after you reboot the server.
Here's what I did. I took the old QuickBooks folder where the file was stored on the server, broke the share and renamed it. The then recreated the folder, created the share and moved the file out to that location. I did a scan with the database manager. All seemed ok.

I then logged onto the client and tried to open it. I received an error so I remapped the drive, rebooted the client workstation and it opened in multi user mode. So did the rest of the clients. So it seems we're ok now. I'm not exactly sure what fixed it. I have a feeling moving off of the server did the trick for some reason and opening it on a local client.

In any event, we are back up and running. Thanks for your help!!
@paynster  - Thanks for the update and I was happy to help you.
Also a little late to the game, but I had found the service was not running on our server.  I switched the service to run under "local account" instead of teh QB user and the service would start up as normal.