How to Identify Active Objects AO Tables in Jira Application Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article explains how you can easily identify the plugin and/or vendor of Active Objects (AO) tables that can be found in the Jira Application Database. There is an related KB of List of Jira Data Center AO table names and vendors where you can find a listing of the most popular plugins and the AO tables they create.
You must have the ability to query your Jira database to make use of this information.
Active Objects tables are used by Jira Applications and plugins to store data. The table prefix can be used to determine what plugin or Jira Application feature the table is used for.
As an example, tables that begin with "AO_54307E" are related to Jira Service Management.
Solution
Active Objects Table Prefixes
Direct database modifications are discouraged and are not supported by Atlassian. Always back up Jira's database before performing any modifications
For a current list of Add-ons and their associated tables specific to your environment you can go to System > Advanced > Plugin Data Storage page in Jira.
You must have the ability to query your Jira database to make use of this information.
Inspect the tables in your Jira database.
All tables with a prefix of "AO" are a table created by a Jira Application.
Compare the table name with the list below to identify which Jira Application uses the table.
Table Prefix | Used by |
|---|---|
AO_54307E | Jira Service Management |
AO_2C4E5C | Jira Service Management - Jira Email Processing Plugin |
AO_9B2E3B | Jira Service Management - Automation |
AO_A415DF | Jira Portfolio (Portfolio for Jira) |
AO_82B313 | Jira Portfolio Team Management |
AO_D9132D | Jira Portfolio Live Plans |
AO_60DB71 | Jira Software (Jira Agile) |
AO_E8B6CC | Jira DVCS Connector (Bitbucket) |
AO_563AEE | Streams Third Party Provider Plugin (com.atlassian.streams.streams-thirdparty-plugin) |
AO_587B34 | Hipchat for Jira |
AO_88263F | Support Healthcheck Plugin |
AO_733371 | Jira Inform (Batched notifications) |
AO_8542F1 | Assets (Insight) |
AO_A415DF | Advanced Roadmaps (Portfolio for Jira) |
Was this helpful?