I can't see any data from AIP web interface
This page is about Assets & Inventory Plugin for Jira DC. Using Cloud? Click here.
Symptoms
After upgrading Jira and the Assets and Inventory Plugin (AIP), specifically from version 1.10.5 to a 2.x version, inventories might not be displayed in the AIP interface.
Cause
The issue arises from a change in how AIP manages database tables across different versions. Earlier versions (pre-2.x) used different table name prefixes compared to version 2.x and later. This means your data isn't lost, but the table names have changed.
Atlassian provides activeobjects
to support database operations. Each add-on has its own tables starting with some unique prefixes. For the Assets & Inventory Plugin, it is supposed to be AO_23ADAF_
.
In some clients, also tables with AO_C5D949_
or AO_CA2219_
prefixes may exist. We raised an issue to Atlassian for this problem.
Resolution
To fix the issue, we need to ensure all AIP tables use the correct prefix (AO_23ADAF_
). Here's a step-by-step guide:
Before proceeding, it's crucial to create a full backup of your database. This ensures you can recover your data in case of any unforeseen issues.
Verify Table Prefixes: Use your database management tool to identify tables associated with AIP. Look for tables prefixed with
AO_C5D949_
,AO_CA2219_
, andAO_23ADAF_
.Confirm Data Location: Ensure the tables with the incorrect prefixes (
AO_C5D949_
orAO_CA2219_
) contain data, while the tables with the correct prefix (AO_23ADAF_
) are empty.Drop Empty Tables: If the
AO_23ADAF_
prefixed tables are empty, you can safely drop them.Rename Tables: Rename the tables with incorrect prefixes (
AO_C5D949_
orAO_CA2219_
) to have the correct prefix (AO_23ADAF_
).