Solved

Quickbooks Aborting users Randomly

Posted on 2014-01-16
3
2,465 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 92

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 92

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have been working as System Administrators since 2003. I recently started working as a FreeLancer and was amazed to find out that very few people are taking full advantage of their Windows Server Machines. Microsoft Windows Server comes with so…
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 enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

896 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now