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
          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

              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: