java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Samuel R. Neff,
  • 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)
    via by Samuel R. Neff,
  • Import from FogBugz Version 8.2.22 (DB 771, Build 1) fails with SQLRuntimeException: Ambiguous column name 'sFileName' It seems like a regression from JIM-34 {noformat} 2011-06-07 23:27:14,909 ERROR - Failed to attach attachments to issue VIC-1176 com.atlassian.jira.plugins.importer.SQLRuntimeException: Ambiguous column name 'sFileName'. at com.atlassian.jira.plugins.importer.web.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:218) at com.atlassian.jira.plugins.importer.web.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:188) at com.atlassian.jira.plugins.importer.imports.fogbugz.FogBugzDataBean.getAttachmentsForIssue(FogBugzDataBean.java:123) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:703) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:624) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:246) 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: Ambiguous column name 'sFileName'. 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.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:203) ... 17 more 2011-06-07 23:27:14,910 INFO - Importing issue number 2 : ExternalIssue{summary=Seats allocated to wrong user during purchase, issueType=1} {noformat}
    via by Bogdan Dziedzic,
  • 更换数据源报错
    via GitHub by mamacmm
    ,
  • getAssetUrl in version 2.6
    via infoglue by jeffkrueger
    ,
  • SQLDiagnostic error
    via jtds by pauer
    ,
    • 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)

    Users with the same issue

    odd
    2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    ruifung
    1 times, last one,
    Unknown visitor1 times, last one,
    24 more bugmates