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. 44_upgrade_gadget_MSSQL.png
          34 kB
          Michael Andreacchio
        2. atlassian-jira.log
          167 kB
          Foong
        3. database.BAK
          3.58 MB
          Foong
        4. dbconfig.xml
          0.5 kB
          Foong
        5. michael_catalina.out
          187 kB
          Michael Andreacchio
        6. schema_inconsistent.png
          90 kB
          Michael Andreacchio
        7. server.xml
          7 kB
          Foong
        8. Upgrade task Failure.txt
          3 kB
          Veenu Bharara

        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: