Confluence backup Fail

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!

3 answers

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
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)
0 vote
Stephen Sifers Community Champion Jun 06, 2017

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?

Hi!

1. Space backup

2. Nope

3.  Space backup

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)

Stephen Sifers Community Champion Jun 06, 2017

Looks like this matches your error:

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

 

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 4 hours ago in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

16 views 0 3
Read article

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