java.sql.SQLException: Invalid object name 'jiraeventtype'.

Atlassian JIRA | Tim Evans | 2 years ago
  1. 0

    [JRA-39491] Exception thrown during upgrade: Invalid object name 'jiraeventtype' - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: Invalid object name 'jiraeventtype'.
  2. 0

    Error when attempting to upgrade JIRA h4. Symptoms: The following appears in JIRA's logs: {noformat} 2014-08-01 10:33:05,318 main INFO [atlassian.jira.upgrade.UpgradeManagerImpl] Performing Upgrade Task: Insert sequence for event type 2014-08-01 10:33:05,322 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: Invalid object name 'jiraeventtype'. java.sql.SQLException: Invalid object name 'jiraeventtype'. 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:776) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at com.atlassian.jira.upgrade.tasks.util.Sequences.update(Sequences.java:36) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6320.doUpgrade(UpgradeTask_Build6320.java:41) {noformat} h4. Cause: Upgrade tasks that update sequences do not correctly apply schema name to table when the schema is named "jira". This has recently been triggered by an upgrade task in JIRA 6.3, however it's possible it could affect any future upgrade tasks which contain an update to a sequence. h4. Steps to reproduce # Install a version of JIRA earlier than JIRA 6.3 on MS SQL Server, making sure that the schema JIRA is installed in is called "jira", and the default schema of the user JIRA connects to MS SQL Server is something other than "jira", for example "dbo" (which is the default). JIRA actually encounters problems if the default schema is not set to "dbo". # Make sure it's all working fine # Upgrade to 6.3 or above # Watch the atlassian-jira.log file for the error above h4. Workaround: One of the following works around the issue: *Option 1* # Change schema name to something other than "jira". Update the {{dbconfig.xml}} file according to the changes. *Option 2* # Stop JIRA # Change the default schema of the database user JIRA is using to be "jira" # Start JIRA # Allow the uprade task to complete - some things in JIRA will be broken such as the streams plugin # Stop JIRA # Remove the directories <jira-home>/plugins/bundled-plugins and <jira-home>/plugins/.osgi-plugins # Change the default schema back to "dbo" # Start JIRA # JIRA should be working again h4. Related Content This issue appears to be related to [JRA-25270 | https://jira.atlassian.com/browse/JRA-25270]

    Atlassian JIRA | 2 years ago | Tim Evans
    java.sql.SQLException: Invalid object name 'jiraeventtype'.
  3. 0

    Error when attempting to upgrade JIRA h4. Symptoms: The following appears in JIRA's logs: {noformat} 2014-08-01 10:33:05,318 main INFO [atlassian.jira.upgrade.UpgradeManagerImpl] Performing Upgrade Task: Insert sequence for event type 2014-08-01 10:33:05,322 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: Invalid object name 'jiraeventtype'. java.sql.SQLException: Invalid object name 'jiraeventtype'. 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:776) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at com.atlassian.jira.upgrade.tasks.util.Sequences.update(Sequences.java:36) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6320.doUpgrade(UpgradeTask_Build6320.java:41) {noformat} h4. Cause: Upgrade tasks that update sequences do not correctly apply schema name to table when the schema is named "jira". This has recently been triggered by an upgrade task in JIRA 6.3, however it's possible it could affect any future upgrade tasks which contain an update to a sequence. h4. Steps to reproduce # Install a version of JIRA earlier than JIRA 6.3 on MS SQL Server, making sure that the schema JIRA is installed in is called "jira", and the default schema of the user JIRA connects to MS SQL Server is something other than "jira", for example "dbo" (which is the default). JIRA actually encounters problems if the default schema is not set to "dbo". # Make sure it's all working fine # Upgrade to 6.3 or above # Watch the atlassian-jira.log file for the error above h4. Workaround: One of the following works around the issue: *Option 1* # Change schema name to something other than "jira". Update the {{dbconfig.xml}} file according to the changes. *Option 2* # Stop JIRA # Change the default schema of the database user JIRA is using to be "jira" # Start JIRA # Allow the uprade task to complete - some things in JIRA will be broken such as the streams plugin # Stop JIRA # Remove the directories <jira-home>/plugins/bundled-plugins and <jira-home>/plugins/.osgi-plugins # Change the default schema back to "dbo" # Start JIRA # JIRA should be working again h4. Related Content This issue appears to be related to [JRA-25270 | https://jira.atlassian.com/browse/JRA-25270]

    Atlassian JIRA | 2 years ago | Tim Evans
    java.sql.SQLException: Invalid object name 'jiraeventtype'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    'last_insert_id' is not a recognized function name

    Stack Overflow | 4 years ago | ZAJ
    com.kaizen.gate.service.ServiseException: Services level, can't save order - Order: (id=0, visitorId=2, status=A, customerId=528/nOrderDetail:(id=0, orderId=0, productId=124, amount=2)/n)
  6. 0

    Entity inheritance: central table with common values + extended father entity

    Stack Overflow | 5 years ago | Nimchip
    java.sql.SQLException: Invalid column name 'ACTUAL_SITUATION'.

  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

    Invalid object name 'jiraeventtype'.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    6. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2 frames
  4. com.atlassian.jira
    UpgradeTask_Build6320.doUpgrade
    1. com.atlassian.jira.upgrade.tasks.util.Sequences.update(Sequences.java:36)
    2. com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6320.doUpgrade(UpgradeTask_Build6320.java:41)
    2 frames