Details
-
Bug
-
Resolution: Fixed
-
Low
-
4.4
-
None
-
4.04
-
Description
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:
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
- 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
Issue Links
- has a derivative of
-
JRASERVER-25329 JIRA 4.4 MSSQL schema in dbconfig.xml does not get picked up by ./config.sh
- Closed
- is related to
-
JRASERVER-25331 FIXED (SEE COMMENTS IN CASE SOMEONE ELSE HAS THIS ISSUE) Issues with upgrading in places from 4.3x to 4.4...if we cant get this fixed asap, we will need to roll back
- Closed