java.sql.SQLException: ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")

Atlassian JIRA | Voon Kiat Gan [Atlassian] | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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.

    Atlassian JIRA | 5 years ago | Voon Kiat Gan [Atlassian]
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")
  2. 0

    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.

    Atlassian JIRA | 5 years ago | Voon Kiat Gan [Atlassian]
    java.sql.SQLException: Functie wordt niet ondersteund.
  3. 0

    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.

    Atlassian JIRA | 5 years ago | Voon Kiat Gan [Atlassian]
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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.

    Atlassian JIRA | 5 years ago | Voon Kiat Gan [Atlassian]
    java.sql.SQLException: Functie wordt niet ondersteund.
  6. 0

    ArrayIndexOutOfBoundsException when trying to create Calendar - Atlassian Documentation

    atlassian.com | 3 months ago
    java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.ArrayIndexOutOfBoundsException

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01400: cannot insert NULL into ("JIRA_4_4"."AO_60DB71_ISSUERANKING"."ID")

      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create()
    2. com.atlassian.activeobjects
      DelegatingActiveObjects.create
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79)
      2. com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58)
      2 frames