When to Reload from Scratch | CLEARIFY

Maintaining Data Integrity and Accuracy

We use the Sybase SQLAnywhere database technology, which has a reputation of being a very robust, high performance product that maintains strict levels of data integrity.

However, there are times where the data becomes corrupted inside of QQube because of faulty synch operations, corruption in the QuickBooks database file, or QuickBooks data and preference changes.

The only way to clear the QQube database and reload from scratch is to use the "Run All / Clear all data on synch start" option in the QQube Configuration Tool.

On larger QuickBooks files this can be painful because of the limitations of the Intuit Software Development Kit (SDK), but data accuracy overrides all concerns.

Version 10 however, makes this less painful, as it has the ability to load only only the last few years of data.

Issues Which Require a Complete Reload from Scratch

These issues require this operation, without exception.

• QuickBooks year upgrade. (that is from 2023 to 2024; upgrading from QuickBooks Release 3 to Release 4 does not require a reload)
• QuickBooks file is rebuilt.
• Merging Lists:
  • accounts
  • items
  • customers.
• Custom Field name changes.
• Manual abort of the synch process from the QQube Configuration Tool.
• Abnormal interruption of the synch process which can occur in the following circumstances:
  • QuickBooks crashed
  • Somebody logged off the user where the synch was taking place. 
  • Somebody opened up a second instance of QuickBooks while logged into the user where the synch was taking place
  • A backup that affects QuickBooks kicked off in the middle of the synch.
  • Another 3rd party application was attempting to communicate with QuickBooks at the same time the synch was taking place - under the same machine user.
  • QuickBooks corruption
• Unexplained data inconsistencies after the data has been previously accurate.
• mvf_FINANCIALJOB error message in the log: "Subquery cannot return more than one row - refresh materialized view "mvf_FINANCIALJOB".
• Request from a CLEARIFY engineering.

The Only Way to Reload From Scratch

First, open up the QQube Configuration Tool. Then open up the Data Synch option, and highlight the Manual Refresh section as shown below.  

First check the "Run All" Box, then check the box "Clear all data on synch start"

Please remember that a reload from scratch - may take some time, and is dependent upon the size of the file, and the speed of the computer. Learn more about synch speeds.