Cannot Restore XML Backup due to Database Encoding

Still need help?

The Atlassian Community is here for you.

Ask the community

Unable to render {include} The included page could not be found.

Symptoms

When importing an XML backup, the following messages appear in the logs:


ERROR [Importing data task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '295213' for key 1
- url: /setup/setup-restore.action \| userName: anonymous \| action: setup-restore

ERROR [Importing data task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Incorrect string value: '\xEF\x81\xA9 No...' for column 'BODY' at row 1
- url: /setup/setup-restore.action | userName: anonymous | action: setup-restore

Cause

The database is not set to the correct encoding.

Resolution

Make sure your database is using the correct encoding. Follow the guide Configuring Database Character Encoding. Confirm that the database is set to UTF-8.


Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.