Data import

[Karim Belhadj]

Hello team 

After configuring my local jira instance with Mysql , i would like to import data witch i did the backup from the H2 database , now when i try to importing data from the folder import:

the path : C:\Program Files\Atlassian\Application Data\JIRA\import\backupdata.zip

First it start to import then , an error appear :

this is my log: 

java.lang.IllegalStateException: java.io.IOException: Le chemin dӡcc鳠spꤩfi顥st introuvable
at net.java.ao.db.FileSystemUtils$1.get(FileSystemUtils.java:36)
at net.java.ao.db.FileSystemUtils$1.get(FileSystemUtils.java:22)
at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:125)
at net.java.ao.db.FileSystemUtils.isCaseSensitive(FileSystemUtils.java:42)
at net.java.ao.db.MySQLDatabaseProvider.isCaseSensitive(MySQLDatabaseProvider.java:201)
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getTableNames(DatabaseMetaDataReaderImpl.java:70)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:58)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:992)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:727)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.IOException: Le chemin dӡcc鳠spꤩfi顥st introuvable
at java.io.WinNTFileSystem.createFileExclusively(Native Method)
at java.io.File.createTempFile(File.java:2024)
at java.io.File.createTempFile(File.java:2070)
at net.java.ao.db.FileSystemUtils$1.get(FileSystemUtils.java:25)
... 25 more

Can any one help me !

Regards

[Alexey Matveev]

Hello @Karim Belhadj 

Just write backupdata.zip. Do not provide the absolute path.

[Karim Belhadj]

@Alexey Matveev  thank you very much , but here  i have other problem 

that error : Erreur lors de l'analyse du fichier d'exportation. Votre fichier d'exportation n'est pas valide. Cela peut être dû à un bogue CDATA dans des versions antérieures de JIRA (http://jira.atlassian.com/browse/JRA-4980). L'exception est org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.

regards

[Alexey Matveev]

It means that the backup has the wrong format. How did you take the backup?

[Karim Belhadj]

I go to the export backup it’s an xml backup 

it give a file format .zip this folder include two file 

1. Active...

2entities 

[Alexey Matveev]

What are the versions of Jira from which you take a backup and to which you import the backup?

[Karim Belhadj]

I take the buck up from Jira 8.1 and I import the buck up to Jira 7.13 , i have question it must be the same version ? 

[Alexey Matveev]

I believe that is the reason. You can not import Jira 8 backup to Jira 7

[Karim Belhadj]

@Alexey Matveev  i didi a backup from version 7.13 and i would like to import it in same version 7.13 but the same problem appear really its look  weired 

please this is my log.

2019-04-29 10:57:16,571 JiraImportTaskExecutionThread-1 ERROR anonymous 657x39x1 15g89vv 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error parsing export file: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.parseXmlAndValidateBackupData(DefaultDataImportService.java:390)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:290)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:157)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

regards

[Karim Belhadj]

@Alexey Matveev i need help please.