/
I can't see any data from AIP web interface

I can't see any data from AIP web interface

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.

  1. Verify Table Prefixes: Use your database management tool to identify tables associated with AIP. Look for tables prefixed with AO_C5D949_, AO_CA2219_, and AO_23ADAF_.

  2. Confirm Data Location: Ensure the tables with the incorrect prefixes (AO_C5D949_ or AO_CA2219_) contain data, while the tables with the correct prefix (AO_23ADAF_) are empty.

  3. Drop Empty Tables: If the AO_23ADAF_ prefixed tables are empty, you can safely drop them.

  4. Rename Tables: Rename the tables with incorrect prefixes (AO_C5D949_ or AO_CA2219_) to have the correct prefix (AO_23ADAF_).