Confluence backup Fail

[Tony Montana]

Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: com.atlassian.confluence.internal.relations.dao.User2ContentRelationEntity

Why in this problem? Thanks for answers!

[NotTheRealStephenSifersNOPENOPENOPENOPE · Accepted solution]

Are you attempting to restore/import a Confluence backup?

Is you current Confluence version an exact match to the version you are attempting to reestore/import?

Are you attempting to overwrite an existing Confluence instance with your restore/import?

[Tony Montana]

Hi!

1. Space backup

2. Nope

3.  Space backup

[Nic Brough -Adaptavist-]

I think Stephen has found it - when you're doing import/export, the systems need to be relatively close to each other in terms of versions.

I can see it attempting to upgrade your data in the logs, but it's not able to do all of it, and is choking on a table.

You should import your data on to the same version of Confluence and then upgrade it to the target version, and re-export it.  (Or upgrade the source version to match the target)

[NotTheRealStephenSifersNOPENOPENOPENOPE]

Looks like this matches your error:

https://jira.atlassian.com/browse/CONFSERVER-27600

[Tony Montana]

if honory, i don't know. May be this problem with Internal DB?

[Abhishek Kapoor]

HI,

I am facing the same issue, do we have a workaround or resolution for this?

Regards

Abhi

[Tony Montana]

2017-06-06 12:16:12,104 WARN [http-bio-80-exec-4] [atlassian.confluence.cache.TransactionalCacheFactory] warning Transactional cache update outside transaction. All updates to this cache should be performed from a thread with a valid transaction context.
 -- url: /rest/stp/1.0/license/status | userName: admin | referer: http://bacenter.sam-solutions.net/admin/restore-local-file.action
2017-06-06 12:23:06,399 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494345. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,415 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494345. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,415 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494345. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,446 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494349. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,446 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494349. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494349. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494347. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494347. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494347. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494353. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494353. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494353. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494351. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494351. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494351. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494358. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494358. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494358. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494356. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494356. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494356. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'hibernateVersion' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494361. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'lowerTitle' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494361. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,462 WARN [Long running task: Importing data] [importexport.xmlimport.persister.ReflectiveObjectPersister] getPropertyValue Unable to set property 'contentProperties' on instance of 'class com.atlassian.confluence.pages.Page' with id 54494361. This is probably due to internal data structure changes and doesn't cause any data loss.
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,477 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.internal.relations.dao.User2ContentRelationEntity] [Id[id]=56492295, Property[targetContent]=com.atlassian.confluence.pages.Page[Id[id]=56394236], Property[sourceContent]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=4028f06842037f000142037fb0280059], Property[targetType]=com.atlassian.confluence.internal.relations.RelatableEntityTypeEnum[PAGE], Property[relationName]=collaborator, Property[creationDate]=2017-03-19 20:58:22.000, Property[lastModificationDate]=2017-03-19 20:58:22.000, Property[creator]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=4028f06842037f000142037fb0280059], Property[lastModifier]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=4028f06842037f000142037fb0280059]]
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
2017-06-06 12:23:06,477 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: 
 -- url: /admin/restore-local-file.action | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action | action: restore-local-file
com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: com.atlassian.confluence.internal.relations.dao.User2ContentRelationEntity
 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:76)

[Tony Montana]

2017-06-06 12:03:43,969 INFO [read-only-transaction:thread-1] [atlassian.confluence.user.DefaultUserAccessor] getUserNamesWithConfluenceAccess Could not find group configured with USE permission: null
2017-06-06 12:03:45,735 WARN [http-bio-80-exec-18] [atlassian.confluence.cache.TransactionalCacheFactory] warning Transactional cache update outside transaction. All updates to this cache should be performed from a thread with a valid transaction context.
 -- url: /pages/viewpage.action | userName: admin | referer: http://bacenter.sam-solutions.net/login.action?os_destination=%2Fpages%2Fviewpage.action%3FpageId%3D1114147
2017-06-06 12:03:47,438 WARN [http-bio-80-exec-18] [atlassian.confluence.cache.TransactionalCacheFactory] warning Transactional cache update outside transaction. All updates to this cache should be performed from a thread with a valid transaction context.
 -- url: /rest/stp/1.0/license/status | userName: admin | referer: http://bacenter.sam-solutions.net/pages/viewpage.action?pageId=1114147
2017-06-06 12:15:34,274 WARN [http-bio-80-exec-19] [atlassian.confluence.cache.TransactionalCacheFactory] warning Transactional cache update outside transaction. All updates to this cache should be performed from a thread with a valid transaction context.
 -- url: /rest/stp/1.0/license/status | userName: admin | referer: http://bacenter.sam-solutions.net/admin/viewgeneralconfig.action
2017-06-06 12:15:56,416 WARN [http-bio-80-exec-18] [atlassian.confluence.cache.TransactionalCacheFactory] warning Transactional cache update outside transaction. All updates to this cache should be performed from a thread with a valid transaction context.
 -- url: /rest/stp/1.0/license/status | userName: admin | referer: http://bacenter.sam-solutions.net/admin/backup.action
2017-06-06 12:16:11,463 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: Checking...
2017-06-06 12:16:11,479 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: 4984 Upgrade task "Upgrade to build number: 4984" - Ok
2017-06-06 12:16:11,479 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: 4950 Upgrade task "Upgrade to build number: 4950" - Ok
2017-06-06 12:16:11,479 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: 4937 Upgrade task "Reindexes all PersonalInformation objects, creating them for any users that do not have one." - Ok
2017-06-06 12:16:11,479 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: 4526 Upgrade task "Remove the legacy remotable apps plugin from the user installed plugins" - Ok
2017-06-06 12:16:11,479 INFO [http-bio-80-exec-19] [atlassian.confluence.upgrade.AbstractUpgradeManager] getOldestSpaceImportAllowed Compatibility of Space Import: 4517 Upgrade task "Migrate all Page Templates using a storage format round-trip conversion" prevents importing
2017-06-06 12:16:11,495 INFO [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Beginning import by user admin