Confluence Docs 3.1 : Troubleshooting XML backups that fail on restore
This page last changed on Feb 04, 2009 by jlargman.
Seeing an error when creating or importing a site or space backup?
Resolve Errors When Attempting To Restore An XML BackupThe errors may be caused by a slightly corrupt database. You will need to find the XML backup file entry that is violating the DB rules, modify the entry and recreate the XML backup:
Troubleshooting "Duplicate Key" related problemsIf you are encountering an error message such as: could not insert: [bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@a70067d3]; SQL []; Violation of PRIMARY KEY constraint 'PK_OS_PROPERTYENTRY314D4EA8'. Cannot insert duplicate key in object 'OS_PROPERTYENTRY'.; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PKOS_PROPERTYENTRY_314D4EA8'. Cannot insert duplicate key in object 'OS_PROPERTYENTRY'. This indicates that the Primary Key constraint 'PK_OS_PROPERTYENTRY_314D4EA8' has duplicate entries in table 'OS_PROPERTYENTRY'. SELECT ENTITY_NAME,ENTITY_ID,ENTITY_KEY,COUNT(*) FROM OS_PROPERTYENTRY GROUP BY ENTITY_NAME,ENTITY_ID,ENTITY_KEY HAVING COUNT(*)>1 Troubleshooting "net.sf.hibernate.PropertyValueException: not-null" related problemsIf you're receiving a message like: ERROR [Importing data task] [confluence.importexport.impl.ReverseDatabinder] endElement net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.user.impl.hibernate.DefaultHibernateUser.name This means there's an unexpected null value in a table. In the above example, the error is in the name column in the USERS table. We've also seen them in the ATTACHMENTS table. Remove the row with the null value, redo the xml export, and reimport. To Help Prevent this Issue from Reccuring
RELATED TOPICSTroubleshooting failed XML site backups |
![]() |
Document generated by Confluence on Dec 10, 2009 18:40 |