Tools

Error on accounts synchronization with Active Directory

There is an error 99 on the XML importation logs.

First published date

10/9/2018 11:35 AM

Last published date

10/9/2018 11:35 AM

Overview

There is an error 99 on the XML importation logs.

Product section

Dameware Remote Support & Mini Remote Control

Cause

This is caused by a foreign key error in the database.

Resolution

  1. Download an SQL compact editor.
  2. Create a backup of the database.
  3. Open the database with the editor.
  4. Locate the Foreign key based on the XML logs from the Central Server.
  5. Run the following SQL query.

    Note: The first query deletes a related row in HostList and second query deletes user with specific ID. 
    DELETE FROM CentralServer_HostLists WHERE Owner = '6be46a66-21ea-46c6-8056-f2d4e48c11f3'
DELETE FROM CentralServer_LicensedUsers WHERE ID = '6be46a66-21ea-46c6-8056-f2d4e48c11f3'
  6. Stop the DameWare Central Server service and copy the edited database.
  7. Start the service.
  8. Run the synchronization process again for the accounts.