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"

Atlassian JIRA | Jing Hwa [Atlassian] | 1 year ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    h3. Summary Backup created from Cloud instance cannot be restore if it contains audit logs h3.Step to replicate: # Ensure that there are entries in the [Audit log|https://confluence.atlassian.com/confcloud/audit-log-802164269.html]. If there is no entries in the audit logs, try to make some modication to the user to create a few entries. # Create a backup from Cloud # Restore the backup to the latest OD version 6.0.0-OD-2016.06.1-0009 h3. Expected Result The backup successfully restore. h3. Observed Result The backup fail to restored with error similar to the following: {code} 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) {code} The issue seem to be cause by entries from {{auditrecord}} table. h3. Workaround 1 Manually delete all the object related to {{com.atlassian.confluence.impl.audit}} package from the entities.xml in the backup h3.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

    Atlassian JIRA | 1 year ago | Jing Hwa [Atlassian]
    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"
  2. 0

    h3. Summary Backup created from Cloud instance cannot be restore if it contains audit logs h3.Step to replicate: # Ensure that there are entries in the [Audit log|https://confluence.atlassian.com/confcloud/audit-log-802164269.html]. If there is no entries in the audit logs, try to make some modication to the user to create a few entries. # Create a backup from Cloud # Restore the backup to the latest OD version 6.0.0-OD-2016.06.1-0009 h3. Expected Result The backup successfully restore. h3. Observed Result The backup fail to restored with error similar to the following: {code} 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) {code} The issue seem to be cause by entries from {{auditrecord}} table. h3. Workaround 1 Manually delete all the object related to {{com.atlassian.confluence.impl.audit}} package from the entities.xml in the backup h3.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

    Atlassian JIRA | 1 year ago | Jing Hwa [Atlassian]
    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"

    Root Cause Analysis

    1. 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()
    2. com.atlassian.confluence
      BackupImporter.importEntities
      1. com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:400)
      1 frame