Restore from Cloud fails with com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string:

Summary

Backup created from Cloud instance cannot be restore if it contains audit logs

Step to replicate:

1. Ensure that there are entries in the Audit log. If there is no entries in the audit logs, try to make some modication to the user to create a few entries.
2. Create a backup from Cloud
3. Restore the backup to the latest OD version 6.0.0-OD-2016.06.1-0009

Expected Result

The backup successfully restore.

Observed Result

The backup fail to restored with error similar to the following:

2016-02-10 11:29:16,745 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import
 -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | traceId: a172a52c7cd939d9 | userName: admin | action: longrunningtaskxml
com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: For input string: "2016-02-08 19:54:35.123"
	at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:400)

The issue seem to be cause by entries from auditrecord table.

Workaround 1

Manually delete all the object related to com.atlassian.confluence.impl.audit package from the entities.xml in the backup

Workaround 2

Create a support ticket in support.atlassian.com to request our Cloud Support Engineer to create a backup without the data from the following table since they have references against each other:

• audit_affected_object
• audit_changed_value
• auditrecord