Uploaded image for project: 'JIRA Importers Plugin'
  1. JIRA Importers Plugin
  2. JIM-680

Fogbugz Import from Version 8.6.50 failed

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: High High
    • 4.2
    • 3.5.3
    • FogBugz
    • Fogbugz: Win2003R2, SQLExpress
      Atlassian JIRA(v4.4.4#664-r167664) Win2k8R2, SQL2008

      Error from JIRA: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state

      ----------------------------------------------------------------------------------------------
      Logfile:
      ----------------------------------------------------------------------------------------------
      2012-02-16 10:21:12,736 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.fogbugz.FogBugzDataBean
      2012-02-16 10:21:12,751 INFO - ------------------------------
      2012-02-16 10:21:12,751 INFO - Importing: Users
      2012-02-16 10:21:12,751 INFO - ------------------------------
      2012-02-16 10:21:12,751 INFO - Only new items will be imported
      2012-02-16 10:21:12,892 INFO - 32 users associated with import.
      2012-02-16 10:21:13,095 INFO - Imported user Alf Burghardt (aburghardt)
      2012-02-16 10:21:13,189 INFO - Imported user Erwin Sauter (esauter)
      2012-02-16 10:21:13,267 INFO - Imported user Exxcellent (exxcellent)
      2012-02-16 10:21:13,377 INFO - Imported user G�nther Hafner (ghafner)
      2012-02-16 10:21:13,502 INFO - Imported user Martin Wimmer (mwimmer)
      2012-02-16 10:21:13,595 INFO - Imported user Roland Fr�wis (rfr�wis)
      2012-02-16 10:21:13,674 INFO - Imported user Sourish Halder (shalder)
      2012-02-16 10:21:13,799 INFO - Imported user Thomas Hassler (thassler)
      2012-02-16 10:21:13,877 INFO - Imported user Volker Manusch (vmanusch)
      2012-02-16 10:21:13,877 INFO - ------------------------------
      2012-02-16 10:21:13,877 INFO - Finished Importing : Users
      2012-02-16 10:21:13,877 INFO - ------------------------------
      2012-02-16 10:21:13,877 INFO - 9 users successfully created.
      2012-02-16 10:21:13,877 INFO - Retrieving custom fields...
      2012-02-16 10:21:13,877 INFO - Retrieving projects...
      2012-02-16 10:21:13,877 INFO - ------------------------------
      2012-02-16 10:21:13,877 INFO - Importing: Issues
      2012-02-16 10:21:13,877 INFO - ------------------------------
      2012-02-16 10:21:13,877 INFO - Only new items will be imported
      2012-02-16 10:21:13,955 INFO - ------------------------------
      2012-02-16 10:21:13,955 INFO - Finished Importing : Issues
      2012-02-16 10:21:13,955 INFO - ------------------------------
      2012-02-16 10:21:13,955 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state
      com.atlassian.jira.plugins.importer.SQLRuntimeException: Incorrect syntax near ')'.
      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:295)
      at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25)
      at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14)
      at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
      at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
      at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: java.sql.SQLException: Incorrect syntax near ')'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
      at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:778)
      at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162)
      ... 15 more
      2012-02-16 10:21:13,955 INFO - No issues need to be reindexed.

      ----------------------------------------------------------------------------------------------
      Configuration:
      ----------------------------------------------------------------------------------------------
      {
      "field" :

      { "sCustomerEmail" : "Customer Email", "sComputer" : "Computer" }

      ,
      "link" :

      { "Duplicates" : "Duplicate", "See also" : "Relates", "Parent / Subcase" : "Relates" }

      ,
      "value" : {
      "sStatus" :

      { "Closed" : "6", "Aktiv" : "4", "Gelöst" : "4" }

      ,
      "workflowScheme" : "IZfM",
      "sStatus (Resolution)" :

      { "existiert bereits" : "3", "beantwortet" : "4", "auf Rückmeldung wartend" : "4", "mit Absicht" : "2", "wird nicht implementiert" : "2", "wird nicht beantwortet" : "2", "abgeschlossen" : "1", "SPAM" : "2", "behoben" : "1", "Duplikat" : "4", "wird nicht behoben" : "2", "nicht reproduzierbar" : "4", "implementiert" : "1", "gestrichen" : "2", "verschoben" : "4" }

      },
      "projectLead" : {
      },
      "projectName" : {
      },
      "projectKey" : {
      },
      "projectSelection" :

      { "PiWeb" : "true", "IT-Probleme" : "true", "Sample Project" : "true", "Involute" : "true", "Blade Pro" : "true", "Lasercal" : "true", "ScanWare" : "true", "Inbox" : "true" }

      }

              Unassigned Unassigned
              Anonymous Anonymous
              Archiver:
              dnorton@atlassian.com Dave Norton

                Created:
                Updated:
                Resolved:
                Archived: