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

SQLException in FogBugz import: Ambiguous column name 'sFileName'

    XMLWordPrintable

Details

    Description

      After running FogBugz import I have thousands of these errors in my logs:

      2007-07-26 08:58:39,812 Thread-31 INFO [imports.importer.impl.ImportLogger] Created Resolution : Responded with id 6 (42.266s)
      2007-07-26 08:58:39,968 Thread-31 INFO [imports.importer.impl.DefaultJiraDataImporter] Successfully imported issue 1 (1 unindexed issues): Issue

      {summary=test, type=6}

      2007-07-26 08:58:40,234 Thread-31 ERROR [web.action.util.DatabaseConnectionBean] SQL Exception accessing data.
      java.sql.SQLException: Ambiguous column name 'sFileName'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
      at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
      at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:268)
      at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:252)
      at com.atlassian.jira.imports.fogbugz.FogBugzDataBean.getAttachmentsForIssue(FogBugzDataBean.java:106)
      at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:581)
      at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:120)
      at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              a25448a3640c Samuel R. Neff
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7h
                  7h