You see an error in the log similar to this:
This error comes directly from the Intuit Software Development Kit (SDK) and indicates that certain data cannot be extracted and is directly related to corruption within the QuickBooks file. Typically this error occurs on larger files or files containing more than 10 years of data.
What causes corruption? No one specific thing, but if you have constant network outages or problems, constantly change the same transactions over and over again, accumulate years of data, or experience abnormal shutdowns of QuickBooks, the probability of corruption increases.
These steps have a 80% probably of success. If you get this same error again, then it is necessary to contact QuickBooks support and convince them to take the file into Intuit Data Services to repair the file.
CONVINCING INTUIT TO TAKE YOUR FILE
If you perform a rebuild using the QuickBooks Utility - and it shows no errors - and you still get the same error-1000 during the synch, then there is a corruption problem underneath the hood, that the rebuild, or verify logs may - and probably won't - not show.
In these cases, QuickBooks will not take the file, and attempt to throw the problem back at you - and QQube. However, we, like all QuickBooks 3rd party developers, are beholden to the Intuit SDK, and if the SDK is unable to pull data, there is nothing that anybody can do to get around the problem.
So, we need to give Intuit Support proof that the SDK is unable to extract the information from QuickBooks.
THE INTUIT SDK CREATES A LOG
There is a file called qbsdklog.txt in which Intuit logs SDK the details of the interaction between QuickBooks and a 3rd party application like QQube. It is located in c:\ProgramData\Intuit\QuickBooks
When you get the 80040402 error a second time, immediately grab the qbsdklog.txt and Create a Support Ticket, attaching that file, as well as the QQube synch log.
We can review the files, and ensure that you have the correct "ammunition" you need to convince Intuit that you have corruption in your file, and that they need to accept the file to fix it.
IF THE FILE IS LARGE CONSIDER ALTERNATIVES
If your file is one of the following:
Then we strongly advocate getting someone like Matt Clark at http://www.qbornotqb.com to split your file into two files: (1) with old data, that you can open - or store in QQube, and (2) a current file for every day use. DISCLAIMER: We do not receive kickbacks from this company - we recommend him because he has successfully taken care of hundreds of customers over the last decade.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/383/error-1000-quickbooks-data-corruption