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

Atlassian JIRA | Kah Loun Foong [Atlassian] | 5 years ago
  1. 0

    *Steps to reproduce* # Create a new database name 'jiradb44' and make sure that the database is empty # Add schema name 'jira' to the database # Configure JIRA 4.4 to connect to SQL Server with schema name 'jira' by using {{config.bat}} (refer to my attached file for the configuration) # Startup JIRA and go through the setup process # After finish installing, can't login to JIRA because the gadget failed to loaded: {noformat} 2011-08-03 23:11:24,603 http-8080-4 WARN anonymous 1391x45x1 zcec9o 127.0.0.1 /secure/Dashboard.jspa [gadgets.embedded.internal.GadgetUrlBuilder] GadgetUrlBuilder: could not parse spec at rest/gadgets/1.0/g/com.atlassian.jira.gadgets:introduction-gadget/gadgets/introduction-gadget.xml 2011-08-03 23:11:24,623 http-8080-4 WARN anonymous 1391x45x1 zcec9o 127.0.0.1 /secure/Dashboard.jspa [gadgets.embedded.internal.GadgetUrlBuilder] GadgetUrlBuilder: could not parse spec at rest/gadgets/1.0/g/com.atlassian.jira.gadgets/gadgets/login.xml {noformat} # JIRA unable to find jiraissue table during upgrade: {noformat} 2011-08-03 23:11:15,004 http-8080-1 ERROR anonymous 1391x29x1 zcec9o 127.0.0.1 /secure/Setup3.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: Invalid object name 'jiraissue'. java.sql.SQLException: Invalid object name 'jiraissue'. 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) {noformat} *Workaround* Migrate the database from schema name 'jira' to the default schema name 'dbo'

    Atlassian JIRA | 5 years ago | Kah Loun Foong [Atlassian]
    java.sql.SQLException: Invalid object name 'jiraissue'.
  2. 0

    *Steps to reproduce* # Create a new database name 'jiradb44' and make sure that the database is empty # Add schema name 'jira' to the database # Configure JIRA 4.4 to connect to SQL Server with schema name 'jira' by using {{config.bat}} (refer to my attached file for the configuration) # Startup JIRA and go through the setup process # After finish installing, can't login to JIRA because the gadget failed to loaded: {noformat} 2011-08-03 23:11:24,603 http-8080-4 WARN anonymous 1391x45x1 zcec9o 127.0.0.1 /secure/Dashboard.jspa [gadgets.embedded.internal.GadgetUrlBuilder] GadgetUrlBuilder: could not parse spec at rest/gadgets/1.0/g/com.atlassian.jira.gadgets:introduction-gadget/gadgets/introduction-gadget.xml 2011-08-03 23:11:24,623 http-8080-4 WARN anonymous 1391x45x1 zcec9o 127.0.0.1 /secure/Dashboard.jspa [gadgets.embedded.internal.GadgetUrlBuilder] GadgetUrlBuilder: could not parse spec at rest/gadgets/1.0/g/com.atlassian.jira.gadgets/gadgets/login.xml {noformat} # JIRA unable to find jiraissue table during upgrade: {noformat} 2011-08-03 23:11:15,004 http-8080-1 ERROR anonymous 1391x29x1 zcec9o 127.0.0.1 /secure/Setup3.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: Invalid object name 'jiraissue'. java.sql.SQLException: Invalid object name 'jiraissue'. 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) {noformat} *Workaround* Migrate the database from schema name 'jira' to the default schema name 'dbo'

    Atlassian JIRA | 5 years ago | Kah Loun Foong [Atlassian]
    java.sql.SQLException: Invalid object name 'jiraissue'.
  3. 0

    How to create/call a sql view in Hibernate

    Stack Overflow | 3 years ago | sᴜʀᴇsʜ ᴀᴛᴛᴀ
    java.sql.SQLException: The request for procedure 'docView' failed because 'docView' is a view object.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.quartz.user - Missed Triggers not re firing - msg#00050 - Recent Discussion OSDir.com

    osdir.com | 1 year ago
    java.sql.SQLException: Cannot insert the value NULL into column 'PRIORITY', table 'Quartz_Demo.dbo.QRTZ_FIRED_TRIGGERS'; column does not allow nulls. INSERT fails.
  6. 0

    - Recent Discussion OSDir.com

    osdir.com | 11 months ago
    java.sql.SQLException: Could not find prepared statement with handle 2. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)

    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 'jiraissue'.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      TdsCore.getMoreResults
      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)
      4 frames