Migration from onpremise to cloud problems (backup)

Hi Team,

 

I am trying to switch over from my own server to cloud. I thought doing an export/import would do the trick, but unfortunately I ran into the old backup problem (which I worked around by doing a backup on server-based tools like database- and file backup).

Clicking "backup" on the backup and recovery page, I get the error:

 

javax.servlet.ServletException: Servlet execution threw an exception
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:315)

caused by: java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter
    at com.atlassian.dbexporter.node.stax.StaxStreamWriter$1.setContentAsBinary(StaxStreamWriter.java:108)

I experienced that on several version, here: 6.3.4 build 7202

Linux 3.16.0-4-amd64

Apache Tomcat/8.0.43

Java 1.8.0_131

 

What can i do?

 

BR

Axel

2 answers

Hi Axel, Are you doing this backup from the latest updated copy of JIRA? Your server should be updated to JIRA 7.5.X prior to performing the migration to Cloud: https://confluence.atlassian.com/jirakb/migrating-from-jira-server-to-jira-cloud-779160826.html.

For the specific problem above, I think this article in the Knowledgebase will help: https://confluence.atlassian.com/jirakb/jira-xml-backup-fails-throws-java-lang-noclassdeffounderror-javax-xml-bind-datatypeconverter-895910465.html 

Sorry, no problem at all, this affects Confluence, not JIRA. Sorry for the mistake... just opened an new thread.

0 votes

Hi Axel,

As Michael mentioned, before migrating from a Server instance to a Cloud instance, we always recommend that you're on the most recent version. Have a look at Confluence Server to Confluence Cloud documentation for the full set of instructions. However, your version of Confluence is still new enough that it may be possible.

 

Now as far as your error goes, it is caused by this problem: Cannot create XML backup due to "Could not read fields for table" Unknown ActiveObjects Table. Please have a look at the diagnosis in order to determine which table it is you need to remove.

Let me know if you run into any further issues or have any questions!

Kind Regards,
Shannon

Hi Shannon,

 

thanks for your reply. Concerning the XML error I have to state that is it not possible to DROP the table, because it does not exist. If found in the log:

2017-10-11 08:42:09,092 INFO [http-nio-8090-exec-1] [activeobjects.confluence.backup.LoggingBackupProgressMonitor] beginTableBackup Begin backup for table : AO_DCA036_ENCRYPTION_KEY
2017-10-11 08:42:09,094 WARN [http-nio-8090-exec-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
  ->[null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1053197317)
        Showing 10 last transactions at this level out of 192 in total:
        [com.atlassian.confluence.upgrade.upgradetask.EmbeddedCrowdAddMissingConstraintsUpgradeTask.getShortDescription]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1906139359)
        [com.atlassian.confluence.upgrade.upgradetask.EmbeddedCrowdAddMissingConstraintsClearDataUpgradeTask.breaksBackwardCompatibility]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1285352114)
        [com.atlassian.confluence.upgrade.upgradetask.EmbeddedCrowdAddMissingConstraintsClearDataUpgradeTask.getBuildNumber]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #2042684925)
        [com.atlassian.confluence.upgrade.upgradetask.EmbeddedCrowdAddMissingConstraintsClearDataUpgradeTask.getShortDescription]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #2057451761)
        [com.atlassian.confluence.upgrade.upgradetask.AttachmentRemoveFileStoreIDsUpgradeTask.breaksBackwardCompatibility]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1690586835)
        [com.atlassian.confluence.upgrade.upgradetask.AttachmentRemoveFileStoreIDsUpgradeTask.getBuildNumber]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1144197179)
        [com.atlassian.confluence.upgrade.upgradetask.AttachmentRemoveFileStoreIDsUpgradeTask.getShortDescription]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #883502164)
        [com.atlassian.confluence.upgrade.upgradetask.ContentIndexUpgradeTask.breaksBackwardCompatibility]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1479694419)
        [com.atlassian.confluence.upgrade.upgradetask.ContentIndexUpgradeTask.getBuildNumber]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #495945907)
        [com.atlassian.confluence.upgrade.upgradetask.ContentIndexUpgradeTask.getShortDescription]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1463822182)
 -- url: /confluence/admin/dobackup.action | traceId: d141a006b7b3ce77 | userName: (REMOVEDFORPRIVACYREASONS)| referer: (REMOVEDFORPRIVACYREASONS)
2017-10-11 08:42:09,096 ERROR [http-nio-8090-exec-1] [[Standalone].[localhost].[/confluence].[action]] log Servlet.service() for servlet [action] in context with path [/confluence] threw exception [Servlet execution threw an exception] with root cause
java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter

Entering postgresql and trying to drop the table psql tells me it does not exist:

postgres=# DROP TABLE "AO_DCA036_ENCRYPTION_KEY";
FEHLER:  Tabelle »AO_DCA036_ENCRYPTION_KEY« existiert nicht

 

How can I succeed?

 

BR

Axel

Hi Axel,

That is odd, because it does appear the table is there due to the errors.

Can you be sure you're in the correct database? I have another customer I found that received the same error about that exact table not existing, but tried again using the command on the correct table, and was able to drop it.

DROP TABLE "AO_DCA036_ENCRYPTION_KEY";


Kind Regards,
Shannon

Thanks Shannon,

not being familiar with SQl (and almost absolutely not with postgresql) I totally missed to change to the dabase. Sorry for that! Worked now! Result:

Backup done, request finished. Thanks a lot, close and forget. :) I documented that (hihi, in confluence). For whom it may help (linux debian with postgresql:

less /var/atlassian/application-data/confluence/logs/atlassian-confluence.log
(search for beginDatabaseInformationBackup)
(search for ERROR)
(go some lines upwards, to find the last table before the error)
sudo -H -u postgres psql
\l
\c confluence
DROP TABLE "AO_DCA036_ENCRYPTION_KEY";
\q

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,005 views 14 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you