FogBugz Attachments Are Not Imported
Symptoms
FogBugz importer completes successfully but file attachments are missing. Stacktrace below visible in JIRA logfile:
2010-04-13 09:51:31,751 Thread-23 ERROR mhaderman 591x238x1 fmbnrf - /secure/admin/views/FogBugzImport!import.jspa [web.action.util.DatabaseConnectionBean] SQL Exception accessing data.
java.sql.SQLException: Ambiguous column name 'sFilename'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:276)
at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:260)
at com.atlassian.jira.imports.fogbugz.FogBugzDataBean.getAttachmentsForIssue(FogBugzDataBean.java:116)
at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:623)
at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:133)
at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)
Cause
The FogBugz database schema changed in 5.0.17+
Resolution
Download the patched class file attached to this JRA-13180 https://jira.atlassian.com/secure/attachment/22520/patch_3_10_2_CORRECT.zip and place it under the atlassian-jira/WEB-INF/classes/com/atlassian/jira/imports/fogbugz/transformer directory, then restart JIRA.
Last modified on Feb 26, 2019
Powered by Confluence and Scroll Viewport.