-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
Affects Version/s: 5.7.4, 5.8.1
-
Component/s: None
-
5.07
When try to upgrade to GreenHopper 5.8.1 in JIRA 4.4.3 using Oracle database, below error has been found:
2011-10-20 10:19:10,374 http-8080-78 INFO jamesg 619x398x1 1dw7b1w 172.16.20.141,127.0.0.1 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [com.atlassian.greenhopper.upgrade] Starting upgrade task (buildNumber=12) : Migrate labs ranking data to multi-rank-field implementation
2011-10-20 10:19:38,678 http-8080-78 INFO jamesg 619x398x1 1dw7b1w 172.16.20.141,127.0.0.1 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [atlassian.greenhopper.upgrade.GhUpgradeTask012Dao] migrating labs rank data to new ranking table
2011-10-20 10:19:38,923 http-8080-78 ERROR jamesg 619x398x1 1dw7b1w 172.16.20.141,127.0.0.1 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [sal.core.upgrade.PluginUpgrader] Upgrade failed: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
- minor version:2
- major version:10
Driver:
- name:Oracle JDBC driver
- version:11.2.0.1.0
java.sql.SQLException: ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
- minor version:2
- major version:10
Driver:
- name:Oracle JDBC driver
- version:11.2.0.1.0
java.sql.SQLException: ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58)
Due to this, Greenhopper upgrade process has halted.