org.pentaho.di.core.exception.KettleDatabaseBatchException: Error updating batch ORA-01400: cannot insert NULL into ("PENTAHO_REPOSITORY"."INSTANCES"."HBM_ID")

Pentaho BI Platform Tracking | Slawomir Chodnicki | 5 years ago
  1. 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"."INSTANCES"."HBM_ID")
  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"."INSTANCES"."HBM_ID")
  3. 0

    Error during Sonar runner execution 5.0. "After migrating 3.7.4 to 5.0"

    Stack Overflow | 1 year ago | Gaston Paolo
    org.apache.ibatis.executor.BatchExecutorException: org.sonar.api.database.model.MeasureMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-00001: restricción única (SONAR5.SYS_C0078055) violada
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ActiveMQ unique constraint violated

    Stack Overflow | 4 years ago | Wayne Earnshaw
    java.sql.BatchUpdateException: ORA-00001: unique constraint (WEBSVC.SYS_C00181594) violated</p> <pre><code>at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  6. 0

    Exception: Could not synchronize database state with session

    Stack Overflow | 6 years ago | sun2
    java.sql.BatchUpdateException: ORA-00001: unique constraint (CARS.XAK1CAR_ATTRIBUTE) violated

  1. r1chjames 10 times, last 6 months ago
12 unregistered visitors
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 ("PENTAHO_REPOSITORY"."INSTANCES"."HBM_ID")

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
    2 frames
  3. Commons DBCP
    DelegatingStatement.executeBatch
    1. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
    1 frame
  4. org.pentaho.di
    RunThread.run
    1. org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1477)
    2. org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:647)
    3. org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
    3 frames
  5. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame