-
Bug
-
Resolution: Cannot Reproduce
-
High
-
3.5.3
-
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" :
,
"link" :
,
"value" : {
"sStatus" :
,
"workflowScheme" : "IZfM",
"sStatus (Resolution)" :
},
"projectLead" : {
},
"projectName" : {
},
"projectKey" : {
},
"projectSelection" :
}