Why the error when restore data from xml file

[Сергей Смирнов]

I want to restore Confluence 6.2.3 on test environment.
I create backup file from work instance and try restore in new instance
Show error
"
Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value : com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord.key
"

[Shannon S]

Hi there,

Have you seen the article below? 

• XML import fails due to error: not-null property references a null or transient value

It sounds like it could be related to your issue. There is a fix there for your database.

Have a look and let us know if you have any questions.

Regards,

Shannon

[Сергей Смирнов]

Thank you,  I find empty value in table bandana

"BANDANAID" "BANDANACONTEXT" "BANDANAKEY" "BANDANAVALUE"
"33095682" "LIM-CheckBox.30311241.1" "" "<string>false</string>"

[Shannon S]

Thank you for confirming.

It appears this weekend you were able to remove the record "" and resolve the issue with support. Can you confirm?

Regards,
Shannon

[Сергей Смирнов]

Yes, I confirm