java.sql.SQLException: Ambiguous column name 'sFileName'.

Atlassian JIRA | Samuel R. Neff | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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)

    Atlassian JIRA | 10 years ago | Samuel R. Neff
    java.sql.SQLException: Ambiguous column name 'sFileName'.
  2. 0

    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)

    Atlassian JIRA | 10 years ago | Samuel R. Neff
    java.sql.SQLException: Ambiguous column name 'sFileName'.
  3. 0

    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}

    Ecosystem JIRA | 6 years ago | Bogdan Dziedzic
    com.atlassian.jira.plugins.importer.SQLRuntimeException: Ambiguous column name 'sFileName'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - Incorrect syntax near the keyword plan

    hibernate.org | 7 months ago
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not load an entity: [com.gisdata.katastarcg.model.Parcel#component[cadastralMunicipalityId,cantonId,number,subNumber]{subNumber=0, number=191, cadastralMunicipalityId=8, cantonId=70}]

  1. ruifung 1 times, last 7 months ago
12 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Ambiguous column name 'sFileName'.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
    5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
    6. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
    6 frames
  3. com.atlassian.jira
    ImporterThread.run
    1. com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:268)
    2. com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:252)
    3. com.atlassian.jira.imports.fogbugz.FogBugzDataBean.getAttachmentsForIssue(FogBugzDataBean.java:106)
    4. com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:581)
    5. com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:120)
    6. com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)
    6 frames