Troubleshooting: Load Updated Data did not complete (3) and Reload All Data did not complete (3)

Problem Description

      Sometimes you get the following error by clicking Load Updated Data or Reload All Data when you try to run the optimizer from the QODBC configuration screen:

      Load Updated Data did not complete (3)

      Reload All Data did not complete (3)

Solutions

      Firstly, make sure you are using the latest version of QODBC (via QODBC Driver for QuickBooks Download) and that QuickBooks is running, your company file is open and don't have any active panes open in QuickBooks.

      Note: If you want to reload all data, please make sure QODBC is using a QuickBooks Admin account. If you use a USER account with limited access to parts of QuickBooks, then a Reload All Data will never complete correctly.

      Then try resetting the optimizer (again) as in How to switch OFF or RESET the QODBC Optimizer

      See also: How to setup QODBC Optimizer and where are the Optimizer options

      If still have issues, please try also running the query below in VB Demo:

      Select Name from Customer VERIFY

The verify does an optimizer rebuild on the Customer table.