Reinstall User Profiles for Confluence

If you encounter any issues while installing User Profiles for Confluence follow this guide to uninstall, removing any app-related data in the database, and install the app again.

Solution

  1. To uninstall the app go to "Manage Apps" in Confluence and Click the Uninstall button in User Profiles for Confluence
  2. Shut down Confluence
  3. Go to the Database and execute the following queries:

    DROP TABLE "AO_EF453E_OPTION";
    DROP TABLE "AO_EF453E_TRANSLATION";
    DROP TABLE "AO_EF453E_USER_DATA";
    DROP TABLE "AO_EF453E_USER_PROFILE_ELEMENT";
    DROP TABLE "AO_EF453E_TRANSLATABLE";
    DROP TABLE "AO_EF453E_USER_TO_IMAGE_HASH";
    DROP TABLE "AO_EF453E_CONFIG_VALUE_ENTITY";
    DROP TABLE "AO_EF453E_UPP_API_EVENT_QUEUE";
    DELETE FROM bandana WHERE bandanakey like 'de.communardo.userprofile.%.migrate.status'; 
  4. Start Confluence

  5. Install app again via Marketplace