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