Help to identify AO tables.

[Malik Mangier]

Hi,

Our XML export is failing:

root cause java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter not found by com.atlassian.activeobjects.activeobjects-plugin [17]

 So we ran the query:

SELECT TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS where table_name like 'AO_%' and data_type = 'blob';

that gave us

+--------------+---------------------------+-------------+-----------+
| TABLE_SCHEMA | TABLE_NAME                | COLUMN_NAME | DATA_TYPE |
+--------------+---------------------------+-------------+-----------+
| confluence   | AO_47A562_TEMPLATE_STORE  | CONTENT     | blob      |
| confluence   | AO_6B83C6_MSCGEN_IMAGE_DB | DATA        | blob      |
| confluence   | AO_6B83C6_MSCGEN_IMAGE_DB | MACRO_DATA  | blob      |
| confluence   | AO_8066FB_TEMPLATE_STORE  | CONTENT     | blob      |
+--------------+---------------------------+-------------+-----------+

The mscgen is an add-on from addteq that is no longer supported on Server so we'll remove that ok.

But does anyone know what apps/add-ons/plugins would AO_47A562_TEMPLATE_STORE and AO_8066FB_TEMPLATE_STORE be associated with maybe ?

Thanks!

[Malik Mangier · Accepted solution]

Actually this nice article explains it clearly: https://<your-confluence-site>/plugins/servlet/active-objects/tables/list

In our case those tables where not tied to specific apps because they had been removed. So we simply dropped those tables, especially since they were empty.

We also wrote again all the confluence pages that were using the mscgen macro to not use it anymore, removed the mscgen app and dropped the table.

Then we could do the XML export as expected

[Rick Carini]

Yeah, I wish this still worked:

From: https://confluence.atlassian.com/confkb/list-of-confluence-server-data-center-active-objects-ao-table-names-and-vendors-1155154024.html

• CONFSERVER-66530 - Plugin Data Storage does not display data 

but the link, does have some of the major plugins listed.