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

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

    XMLWordPrintable

    Details

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

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: