Method:Classic General Q&A

Re: Synchronization Error - URGENT

furrywombat — Mon, 19 May 2014 10:22:23 GMT

Okay, the full sync is complete... finally! But just one thing. When a full sync is performed now, it still hangs for a minute or two, checking "desktop for deleted items" even after syncing multiple times. Seems like there's a comparison table that's off, or incorrect, somewhere.

Got any ideas?

Re: Synchronization Error - URGENT

furrywombat — Sun, 18 May 2014 18:12:18 GMT

The issue was caused by a mass deletion call via the API. More than 30,000 items, intention to delete all INACTIVE items in order to clean up the QB database. Problem has been solved by connecting to the QB database via QODBC read/write driver and performing a mass SQL DELETE query via linked table in MS Access on the Quickbooks side, which appears to have been why the sync engine was hanging.

It's still syncing, but now at least things are moving along. In the future, updates of this nature will just have to be made in smaller batches.

Synchronization Error

furrywombat — Sun, 18 May 2014 05:41:53 GMT

We've been down for four full days now. No sync. Keep getting the out of memory error in Quickbooks. To be sure, I replaced every part in our main computer. Everything is the best there is, in every single category. This is not a memory error.