Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Shutdown Jira
  2. Connect to you Jira database using your favourite SQL tooling that is also appropriate for the database you have.
  3. (warning) Create a backup of your database!
  4. Once connected locate the table AO_[HASH]_SITE_MAPPING, there should only be a single table that matches this name.
  5. Note the table hash HASH, for example 3FB43F, since we will be needing this
  6. Drop the tables of the new data model, these include: AO_[HASH]3FB43F_SITES, AO_[HASH]3FB43F_JOBS, AO_[HASH]3FB43F_BUILDS, AO_[HASH]3FB43F_TEST_RESULTS, AO_[HASH]3FB43F_CHANGE_SETS, AO_[HASH]3FB43F_ISSUE_LINKS
  7. Next we may need to reset the Active Objects upgrade marker for the plugin. First execute the first query below to see if there is a marker for this Active Objects module. If there is then note the ID and execute the second query as well.

    • SELECT * FROM PROPERTYENTRY WHERE PROPERTY_KEY = 'AO_[HASH]3FB43F_#'

    • UPDATE PROPERTYSTRING SET PROPERTYVALUE = '0' WHERE ID = [ID]

  8. The data model has now been reset, and Jira can be started again.
  9. If the add-on was still installed and enabled, then the upgrade of the model should kick-in automatically, otherwise you can install, or enable, the add-on with Jira to trigger the data model upgrade.

...

Page Properties
hiddentrue


Related issues

Jira
serverSystem JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdf43a7e87-9d3c-3b29-99a0-8a27de7ad1b2
keyJJI-394

Jira
serverSystem JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdf43a7e87-9d3c-3b29-99a0-8a27de7ad1b2
keyMS-21