When to Clear the Database and Reload

Modified on Thu, 20 Aug at 2:48 AM

Overview

QQube uses SAP SQL Anywhere database technology and is designed for high performance and strict data integrity.

After certain QuickBooks changes or an interrupted synchronization, the existing QQube database may no longer match the current QuickBooks data. In those situations, a normal synchronization is not enough.

A complete reload requires both options

Select both Run All and Clear all data on synch start in the QQube Configuration Tool. This clears the existing QQube data and reloads it from scratch.

Run All and Clear all data on synch start options in the QQube Configuration Tool

A complete reload can take considerable time for large QuickBooks company files because extraction speed is limited by the Intuit Software Development Kit. Data accuracy takes priority over reload time.

QQube Version 10 can reduce the amount of historical data reloaded by using a selected beginning period where the applicable data model supports it.

When a Complete Reload Is Required

Perform a complete clear and reload after any of the following:

  • QuickBooks year upgrade. Required when moving from one QuickBooks year to another, such as 2023 to 2024. A maintenance release within the same year does not require a reload.
  • QuickBooks company file rebuild or corruption repair. Required after using Rebuild Data or after QuickBooks corruption is identified or repaired.
  • QuickBooks list merge. Required after merging accounts, items, or customers.
  • Custom field name change. Required whenever an existing QuickBooks custom field is renamed.
  • Interrupted synchronization. Required after a manual abort, QuickBooks crash, synchronization-user logoff, second QuickBooks instance, backup interference, third-party application conflict, or another abnormal interruption.
  • Previously accurate data becomes inconsistent. Perform a complete reload before continuing with additional troubleshooting.
  • CLEARIFY requests a reload. Perform the complete clear and reload exactly as directed.

Why a normal synchronization is not enough

A later successful synchronization does not repair data left incomplete by an earlier interruption or structural QuickBooks change. The existing QQube database must be cleared before all required data is extracted again.

Complete the Reload

In the QQube Configuration Tool, select both Run All and Clear all data on synch start, then allow the synchronization to finish normally.

For more information about extraction time and synchronization behavior, see How the Synchronization Process Works.

Expected Result

QQube removes the existing synchronized data and rebuilds the database from the QuickBooks company file using the current configuration, list structure, preferences, and selected date ranges.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article