java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")

Oracle Community | user147287 | 3 years ago
  1. 0

    BI Publisher Template Builder for Word 10.1.3.4.1 and Creating Pivot Table

    Oracle Community | 3 years ago | user147287
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")
  2. 0

    ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_

    Oracle Community | 6 years ago | Eugen-Oracle
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")
  3. 0

    post-processing actions failed (Report Completed with Warning Status)

    Oracle Community | 10 years ago | 529604
    java.sql.SQLException: Non supported SQL92 token at position: 1: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Inlined Compiled Code)) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java(Inlined Compiled Code)) at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java(Compiled Code)) at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java(Compiled Code)) at oracle.jdbc.driver.OracleSql.parse(OracleSql.java(Inlined Compiled Code)) at oracle.jdbc.driver.OracleConnection.nativeSQL(OracleConnection.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.expandSqlEscapes(OracleStatement.java(Inlined Compiled Code)) at oracle.jdbc.driver.OracleStatement.parseSqlKind(OracleStatement.java(Inlined Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.java(Inlined Compiled Code)) at oracle.jdbc.driver.OracleCallableStatement.<init>(OracleCallableStatement.java(Inlined Compiled Code)) at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java(Compiled Code)) at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java(Compiled Code))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    WLPI w/ AI plug-in - insert action called from a task, but causes a DB error

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("DKIMPI"."CUSTOMER_TABLE"."FIRSTNAME") >
  6. 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")

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01400: cannot insert NULL into ("APPLSYS"."FND_CONC_REQ_OUTPUTS"."FILE_TYPE")

      at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.updateOutputTable()
    2. oracle.apps.fnd
      OPPRequestThread.run
      1. oracle.apps.fnd.cp.opp.XMLPublisherProcessor.updateOutputTable(XMLPublisherProcessor.java:516)
      2. oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:329)
      3. oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
      3 frames