Skip to main content
Skip table of contents

How to perform a Viewtracker migration reset

If you encounter an issue with Viewtracker, please update your add-on to the latest version before continuing reading.


Execute the following (MySQL) statement on your confluence database - this will reset the migration job, and all the migrated data to its pre-update state and allow you to re-run it manually

  1. Reset the migration job status so it can be run again

    SQL
    DELETE FROM BANDANA WHERE BANDANAKEY='ch.bitvoodoo.confluence.plugins.viewtracker.visits_migration%';


  2.  Remove the 'upgraded' marker for all pages

    SQL
    DELETE FROM OS_PROPERTYENTRY where entity_key = 'ch.bitvoodoo.confluence.plugins.ViewTrackerMacro.upgraded';

     

  3. Delete all visits from the new table

    MySQL

    SQL
    DELETE FROM AO_05769A_VISIT_ENTITY;


    PostgreSQL

    SQL
    DELETE FROM "AO_05769A_VISIT_ENTITY";


  4. Go to the cache statistics administration page (/admin/cache/showStatistics.action) and flush all caches with the button at the bottom of the page

  5. Go to the Viewtracker plugin configuration page (/admin/plugins/viewtracker/datamigration.action) - you should now see a warning in the Legacy Data Migration section 

  6. Restart the migration job by clicking on the Start Migration button

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.