java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("JOHNC"."BILL_PAYER_ACCOUNT"."ONLINE_BANK_KEY") FailedObjectArray: [au.com.bpay.ebpp.model.billpayeraccount.ejb.BillPayerAccountBean_1667511741_JDOState@a7bdcd]

Oracle Community | 807581 | 1 decade ago
  1. 0

    CMP find forces insert execution

    Oracle Community | 1 decade ago | 807581
    java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("JOHNC"."BILL_PAYER_ACCOUNT"."ONLINE_BANK_KEY") FailedObjectArray: [au.com.bpay.ebpp.model.billpayeraccount.ejb.BillPayerAccountBean_1667511741_JDOState@a7bdcd]
  2. 0

    An Oracle 11g repository is configured (repository works) File based auditing is configured (file exists, and has expected content) When selecting "Initialize from File" in the Enterprise Console the following output appears in the log: 2011-09-09 15:30:03,912 INFO [org.pentaho.di] Audit Reporting Populate 1 - Dispatching started for transformation [Audit Reporting Populate 1] 2011-09-09 15:30:04,088 INFO [org.pentaho.di] Instance start table - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,114 INFO [org.pentaho.di] Component start table - fail - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,139 INFO [org.pentaho.di] Session table - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,162 INFO [org.pentaho.di] Instance end table 2 - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,183 INFO [org.pentaho.di] Instance end table - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,205 INFO [org.pentaho.di] Component start table - Connected to database [Hibernate] (commit=5000) 2011-09-09 15:30:04,275 INFO [org.pentaho.di] Flat File Audit Log Input - Opening file: /home/pentaho/pentaho/server/biserver-ee/pentaho-solutions/system/logs/audit/PentahoAuditLog.log 2011-09-09 15:30:08,105 INFO [org.pentaho.di] Flat File Audit Log Input - Finished processing (I=443, O=0, R=0, W=443, U=1, E=0) 2011-09-09 15:30:08,130 INFO [org.pentaho.di] Session start - Finished processing (I=0, O=0, R=443, W=443, U=0, E=0) 2011-09-09 15:30:08,246 INFO [org.pentaho.di] Session start filter - Finished processing (I=0, O=0, R=145, W=145, U=0, E=0) 2011-09-09 15:30:08,247 INFO [org.pentaho.di] Instance Start - Finished processing (I=0, O=0, R=298, W=298, U=0, E=0) 2011-09-09 15:30:08,262 INFO [org.pentaho.di] Instance start filter - Finished processing (I=0, O=0, R=60, W=60, U=0, E=0) 2011-09-09 15:30:08,262 INFO [org.pentaho.di] Instance End - Finished processing (I=0, O=0, R=238, W=238, U=0, E=0) 2011-09-09 15:30:08,278 INFO [org.pentaho.di] Instance Fail - Finished processing (I=0, O=0, R=180, W=180, U=0, E=0) 2011-09-09 15:30:08,278 INFO [org.pentaho.di] Instance end filter - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0) 2011-09-09 15:30:08,284 INFO [org.pentaho.di] Java Script Value 3 - Finished processing (I=0, O=0, R=60, W=60, U=0, E=0) 2011-09-09 15:30:08,287 INFO [org.pentaho.di] Instance fail filter - Finished processing (I=0, O=0, R=5, W=5, U=0, E=0) 2011-09-09 15:30:08,288 INFO [org.pentaho.di] Component Ended - Finished processing (I=0, O=0, R=175, W=175, U=0, E=0) 2011-09-09 15:30:08,290 INFO [org.pentaho.di] Java Script Value 4 - Finished processing (I=0, O=0, R=58, W=58, U=0, E=0) 2011-09-09 15:30:08,298 INFO [org.pentaho.di] Component end filter - Finished processing (I=0, O=0, R=41, W=41, U=0, E=0) 2011-09-09 15:30:08,303 INFO [org.pentaho.di] Java Script Value 4 2 - Finished processing (I=0, O=0, R=5, W=5, U=0, E=0) 2011-09-09 15:30:08,314 INFO [org.pentaho.di] Component Failed - Finished processing (I=0, O=0, R=134, W=134, U=0, E=0) 2011-09-09 15:30:08,316 INFO [org.pentaho.di] Java Script Value - Finished processing (I=0, O=0, R=41, W=41, U=0, E=0) 2011-09-09 15:30:08,318 ERROR [org.pentaho.di] Session table - Unexpected batch update error committing the database connection. 2011-09-09 15:30:08,318 ERROR [org.pentaho.di] Session table - org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."SESSIONS"."HBM_ID") at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1494) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."SESSIONS"."HBM_ID") at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477) ... 3 more 2011-09-09 15:30:08,322 INFO [org.pentaho.di] Dummy (do nothing) - Finished processing (I=0, O=0, R=132, W=132, U=0, E=0) 2011-09-09 15:30:08,324 ERROR [org.pentaho.di] Instance start table - Unexpected batch update error committing the database connection. 2011-09-09 15:30:08,324 ERROR [org.pentaho.di] Instance start table - org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCES"."HBM_ID") at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1494) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCES"."HBM_ID") at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477) ... 3 more 2011-09-09 15:30:08,325 INFO [org.pentaho.di] Session table - Finished processing (I=0, O=0, R=145, W=0, U=0, E=1) 2011-09-09 15:30:08,325 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:08,325 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:08,325 ERROR [org.pentaho.di] Instance end table 2 - Unexpected batch update error committing the database connection. 2011-09-09 15:30:08,327 ERROR [org.pentaho.di] Instance end table 2 - org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCE_END"."HBM_ID") at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1494) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCE_END"."HBM_ID") at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477) ... 3 more 2011-09-09 15:30:08,328 ERROR [org.pentaho.di] Component start table - Unexpected batch update error committing the database connection. 2011-09-09 15:30:08,328 ERROR [org.pentaho.di] Component start table - org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."COMPONENTS"."HBM_ID") at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1494) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."COMPONENTS"."HBM_ID") at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477) ... 3 more 2011-09-09 15:30:08,328 INFO [org.pentaho.di] Instance start table - Finished processing (I=0, O=0, R=60, W=0, U=0, E=1) 2011-09-09 15:30:08,328 ERROR [org.pentaho.di] Instance end table - Unexpected batch update error committing the database connection. 2011-09-09 15:30:08,329 ERROR [org.pentaho.di] Instance end table - org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCE_END"."HBM_ID") at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1494) at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCE_END"."HBM_ID") at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477) ... 3 more 2011-09-09 15:30:08,329 INFO [org.pentaho.di] Instance end table 2 - Finished processing (I=0, O=0, R=5, W=0, U=0, E=1) 2011-09-09 15:30:08,330 INFO [org.pentaho.di] Component start table - Finished processing (I=0, O=0, R=41, W=0, U=0, E=1) 2011-09-09 15:30:08,330 INFO [org.pentaho.di] Instance end table - Finished processing (I=0, O=0, R=58, W=0, U=0, E=1) 2011-09-09 15:30:08,926 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:08,926 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:09,526 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:09,526 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:10,126 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:10,127 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:10,727 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 2011-09-09 15:30:10,727 INFO [org.pentaho.di] Audit Reporting Populate 1 - Audit Reporting Populate 1 Consequently, no data is available in the audit reports. Steps to reproduce setup: Use the 4.0 linux installer for a fresh installation Configure the repo for Oracle 11g Copy all of the files from pentaho-solutions/admin/audit/dialects/oracle10g/ to the pentaho-solutions/admin/audit/ directory, overwriting the existing files there Regards Slawo

    Pentaho BI Platform Tracking | 5 years ago | Slawomir Chodnicki
    org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCE_END"."HBM_ID")
  3. 0

    JPA - @OneToMany - java.sql.BatchUpdateException: ORA-01400: cannot insert NULL

    com.br | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate: How to Join three 3 tables in one join table in Annotation?

    Stack Overflow | 5 years ago | Jemru
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  6. 0

    ConstraintViolationException occurs in Hibernate | 1704 - javatpoint.com

    javatpoint.com | 1 year ago
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    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.BatchUpdateException

      ORA-01400: cannot insert NULL into ("JOHNC"."BILL_PAYER_ACCOUNT"."ONLINE_BANK_KEY") FailedObjectArray: [au.com.bpay.ebpp.model.billpayeraccount.ejb.BillPayerAccountBean_1667511741_JDOState@a7bdcd]

      at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeUpdateBatch()
    2. com.sun.jdo
      QueryImpl.execute
      1. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeUpdateBatch(SQLStoreManager.java:1644)
      2. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeBatch(SQLStoreManager.java:1559)
      3. com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.updatePersistent(SQLStateManager.java:997)
      4. com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:1251)
      5. com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.internalFlush(PersistenceManagerImpl.java:1548)
      6. com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.flush(QueryImpl.java:678)
      7. com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.doExecute(QueryImpl.java:628)
      8. com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.execute(QueryImpl.java:455)
      8 frames
    3. au.com.bpay
      UnitTest.testCreate
      1. au.com.bpay.ebpp.model.onlinebank.ejb.OnlineBankBean1924225955_ConcreteImpl.ejbFindAll(OnlineBankBean1924225955_ConcreteImpl.java:1695)
      2. au.com.bpay.ebpp.model.onlinebank.ejb.OnlineBankBean1924225955_ConcreteImpl_LocalHomeImpl.findAll(OnlineBankBean1924225955_ConcreteImpl_LocalHomeImpl.java:102)
      3. au.com.bpay.ebpp.model.billpayeraccount.UnitTest.populate(UnitTest.java:138)
      4. au.com.bpay.ebpp.model.billpayeraccount.UnitTest.performCreate(UnitTest.java:116)
      5. au.com.bpay.ebpp.model.billpayeraccount.UnitTest.testCreate(UnitTest.java:53)
      5 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    5. JUnit
      TestSuite.run
      1. junit.framework.TestCase.runTest(TestCase.java:154)
      2. junit.framework.TestCase.runBare(TestCase.java:127)
      3. junit.framework.TestResult$1.protect(TestResult.java:106)
      4. junit.framework.TestResult.runProtected(TestResult.java:124)
      5. junit.framework.TestResult.run(TestResult.java:109)
      6. junit.framework.TestCase.run(TestCase.java:118)
      7. junit.framework.TestSuite.runTest(TestSuite.java:208)
      8. junit.framework.TestSuite.run(TestSuite.java:203)
      9. junit.framework.TestSuite.runTest(TestSuite.java:208)
      10. junit.framework.TestSuite.run(TestSuite.java:203)
      11. junit.framework.TestSuite.runTest(TestSuite.java:208)
      12. junit.framework.TestSuite.run(TestSuite.java:203)
      12 frames
    6. au.com.bpay
      TestSuiteProxy.run
      1. au.com.bpay.ebpp.junit.ejb.UnitTestServiceBean.runTestSuite(UnitTestServiceBean.java:131)
      2. au.com.bpay.ebpp.junit.ejb.UnitTestServiceBean.runTest(UnitTestServiceBean.java:118)
      3. au.com.bpay.ebpp.junit.ejb.UnitTestServiceBean_EJBObjectImpl.runTest(UnitTestServiceBean_EJBObjectImpl.java:26)
      4. au.com.bpay.ebpp.junit.ejb._UnitTestService_Stub.runTest(Unknown Source)
      5. au.com.bpay.ebpp.junit.UnitTestEjbClient.proxy(UnitTestEjbClient.java:77)
      6. au.com.bpay.ebpp.junit.EjbProxy.proxy(EjbProxy.java:47)
      7. au.com.bpay.ebpp.junit.TestSuiteProxy.run(TestSuiteProxy.java:50)
      7 frames
    7. JUnit
      TestSuite.run
      1. junit.framework.TestSuite.runTest(TestSuite.java:208)
      2. junit.framework.TestSuite.run(TestSuite.java:203)
      2 frames
    8. au.com.bpay
      UnitTestServlet.doPost
      1. au.com.bpay.ebpp.junit.UnitTestServlet.doPost(UnitTestServlet.java:255)
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    10. Glassfish Core
      StandardWrapperValve.access$000
      1. org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrapperValve.java:720)
      2. org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.java:118)
      2 frames