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:

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

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

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