Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-25270

JIRA 4.4 does not work with schema name 'jira' in SQL Server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 4.4.1, 5.0
    • 4.4
    • None

    Description

      Steps to reproduce

      1. Create a new database name 'jiradb44' and make sure that the database is empty
      2. Add schema name 'jira' to the database
      3. 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)
      4. Startup JIRA and go through the setup process
      5. After finish installing, can't login to JIRA because the gadget failed to loaded:
        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
        
      6. JIRA unable to find jiraissue table during upgrade:
        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)
        

      Workaround
      Migrate the database from schema name 'jira' to the default schema name 'dbo'

      Attachments

        1. dbconfig.xml
          0.5 kB
        2. atlassian-jira.log
          167 kB
        3. server.xml
          7 kB
        4. database.BAK
          3.58 MB
        5. schema_inconsistent.png
          schema_inconsistent.png
          90 kB
        6. 44_upgrade_gadget_MSSQL.png
          44_upgrade_gadget_MSSQL.png
          34 kB
        7. michael_catalina.out
          187 kB
        8. Upgrade task Failure.txt
          3 kB

        Issue Links

          Activity

            People

              mlassau Mark Lassau (Inactive)
              klfoong Foong (Inactive)
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: