Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-3916

GreenHopper failed to upgrade due to java.sql.SQLException: Function not supported

    XMLWordPrintable

    Details

    • Introduced in Version:
      5.08
    • Current Status:
      Hide
      Atlassian Status as at December 13 2011

      Hi All,

      Please note that this problem is related to an issue with the Active Objects library/plugin that is shipped with Jira. This problem is fixed in Jira 4.4.4 which was released on the 13th of December 2012.

      Please note that in some cases affected users may require some manual corrections to their database. If you continue to have difficulties please contact https://support.atlassian.com for assistance.

      Thanks,
      Shaun Clowes

      Show
      Atlassian Status as at December 13 2011 Hi All, Please note that this problem is related to an issue with the Active Objects library/plugin that is shipped with Jira. This problem is fixed in Jira 4.4.4 which was released on the 13th of December 2012. Please note that in some cases affected users may require some manual corrections to their database. If you continue to have difficulties please contact https://support.atlassian.com for assistance. Thanks, Shaun Clowes

      Description

      When perform upgrade to GreenHopper 5.8.x in JIRA 4.4.3 using Oracle database, below error has been found:

      2011-10-21 13:46:33,248 http-8443-1 ERROR leon 826x334x1 1dxw16k 10.101.10.31 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [greenhopper.upgrade.task013.MigrateRankDataTaskImpl] Could not migrate ranks from old rank field customfield_10001 to new rank field customfield_10932
      2011-10-21 13:46:33,248 http-8443-1 INFO leon 826x334x1 1dxw16k 10.101.10.31 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [greenhopper.upgrade.task013.MigrateRankDataTaskImpl] -- Undo class com.atlassian.greenhopper.upgrade.task013.MigrateRankDataTaskImpl
      
      

      And

      2011-10-21 13:46:33,810 http-8443-1 INFO leon 826x334x1 1dxw16k 10.101.10.31 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [greenhopper.upgrade.task013.ConvertOldRankFieldsToNumberTypeTask] -- Undo Done class com.atlassian.greenhopper.upgrade.task013.ConvertOldRankFieldsToNumberTypeTask
      2011-10-21 13:46:33,826 http-8443-1 ERROR leon 826x334x1 1dxw16k 10.101.10.31 /rest/plugins/1.0/com.pyxis.greenhopper.jira-key [sal.core.upgrade.PluginUpgrader] Upgrade failed: null
      java.lang.reflect.InvocationTargetException
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      

      end up with :

      Caused by: 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.4.0 - 64bit Production
      With the Partitioning, Real Application Clusters, OLAP, Data Mining
      and Real Application Testing options
      	- minor version:2
      	- major version:10
      Driver:
      	- name:Oracle JDBC driver
      	- version:11.2.0.1.0
      
      java.sql.SQLException: Functie wordt niet ondersteund.
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79)
      	at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      

      As far as we discovered, this only happened in Oracle Database.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              vkgan Gan VoonKiat
              Votes:
              32 Vote for this issue
              Watchers:
              43 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1m
                  1m
                  Remaining:
                  Remaining Estimate - 1m
                  1m
                  Logged:
                  Time Spent - Not Specified
                  Not Specified