Author Topic: Moving from QB Single-User mode to Multi-User  (Read 3456 times)

LelandLong

  • Member
  • *
  • Posts: 7
    • Keller Interiors, Inc.
Moving from QB Single-User mode to Multi-User
« on: November 05, 2012, 01:33:30 PM »
Afternoon,

I've been successfully running a FMP "robot" to handle QuickBooks integration for several months now. It runs a script every 10 seconds and takes FMP data entry changes and updates/creates cooresponding entries in QuickBooks. Very nice and fairly painless thus far. BUT, this has all been working on one machine in QB Single-User mode.

A few weeks ago I tried converting it to a Multi-User mode configuration, with a second computer with QB opening up the same company data file. This by itself raises red flags in my mind since we've known for a long time that this is a BIG no-no in the FileMaker database world. However, this appears to be the way QB handles multi-users...

After finally getting the same file open on two different machines I quickly discovered that this did not seem to be very stable. I very quickly had a crash on the second machine and when attempting to re-open I got file errors. And upon closing it on the first machine (host) and trying to reopen it it also had file errors. So I went back to the most recent backup copy and started over again.

Within several minutes, more errors, crashes, corrupt data files, etc. as before. Exasperation to say the least. I gave up. The whispers in the back of my mind said ... maybe ... it's the fact that you're doing this on two Mac's, both using Parallels with two different Windows OS's... maybe. Not an answer I liked to hear, but maybe...

Fast forward to today. New PC installed w/Win 7. QuickBooks installed & updated. Company data file moved over. Launched. A-OK, all appears well.

Back to the iMac with Parallels running Win 7 that's been the NO-problem-in-single-user-mode-machine-running-the-robot-24/7.

It opens the "shared" company datafile that's now hosted on the new PC running multi-user mode. Start up the robot, it starts chugging away.

Within 2 minutes (several successful QB entries later) it crashes !! WTHeck man.

After re-starting things, it has now been successfully chugging along now for at least 30 minutes without any errors. BUT, needless to say, I'm expecting one any minute. If I have more luck than I anticipate it might go all day without crashes, dunno. Anyone else had similar issues?

 - - - - -

Summary and question:

I state all of this to hopefully paint enough of a clear picture of what has happened up until now. My intent was not to bore you to tears...

Question: anyone else using a similar setup? Similar issues? Any other Multi-User environments out there? Single-user only without problems?

IF I can get this to be stable, the next challenge is for another PC laptop to be able to access this "shared" company file from a few states away. That's the reason for this madness in the first place...

Machine #1 Config:
iMac 10.7.5, 16G
Parallels 7
Win 7 Home Premium
QuickBooks Pro 2012
FMPA 11

Machine #2 Config:
Dell Optiplex 3010 w/i5, 8G
Win 7 Pro
QuickBooks Pro 2012
Leland Long
I.T. Director
Keller Interiors, Inc.
lelandlong@kellerinteriors.com

Kevin Clemons

  • Member
  • *
  • Posts: 65
    • Productive Computing
Re: Moving from QB Single-User mode to Multi-User
« Reply #1 on: November 09, 2012, 10:39:14 AM »
Hi Lelandlong,

Are you using the correct tools from Intuit to properly host the QuickBooks file? I am not 100% sure where the failure point is, is your FileMaker crashing and corrupting or your QuickBooks?
Kevin Clemons
Products Support Specialist

950 Boardwalk, Suite 205
San Marcos, CA 92078
760-510-1200 xt.105 (voice)  760-510-1991 (fax)

Follow Productive Computing, Inc. on Twitter or FaceBook for the latest updates and product versions.

LelandLong

  • Member
  • *
  • Posts: 7
    • Keller Interiors, Inc.
Re: Moving from QB Single-User mode to Multi-User
« Reply #2 on: November 09, 2012, 11:23:01 AM »
Correct tools? I'm following the Intuit instructions for turning a single-user session into a multi-user environment.

It's been working flawlessly since that initial crash ... (QuickBooks crashed, FileMaker did fine)

My first couple of attempts several weeks ago (described in the earlier post) had several immediate crashes. This caused me to be gun-shy when, on this later attempt with a different setup, it crashed within 3 minutes of robot transactions via FileMaker (QuickBooks crashed, FileMaker did fine).

BUT, since that first crash, after I shut everything down and tried it all over again, it has NOT crashed since. It has run 24/7 now since Monday, successfully sending 7000 queries/modifications/additions from FileMaker to QuickBooks.

My concern was stability. I still have no clue what caused the crash and there was not an error message returned from QB when it crashed, so ...
Leland Long
I.T. Director
Keller Interiors, Inc.
lelandlong@kellerinteriors.com

Chris

  • God
  • Member
  • *****
  • Posts: 83
Re: Moving from QB Single-User mode to Multi-User
« Reply #3 on: November 26, 2012, 09:34:01 AM »
There may be 2 different issues here.
1) Some requests sent to QB are only available in Single-User mode.  For instance using an InvoiceMod request to link an invoice to another transaction is allowed only in single user mode.
2) I seem to recall that only one external application can log in to a given QB file a time.  In other words, having two instances of FM accessing the same QuickBooks file at the same time is prohibited by QuickBooks.

LelandLong

  • Member
  • *
  • Posts: 7
    • Keller Interiors, Inc.
Re: Moving from QB Single-User mode to Multi-User
« Reply #4 on: November 26, 2012, 09:47:31 AM »
Thanx for that info.

1) should never have this happening since my FMP invoices are only modified by users with regard to changing data in pre-existing line items that will never change invoice numbers.
2) I think I read that somewhere in the multi-user spec's. I certainly won't be trying to anyhow.

Great news! Since I first posted this thread I haven't had another crash at all. It's been running 24/7 problem free. The only "problem" arose at 03:00 when the PC had auto-install enabled and the "host" QuickBooks machine restarted itself.
Leland Long
I.T. Director
Keller Interiors, Inc.
lelandlong@kellerinteriors.com