Syncing failed. Error: The syncing process for the user: _____ and database: _____ failed. The error is: Dynamic SQL Error
Posted by Craig S, Last modified by Craig S on 04 January 2019 07:34 PM

The full error message reads:

Syncing failed. Error: The syncing process for the user: _____ and database: _____ failed. The error is: Dynamic SQL Error

SQL error code = -206

Column unknown

USERS.HHCUSERNAME

At line 1, column 113.

In order to resolve this, you will need to complete the following:

  1. Ensure that Handheld Contact is closed on the PC/server.
  2. Go to: C:\Program Files\Keystroke\HHC Enterprise Edition\.  Note:  If you have a 64-bit operating system, the Program Files (x86) folder will be used.
  3. Look for a file named ‘HHCSYNCLOG.FDB’.  Cut it and paste it into another location (Eg. Desktop).
  4. Go back to the Handheld Contact download/upgrade file that was just used.  If you do not have it, it can be obtained from HERE.
  5. Select the ACT! version and download/run the file.  When prompted, choose to “Repair” the installation.
  6. Once finished, click on Handheld Contact and open it.  Try syncing again.