Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-36148

Unexpected failure occurred while migrating bugs from Fogbugz

    XMLWordPrintable

Details

    • Support Request
    • Resolution: Support Request
    • Low
    • None
    • 6.0.8
    • None

    Description

      Hi there,

      When I try to use an existing configuration file to migrate bugs from Fogbugs into Jira I get the following error:

      Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state

      The log says:

      2013-12-10 17:16:28,888 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state
      com.atlassian.jira.plugins.importer.SQLRuntimeException: 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 ')' at line 1
      	at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177)
      	at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146)
      	at com.atlassian.jira.plugins.importer.imports.fogbugz.FogBugzDataBean.getTotalIssues(FogBugzDataBean.java:96)
      	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:408)
      	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
      	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
      	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365)
      	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      	at java.util.concurrent.FutureTask.run(Unknown Source)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      	at java.util.concurrent.FutureTask.run(Unknown Source)
      	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)
      	at java.lang.Thread.run(Unknown Source)
      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 ')' at line 1
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      	at java.lang.reflect.Constructor.newInstance(Unknown Source)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.Util.getInstance(Util.java:386)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
      	at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162)
      	... 13 more
      2013-12-10 17:16:28,943 INFO - No issues need to be reindexed.
      

      This appears when I save the configuration file for one project, but want to import bugs from another project using the same config file (which doesn't seem to be a highly unlikely scenario).

      I can of course carry on with the migration not using a previously saved file, but this is makes the feature a bit useless.

      Currently we're using v 6.0.23 of JIRA Importers Plugin (JIM).

      Kind regards

      Marcin

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              f6b756d5-6eb8-406d-a6d5-34316c320586 Deleted Account (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: