Can't backup Confluence

[Roger Schmidlin]

I get the following errors when I try to back up confluence from the admin panel. Confluence runs fine on a windows server 2008 R2.

The following error(s) occurred:

• com.atlassian.confluence.importexport.ImportExportException: java.lang.RuntimeException: Could not read fields for table AO_563AEE_ACTIVITY_ENTITY at com.atlassian.activeobjects.confluence.backup.ActiveObjectsBackupRestoreProvider.backup(ActiveObjectsBackupRestoreProvider.java:27) at com.atlassian.confluence.importexport.impl.FileXmlExporter.backupPluginData(FileXmlExporter.java:241) at com.atlassian.confluence.importexport.impl.FileXmlExporter.backupEverything(FileXmlExporter.java:112) at com.atlassian.confluence.importexport.impl.AbstractXmlExporter.doExport(AbstractXmlExporter.java:86) at com.atlassian.confluence.importexport.impl.FileXmlExporter.doExport(FileXmlExporter.java:55) at com.atlassian.confluence.importexport.DefaultImportExportManager.exportAs(DefaultImportExportManager.java:105) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy81.exportAs(Unknown Source) at com.atlassian.confluence.importexport.actions.BackupAction.execute(BackupAction.java:65) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:64) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100) at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.interceptors.CaptchaInterceptor.intercept(CaptchaInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.validation.MessageHolderInterceptor.intercept(MessageHolderInterceptor.java:42) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:49) at

[HuseinA · Accepted solution]

It seems that Confluence isn't able to backup/read data from this table: AO_563AEE_ACTIVITY_ENTITY, which doesn't look like a table that should exist in Confluence database, but JIRA database. Perhaps Confluence was somehow installed in the same database with JIRA, which is a big no no.

For reference, here is a table list of a fresh Confluence 4.3.1 database:

mysql> show tables;
+----------------------------+
| Tables_in_conf43           |
+----------------------------+
| AO_9412A1_AONOTIFICATION   |
| AO_9412A1_AOREGISTRATION   |
| AO_9412A1_AOTASK           |
| AO_9412A1_AOUSER           |
| AO_9412A1_USER_APP_LINK    |
| ATTACHMENTDATA             |
| ATTACHMENTS                |
| BANDANA                    |
| BODYCONTENT                |
| CLUSTERSAFETY              |
| CONFANCESTORS              |
| CONFVERSION                |
| CONTENT                    |
| CONTENTPROPERTIES          |
| CONTENT_LABEL              |
| CONTENT_PERM               |
| CONTENT_PERM_SET           |
| DECORATOR                  |
| EXTRNLNKS                  |
| FOLLOW_CONNECTIONS         |
| IMAGEDETAILS               |
| INDEXQUEUEENTRIES          |
| KEYSTORE                   |
| LABEL                      |
| LIKES                      |
| LINKS                      |
| NOTIFICATIONS              |
| OS_PROPERTYENTRY           |
| PAGETEMPLATES              |
| PLUGINDATA                 |
| SPACEGROUPPERMISSIONS      |
| SPACEGROUPS                |
| SPACEPERMISSIONS           |
| SPACES                     |
| TRACKBACKLINKS             |
| TRUSTEDAPP                 |
| TRUSTEDAPPRESTRICTION      |
| cwd_app_dir_group_mapping  |
| cwd_app_dir_mapping        |
| cwd_app_dir_operation      |
| cwd_application            |
| cwd_application_address    |
| cwd_application_attribute  |
| cwd_directory              |
| cwd_directory_attribute    |
| cwd_directory_operation    |
| cwd_group                  |
| cwd_group_attribute        |
| cwd_membership             |
| cwd_user                   |
| cwd_user_attribute         |
| cwd_user_credential_record |
| external_entities          |
| external_members           |
| groups                     |
| hibernate_unique_key       |
| local_members              |
| logininfo                  |
| os_group                   |
| os_user                    |
| os_user_group              |
| remembermetoken            |
| users                      |
+----------------------------+
63 rows in set (0.00 sec)

While the following is list of tables of JIRA 5.1.5 (with GreenHopper installed) database:

mysql> show tables;
+------------------------------+
| Tables_in_jira515            |
+------------------------------+
| AO_563AEE_ACTIVITY_ENTITY    |
| AO_563AEE_ACTOR_ENTITY       |
| AO_563AEE_MEDIA_LINK_ENTITY  |
| AO_563AEE_OBJECT_ENTITY      |
| AO_563AEE_TARGET_ENTITY      |
| AO_60DB71_CARDCOLOR          |
| AO_60DB71_COLUMN             |
| AO_60DB71_COLUMNSTATUS       |
| AO_60DB71_DETAILVIEWFIELD    |
| AO_60DB71_ESTIMATESTATISTIC  |
| AO_60DB71_ISSUERANKING       |
| AO_60DB71_ISSUERANKINGLOG    |
| AO_60DB71_QUICKFILTER        |
| AO_60DB71_RANKABLEOBJECT     |
| AO_60DB71_RANK_ISSUE_LINK    |
| AO_60DB71_RAPIDVIEW          |
| AO_60DB71_SPRINT             |
| AO_60DB71_SPRINTMARKER       |
| AO_60DB71_STATSFIELD         |
| AO_60DB71_SUBQUERY           |
| AO_60DB71_SWIMLANE           |
| AO_60DB71_TRACKINGSTATISTIC  |
| OS_CURRENTSTEP               |
| OS_CURRENTSTEP_PREV          |
| OS_HISTORYSTEP               |
| OS_HISTORYSTEP_PREV          |
| OS_WFENTRY                   |
| SEQUENCE_VALUE_ITEM          |
| avatar                       |
| changegroup                  |
| changeitem                   |
| columnlayout                 |
| columnlayoutitem             |
| component                    |
| configurationcontext         |
| customfield                  |
| customfieldoption            |
| customfieldvalue             |
| cwd_application              |
| cwd_application_address      |
| cwd_directory                |
| cwd_directory_attribute      |
| cwd_directory_operation      |
| cwd_group                    |
| cwd_group_attributes         |
| cwd_membership               |
| cwd_user                     |
| cwd_user_attributes          |
| draftworkflowscheme          |
| draftworkflowschemeentity    |
| external_entities            |
| externalgadget               |
| favouriteassociations        |
| fieldconfigscheme            |
| fieldconfigschemeissuetype   |
| fieldconfiguration           |
| fieldlayout                  |
| fieldlayoutitem              |
| fieldlayoutscheme            |
| fieldlayoutschemeassociation |
| fieldlayoutschemeentity      |
| fieldscreen                  |
| fieldscreenlayoutitem        |
| fieldscreenscheme            |
| fieldscreenschemeitem        |
| fieldscreentab               |
| fileattachment               |
| filtersubscription           |
| gadgetuserpreference         |
| genericconfiguration         |
| groupbase                    |
| issuelink                    |
| issuelinktype                |
| issuesecurityscheme          |
| issuestatus                  |
| issuetype                    |
| issuetypescreenscheme        |
| issuetypescreenschemeentity  |
| jiraaction                   |
| jiradraftworkflows           |
| jiraeventtype                |
| jiraissue                    |
| jiraperms                    |
| jiraworkflows                |
| label                        |
| listenerconfig               |
| mailserver                   |
| membershipbase               |
| nodeassociation              |
| notification                 |
| notificationinstance         |
| notificationscheme           |
| oauthconsumer                |
| oauthconsumertoken           |
| oauthspconsumer              |
| oauthsptoken                 |
| optionconfiguration          |
| permissionscheme             |
| pluginversion                |
| portalpage                   |
| portletconfiguration         |
| priority                     |
| project                      |
| projectcategory              |
| projectrole                  |
| projectroleactor             |
| projectversion               |
| propertydata                 |
| propertydate                 |
| propertydecimal              |
| propertyentry                |
| propertynumber               |
| propertystring               |
| propertytext                 |
| qrtz_calendars               |
| qrtz_cron_triggers           |
| qrtz_fired_triggers          |
| qrtz_job_details             |
| qrtz_job_listeners           |
| qrtz_simple_triggers         |
| qrtz_trigger_listeners       |
| qrtz_triggers                |
| remembermetoken              |
| remotelink                   |
| resolution                   |
| schemeissuesecurities        |
| schemeissuesecuritylevels    |
| schemepermissions            |
| searchrequest                |
| serviceconfig                |
| sharepermissions             |
| trackback_ping               |
| trustedapp                   |
| upgradehistory               |
| upgradeversionhistory        |
| userassociation              |
| userbase                     |
| userhistoryitem              |
| versioncontrol               |
| votehistory                  |
| workflowscheme               |
| workflowschemeentity         |
| worklog                      |
+------------------------------+
143 rows in set (0.00 sec)