Oh, I’m on 2.something not the 3.0 version. I can’t imagine why they would discontinue that, it can be a useful feature. Being that we’re on 2 different versions I’m not sure if there are any “new” features that might replace that from the old one. What about in the error logs in windows, does it show anything that might help?
Yudel Rosales: The issues are the same ones that this whole thread is talking about. Specifically see Jan24 and Feb7 posts.
It’s been running well for the past few weeks and then this week it’s started doing it again. (what is mentioned in the above posts). I’ve tried to upload the files to you but have been told that you didn’t get them. I don’t know what else to do.
Josh, I agree. Something updated (I think Microsoft shoved their updates out the door the other day) and since then it’s been crashing constantly. Thanks for letting me know that I’m not the only one! 🙁
What operating system are you running?
I had this same issue when we upgraded from Server 2008 R2 (same code base as Windows 7) to Server 2012 R2 (same code base as Windows 10). Problem was never corrected, but went away (of course) as soon as we restored back to Server 2008 R2.
Howard, We are running the same Server version as you and that is where Quickbooks resides. The opensync program is running on a Windows 10 Pro (latest updates) and populates a mysql database on that same Windows 10 machine.
Last week it wouldn’t run 20 minutes without Quickbooks crashing, this week it has run without a problem.
I look at the logs and the opensync logs don’t show any problems. They indicate that the open and fetch requests were made with no troubles. The quickbooks log shows that it didn’t shut down properly.
I had the fetch set for once every 10 minutes, but last week when it was crashing I changed the fetch time to every 15 minutes. It was still crashing.
There doesn’t seem to be any particular set of circumstances when it crashes, other than maybe Mars hasn’t aligned with Venus correctly. 😉
This thread has been going on for several months and I don’t seem to be able to get any help from opensync so I’m just living with it until I can schedule time to write my own fetch routine with the QB SDK. (Main reason I went with opensync was the SDK is a mess to figure out!)
I doubt any of this will help you, but if it happens to lead you in the right direction, then I’m glad I could help.
I would recommend overriding your QBXML to version 11 in opensync options – especially if you have a large customer list with many children – if nothing else for testing purposes. QBXML 11 queries certain tables, especially the customer table differently and more efficiently – worth a shot.
Joe B – THANKS! I changed the setting and will see how it goes. I don’t have a huge customer table. My sales order and sales order line item tables are the two large ones I’m pulling from QB. I’ll post back here if this helps.