Migration from Confluence 4.2 to OnDemand fails

[Nils-Petter Nilsen]

I am currently evaluating Atlassian's OnDemand solution for Jira and Confluence. Moving data to the hosted Jira instance was a breeze; Confluence seems to be a lot worse.

I have tried to follow the instructions:

- Created complete backup w/attachments from old 4.2 instance

- Installed most recent OnDemand version on my laptop, to upgrade the spaces before exporting them

- Attempted restore of the 4.2 backup into the OD version

The restore is where it fails, with the following exception in the Confluence (OD) log: net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.confluence.like.LikeEntity.content

What's worse, it wipes the database on the OD installation before it fails, so the admin user no longer exists. Consequently, it seems I have to do a complete reinstall of the OD instance between each try.

[John Inder [Atlassian] · Accepted solution]

Hi Nils,

The issue here appears to be related to the "Likes" in Confluence, as exhibited by the class being "com.atlassian.confluence.like.LikeEntity.content". However, I have found two bug reports which appear to point to this issue, and in this case it seems to be related to the backups being generated without comments:

https://jira.atlassian.com/browse/CONF-27600
https://jira.atlassian.com/browse/AOD-6274

So, please try creating new backups with the comments included in the backup and see whether the issue reoccurs or not.

All the best,
John

[Nils-Petter Nilsen]

The workaround in https://jira.atlassian.com/browse/CONF-27600 did the trick! That said, I see no option for including comments in backups, only in space exports. Anyway, problem solved, thank you :-)

[Bruna Griebeler]

Hi

Please check if there is an attachment data object which has value NULL in you Confluence database.

If so, you may remove it. But please, do backup on database before making changes to it.
You may check the steps here: Cannot Restore XML Backup due to Null Attachment.

Cheers

[Nils-Petter Nilsen]

Thanks for the suggestion, but I tried that one after Hercules made me aware of it. It's probably a similar problem, but this seems to be related to likes, not attachments.