Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: FMG37 on September 28, 2011, 06:55:40 AM

Title: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: FMG37 on September 28, 2011, 06:55:40 AM
My integration updates QBs customer records and creates invoices.  Everything works as expected when used by a single user.  When two users are using the application at the same time, we are getting "Error 3170: There was an error when modifying the customer list element...This list has been modified by another user."  The users are updating different customers so they are not competing to update the same QBs records. Has anyone seen this or know how to get around this problem?   
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: Geoffrey Gerhard on September 30, 2011, 02:30:06 PM
What QB windows are open when you get that message? The wording of the message is odd, and leaves me wondering whether either user might be editing one or more customer records in a way that is locking the entire Customer List in QB. Maybe a red herring: Did you make an Accountant's copy of the QB file?

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: FMG37 on October 04, 2011, 08:31:44 AM
Generally, only the Customer and or Vendor center are open in Qbs when the sync'ing is taking place from the FileMaker application.  We will run some additional tests with all QBs windows closed to make sure that is true and not a factor.  What situations could cause a complete lockout of changes to the Customer table?   We did not make an accountant's copy of the QBs database - what is the requirement with that?
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: Geoffrey Gerhard on October 04, 2011, 02:18:36 PM
IIRC, using the Add/Edit Multiple List Entries feature (not sure how many versions of QB support this feature) will lock the entire QB Customer List while that window is open. I've also seen some locking occur when some of the QB "Update Now" and/or "We also offer..." dialog boxes open themselves up. I make a habit of checking the "Turn off pop-up messages for products and services" checkbox on the My Preferences pane of the General preference section of the Preferences dialog box to help guard against unexpected lock-outs.

Making an Accountant's copy locks transactions prior to the date selected when making that copy. Less sure if it locks any of the QB List records. I wouldn't expect it to lock the Customer List, but haven't ever tested to confirm that expectation.

Hope you'll post here to let us know how it goes.

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: Chris on October 20, 2011, 03:14:32 PM
Two common problems....
1) There might be a problem when two users are accessing the QB file at the same time with the plug-in.  If I recall correctly QB only allows a single application connection to QB at a time.  This means that if one application has the file 'connected' then no other application can access it.  There could be a problem with your scripts not calling PCQB_EndSession, thus preventing other apps (anther FM Books Connector installation ) from accessing the QB file.

2) The list record is actually modified and one of the clients has an out of date edit sequence.  All of the scripts I write for updating objects include a subscript to get the latest edit sequence before creating the Mod request.

Chris
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: Geoffrey Gerhard on October 21, 2011, 07:51:26 AM
Chris:

The first problem you identified has important ramifications for solutions that access QB throughout the day. The time it takes to open and close the connection to QB can add up to a nuisance, so it's fairly common (in my experience) to open the connection the first time a Request is passed and leave it open all day.

Can you check on and confirm your recollection? If it's correct, the Intuit Sync Manager--which is on by default (and can't be disabled or uninstalled) in some versions of QB Enterprise 11--could cause a problem even where only one user access QB via FMBooks Connector.

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

P.S. Chris identifies what I consider a "Best Practice": Always include a Query Request for the Edit Sequence value of the targeted entity when creating a Mod Request . There's no value in storing a QB Edit Sequence value in FMP. (Store the TimeModified if you need to know whether a QB record was updated in QB since that record was last accessed from FMP.)
Title: Re: Error 3170 When Two Users Try to Update Customer Records at Same Time
Post by: gersonrm on November 23, 2011, 09:53:58 PM
Ok, so this is my situation,

Basically have a running process, that pulls data from some database, and does all the work of importing customers/invoices/receipts/payments, to a Quickbooks 11 system.

Yesterday, I made an update to Quickbooks 12, and everything seemed to work perfectly. However, when the system got three users or more, logged to the same company file, and my process tried to store, or update a customer, i am getting this error:

There was an error when modifying a Customers list, element "80008CD2-1276794573".  QuickBooks error message: This list has been modified by another user


I am using the QIbiz integrator library, which had been working very well with the previous version of quickbooks, so i do not think that is the problem.

I need to know, if this problem has any sort of patch or solution, on the Quickbooks side, or if anyone could give me a hand on this, i will really appreciate it.

Thanks,