Maintaining QuickBooks Data Integrity in QQube | 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. And the only way to fix these is to clear the QQube database and reload from scratch.

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.

Data Integrity Issues Requiring a Reload of the QQube Database

These issues will require you to reload your QuickBooks data from scratch.

• QuickBooks year upgrade. (that is from 2021 to 2022; upgrading from 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
  • A backup kicked off in the middle of the synch.
  • 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 CLEARIFY Support.

How to Reload

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

VERSIONS 6.x AND 7.x

First check the "Run All" Box, then the box "Clear all data on synch start" will be available for you to check. (You will notice that "Scheduled" will have an asterisk at the end e.g. Scheduled*, both in the log, and on the list of Synch Logs in the QQube Configuration Tool).

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.