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

Atlassian JIRA | Samuel R. Neff | 9 years ago
  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 | 9 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 | 9 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 | 5 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 | 4 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 3 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