...
- Shutdown Jira
- Connect to you Jira database using your favourite SQL tooling that is also appropriate for the database you have.
- Create a backup of your database!
- Once connected locate the table
AO_[HASH]_SITE_MAPPING
, there should only be a single table that matches this name. - Note the table hash
HASH
, for example3FB43F
, since we will be needing this - 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
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]
- The data model has now been reset, and Jira can be started again.
- 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 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||
|