java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When perform upgrade to GreenHopper 5.8.x in JIRA 4.4.3 using Oracle database, below error has been found: {noformat} 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 {noformat} And {noformat} 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) {noformat} end up with : {noformat} 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) {noformat} As far as we discovered, this only happened in Oracle Database.
    via by Voon Kiat Gan [Atlassian],
  • When perform upgrade to GreenHopper 5.8.x in JIRA 4.4.3 using Oracle database, below error has been found: {noformat} 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 {noformat} And {noformat} 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) {noformat} end up with : {noformat} 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) {noformat} As far as we discovered, this only happened in Oracle Database.
    via by Voon Kiat Gan [Atlassian],
  • When try to upgrade to GreenHopper 5.8.1 in JIRA 4.4.3 using Oracle database, below error has been found: {noformat} 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) {noformat} Due to this, Greenhopper upgrade process has halted.
    via by Voon Kiat Gan [Atlassian],
  • When try to upgrade to GreenHopper 5.8.1 in JIRA 4.4.3 using Oracle database, below error has been found: {noformat} 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) {noformat} Due to this, Greenhopper upgrade process has halted.
    via by Voon Kiat Gan [Atlassian],
    • 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)
    No Bugmate found.