Synchronization Fails

Version 1

    Verified Product Versions

    Avalanche 5.3Avalanche SE 5.3

    Verified Product Versions

    Wavelink Avalanche Mobility Center / Site Edition 5.3.x



    Avalanche MC/SE 5.3.x with postgres DB



    • Synchronization Failed Message in Task Scheduler
    • After Synchronization locations still show a synchronization is needed.
    • Avalanche Server log shows error regarding this exception

    2015-12-18 08:15:38,197 ERROR DeploymentJob            - SQL Exception: ERROR: update or delete on table "profile" violates foreign key constraint "fk_agent_profile" on table "mu_agent_properties"

      Detail: Key (profile_id)=(1) is still referenced from table "mu_agent_properties".



    Take a backup!

    Log into PGAdmin III

    Select the database avalanche53

    Select the SQL query icon (looks like a magnifying glass)

    run the following script

    DELETE FROM mu_agent_properties WHERE profile_id=1;


    Schedule a synchronization and you it will now complete.

    If using Site Edition, you cannot schedule a synchronization. Just make any change to trigger a synchronization