Migration failed at 90% in Jira Software

Question

Getting error while importing the XML file into New Jira server.

Currunttly we are using with H2 in memory database.

Following below link for migration:

https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html#Switchingdatabases-differenttype

2018-06-18 16:17:21,842 JiraImportTaskExecutionThread-1 ERROR it.systems 975x223x1 1wqy6by 10.0.1.1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin AIM Resource Management Plugin for JIRA(net.naomi.jira.jira-rp) #1.5.37 (table AO_69D057_FILTER_COPY_2039_14):Error executing update for SQL statement 'CREATE TABLE AO_69D057_FILTER_COPY_2039_14 (
BOARD_ID LONGTEXT,
CONTAINS_PROJECT BOOLEAN,
FILTER_NAME LONGTEXT,
ID INTEGER AUTO_INCREMENT,
MAPPED_RESOURCE_ID INTEGER,
PROJECT_FILTER LONGTEXT,
RESOURCE_DISPLAY_NAME LONGTEXT,
RESOURCE_FILTER LONGTEXT,
RESOURCE_ID VARCHAR(255),
SHARED BOOLEAN,
) ENGINE=InnoDB'

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB' at line 12

2018-06-18 16:17:21,863 JiraImportTaskExecutionThread-1 WARN it.systems 975x223x1 1wqy6by 10.0.1.1 /secure/admin/XmlRestore.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2018-06-18 16:17:21,868 JiraImportTaskExecutionThread-1 INFO it.systems 975x223x1 1wqy6by 10.0.1.1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
2018-06-18 16:17:21,868 JiraImportTaskExecutionThread-1 INFO it.systems 975x223x1 1wqy6by 10.0.1.1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.7.21
- minor version:7
- major version:5
Driver:
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.AO_D9F874_AIO_USER' doesn't exist

harshshah_crest · Answer

Updated the  /etc/my.cnf

Add below line into file.

lower_case_table_names = 2

https://stackoverflow.com/questions/8550789/where-to-change-the-value-of-lower-case-table-names-2-on-windows-xampp

Still facing the same issue.

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin AIM Resource Management Plugin for JIRA(net.naomi.jira.jira-rp) #1.5.37 (table AO_69D057_FILTER_COPY_2039_14):Error executing update for SQL statement 'CREATE TABLE AO_69D057_FILTER_COPY_2039_14 (
BOARD_ID LONGTEXT,
CONTAINS_PROJECT BOOLEAN,
FILTER_NAME LONGTEXT,
ID INTEGER AUTO_INCREMENT,
MAPPED_RESOURCE_ID INTEGER,
PROJECT_FILTER LONGTEXT,
RESOURCE_DISPLAY_NAME LONGTEXT,
RESOURCE_FILTER LONGTEXT,
RESOURCE_ID VARCHAR(255),
SHARED BOOLEAN,
) ENGINE=InnoDB'
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46)
at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)
at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:73)
at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:57)
at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50)
at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:44)
at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:69)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:151)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:577)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:751)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:60)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB' at line 12

Yogesh Mude_u145qk · Answer

HI @harshshah_crest

Please see the below article will help you to solve this error.

https://confluence.atlassian.com/fishkb/table-xxx-doesn-t-exist-error-with-mysql-server-302810019.html