Export/Import a space on a different confluence server

Question

Hello, I have a problem during the import of a specific space on my new confluence server. (It works with some spaces but not all) I export a space from 6.3.3 confluence server to a new (7.0.1) I had this error : 2019-10-29 14:36:37,690 ERROR [Long running task: Importing data] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Incorrect string value: '\xF0\x9F\x98\x8A[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1790338970) -- url: /admin/restore.action | referer: http://server:8090/admin/backup.action | traceId: d4e9c3c47c95379f | userName: cns-local | action: restore 2019-10-29 14:36:37,846 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- url: /admin/restore.action | referer: http://server:8090/admin/backup.action | traceId: d4e9c3c47c95379f | userName: cns-local | action: restore com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not execute statement at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:406) ... at java.lang.Thread.run(Thread.java:748) Caused by: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not execute statement at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImportInternal(DefaultXmlImporter.java:64) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:42) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:398) ... 38 more Caused by: org.xml.sax.SAXException: Error while importing backup: could not execute statement net.sf.hibernate.exception.GenericJDBCException: could not execute statement at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:44) ... at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImportInternal(DefaultXmlImporter.java:51) ... 40 more Caused by: net.sf.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147) .... at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:42) ... 52 more Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8A

Service CNS · Answer

Hello,

Any update ?

Thanks

Regards,

CNS

Service CNS · Answer

Hello @Manisha Kharga _Appfire_

Thanks for you reply.

When I try to export a space I have this error :

URL requested: http://MyserverURL:8090/doauthenticate.action?password=***&authenticate=Confirm&destination=/admin
Request type: GET
Content type: text/html
Response code: 200, message: null, url: http://MyserverURL:8090/admin/console.action
URL requested: http://MyserverURL:8090/admin/restore-local-file.action?localFileName=exportCommXml.zip&edit=Import&buildIndex=true&buildIndexLocalFileRestore=true
Request type: POST
Content type: application/url_encoded
Response code: 200, message: null, url: http://MyserverURL:8090/admin/restore-local-file.action?localFileName=exportCommXml.zip&edit=Import&buildIndex=true&buildIndexLocalFileRestore=true
Long running task: f9dd16c7-4a63-449e-af83-1897bfb4d8ed
URL requested: http://MyserverURL:8090/longrunningtaskxml.action?taskId=f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: text/html
Response code: 200, message: null, url: http://MyserverURL:8090/longrunningtaskxml.action?taskId=f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Restore has been started with taskId f9dd16c7-4a63-449e-af83-1897bfb4d8ed. Task status can be checked at http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed.
URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed

Waiting for task completion: 0% complete. Starting...
URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
.URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed

Waiting for task completion: 1% complete. Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not execute statement.
URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
.URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET
Content type: application/json; charset=utf-8
Response code: 200, message: null, url: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
.URL requested: http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed
Request type: GET

- Content of http://MyserverURL:8090/rest/api/latest/longtask/f9dd16c7-4a63-449e-af83-1897bfb4d8ed :

{"id":"f9dd16c7-4a63-449e-af83-1897bfb4d8ed","name":{"key":"import.data.task.name","args":[]},"elapsedTime":5648,"percentageComplete":1,"successful":false,"messages":[{"translation":"Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not execute statement","args":[]}],"_links":{"base":"http://MyServerURL:8090","context":""}}

Manisha Kharga _Appfire_ · Answer

Hi @Service  CNS ,

To perform this action you can use Bon Swift app Confluence Command Line Interface (CLI)

The CLI actions --exportSpace can export the space from the Source instance and then restore the space using the --restoreExport action on Target instance.

This will also retain the Author details of the source pages, Page history and Attachment history.

./acli.sh --action exportSpace  --space "XXX"  --file "space.zip"

./acli.sh --action restoreExport  --file "space.zip"

Thanks,
Manisha