Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-3904

Greenhopper 5.8 doesn't work well with Oracle database due to ORA-01400

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 5.8.6
    • 5.7.4, 5.8.1
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vkgan Gan VoonKiat
              Votes:
              14 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: