Solved

Quickbooks Aborting users Randomly

Posted on 2014-01-16
3
2,545 Views
Last Modified: 2014-04-19
We have a virtual machine running Quickbooks 2012.  The DBs are normally used in multi-user mode and generally runs 2 seperate .qbw (company) files (although we have 6 different .qbw files that may be opened with the latter 4 belonging strictly and accessed by the owners of the company).  

Many of our users experience being aborted at random intervals with no logging of disconnections in the Windows event logs.

Anyone have an idea where to start with these diagnostics?
0
Comment
Question by:PriorityResearch
  • 2
3 Comments
 
LVL 93

Expert Comment

by:John Hurst
ID: 39788393
Make sure the QBW files are local to the QB application or on a Local Area Network. Quick Books does not function well remotely, so make sure that is not happening.

Make sure the user closes the QBW file before closing QuickBooks (File Close Company).

Make sure the network connection to the QBW file is solid. Check it. A flaky network connection can cause this.

.... Thinkpads_User
0
 

Author Comment

by:PriorityResearch
ID: 39788439
All of the suggestions are true Thinkpads_User except one which I'm trying to prove or disprove now.  

What I'm investigating is this:

We have a Netgear 724T acting as a server switch to the two hosts in our VMWare VSA environment.  Each host has 4 ports on the NIC, all Gb.  On ESXi the hosts are teamed,  but there is no current LAG setup on the Netgear switch.  This is causing the MACs from the connected ports to be displayed as being accessible from both ports in the switches address table instead of being accessible from a LAG.  

I believe this may be causing an issue but I've also been unable to setup a functioning LAG between ESXi and this Netgear switch.  The ESXi host always starts to cycle connection to the vCenter Server located on another device attached to the switch.

I will also say there are VLANs on this device to separate out the production environment from the backend VSA but there's only the two. The LAGs are set to the proper VLANs
0
 
LVL 93

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39788451
A flaky network (very brief disconnect) will cause QB to abort because the QB database is very chatty. So the network connection must be 100% solid.

Try your ledger (QBW File) on a local machine to test that it is work.

Also, do a verify / rebuild because disconnections can damage the database. Do this only on a local machine.

.... Thinkpads_User
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question