Link to home
Start Free TrialLog in
Avatar of uknet80
uknet80

asked on

Quickbooks get disconnecting users

Dear Experts,

Our Quickbooks file is located on Database Server manager on Linux Server. Link speed is 70Mbps, RAM 8GB

Time to time user get kicked out from quickbooks, they have to login again.
Sometimes after restarting server two or three client login and rest of the users get below message Error codes (-6000, -77), they will not be able to open the file, I have to restart the server for users to be able to login, it is like two users logged in the rest cannot.
This start happening after upgrading client and server to version 11.

Any solution please it is really frustrating, WHY user is kicked out from Quickbooks?? And why this message above.

Your help is really appreciated.

Thank you
 User generated image
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
Avatar of uknet80
uknet80

ASKER

normally that happens when client try to connect retrieve a file that takes some time, it try to retrieve information about that data, and crashes.
Yes - that is the same behaviour I saw at a client.

A couple of things from the Windows world:
1. Uninstall and then re-install the QB Server Manager engine.
2. Make sure the company data file is on the same drive (and same partition) as the Server Manager.
3. Launch the Server Manager and scan again for the company file.

You can also make sure there are no settings in the server that promote disconnection after inactivity.

Not likely, but do check the QuickBooks clients that none of them have Host Multi User Access set. QuickBooks -> Files -> Utilities.   .... Thinkpads_User
Avatar of uknet80

ASKER

as mentioned it is on linux server,
Currently our server is located at another location (site), we are connected to through wireless, O checked the wireless speed it was 73Mbps. required connection speed is 40Mbps.

do you think that might be causing that?
>>> Currently our server is located at another location (site), we are connected to through wireless

New information!

I assume this is QuickBooks Pro or Premier, and in that event, you should never be running QuickBooks remotely. It is not designed for that and not only could that be a cause of QuickBooks disconnecting, it can also lead to ledger (.QBW company file) damage.

If you want to run QuickBooks remotely, there are only two ways to do it that are reliable.

1. For QuickBooks Pro/Premier, put it on a local machine (local to the server) and remote into the machine. That allows QuickBooks to run locally and perform properly.

2. For QuickBooks Enterprise, you can run it on a Windows Terminal Server in terminal services mode (you install QuickBooks directly on the terminal server). Again, people remote into the terminal server. I do not know if Linux can function in this way.

... Thinkpads_User
 
Avatar of uknet80

ASKER

although is remote but it LAN connection NOT WAN. do you still think that shouldn't be happening
QuickBooks is not setup to work remotely at all. Even the two approaches I outlined have QuickBooks running locally with terminal services-type access.

So you really need to move away from remote access as the business risk of ledger damage is very real (I have experienced this with clients). ... Thinkpads_User
Avatar of uknet80

ASKER

You are the right person to ask,

I have confirmed the connection setting with my colleges they said it is a fiber connection Not wireless. our site connect to the ISP fiber provider and from their to remote site through fiber as well.

what do you say about that?

I would offer the following thoughts:

1. Overarching all of this, when QuickBooks discconnects, it increases the risk of ledger damage. So while testing, make a copy of the ledger to a client computer. Open the ledger locally and do a verify / rebuild. See if there are any errors.

2. Local connection: I have not used a fibre WAN-LAN, but for me, local means switched connection on the same subnet as the server running Server Manager. I cannot say whether the Fibre connection will suffice as a good enough LAN connection.

3. Test:  Bring a machine to the local server site that has QuickBooks loaded on it. Hook it up locally (LAN) to the Server switch. Now run QuickBooks as normal from the client machine. See if the disconnect continues or if the disconnect vanishes. This test will help isolate where we look.

... Thinkpads_User
SOLUTION
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
Avatar of uknet80

ASKER

thanks guys for your suggestions, i will do what you said and will come back to you with result
Avatar of uknet80

ASKER

yesterday, i contacted Quickbooks support, the told me to verify data, verification failed, I did rebuild DB, and that fixed the issue.  today everything when fine, but suddenly three users got kicked out,

the error message started from below code,
this this give you any clue?
Sep 27 10:12:47 quickbooks SQLAnywhere(qb_quickbooks.local_21): LIN: Login for 48657a612e736164656b on connId 95
Sep 27 10:12:47 quickbooks SQLAnywhere(qb_quickbooks.local_21): LIN: Conn pool extended.
Sep 27 10:12:47 quickbooks SQLAnywhere(qb_quickbooks.local_21): CON: Connect for 48657a612e736164656b
Sep 27 10:12:48 quickbooks SQLAnywhere(qb_quickbooks.local_21): Connection terminated abnormally; client socket shut down
Sep 27 10:12:48 quickbooks SQLAnywhere(qb_quickbooks.local_21): Disconnected TCPIP client's AppInfo: IP=10.1.1.226;HOST=JOHN.KRISTO;OSUSER=john.kristo;OS='Windows Vista Build 6002 Service Pack 2';EXE='C:\Program Files\Intuit\QuickBooks Enterprise Solutions 11.0\qbw32.exe';PID=0x27d8;THREAD=0x263c;VERSION=11.0.1.2405;API=DBLIB;TIMEZONEADJUSTMENT=180

Open in new window

>>> today everything when fine, but suddenly three users got kicked out.

Have you tried a local-only connection yet to see if the issue is in the network?

Every time you get disconnected, the database may have an error again (which necessitates another rebuild).

... Thinkpads_User
SOLUTION
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
Avatar of uknet80

ASKER

The solution was to more it to windows server, I think it was to do with samba authentication with AD
Thank you. I was pleased to assist and glad you got it sorted out since the QB connection is so important. ... Thinkpads_User