Solved

Quickbooks Aborting users Randomly

Posted on 2014-01-16
3
2,803 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 95

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 95

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

705 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