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 will require you to a must reload your QuickBooks data from scratch.

• QuickBooks year upgrade. (that is from 2022 to 2023; 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.
  • QuickBooks crashed
  • Somebody logged off the synch session
  • Somebody opened up a second instance of QuickBooks where the synch was taking place
  • A backup 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.
  • QuickBooks corruption
• Out of the blue data inconsistencies.
• 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.  

VERSIONS 6.x AND LATER

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

VERSIONS 5.7x

STEP A. In the Data Sources section, hold down the Ctrl Key and Double Click on the phrase "QuickBooks Company List to show the plus sign, and to expose the "Clear QQube Views" check box.

STEP B. In the Manual Refresh section, check the "Run All" and perform a manual refresh. 

You can manually run a synch by clicking on the "Run Now" button, or just let the clearing operation occur when your next scheduled synch is set to go.

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.