OSB Reporting Action Failed with java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("OSSVVOSB01_SOAINFRA"."WLI_QS_REPORT_ATTRIBUTE"."DB_TIMESTAMP")

(Doc ID 2194161.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Service Bus - Version and later
Information in this document applies to any platform.


Users see the below error in OSB managed server logs and the transactions are not making to the WLI_QS_REPORT_ATTRIBUTE and WLI_QS_REPORT_DATA tables. This error is causing stuck threads and making the servers go to warning state every 15 minutes.

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("OSSVVOSB01_SOAINFRA"."WLI_QS_REPORT_ATTRIBUTE"."DB_TIMESTAMP")
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(MDBBatch.java:124)
... 17 more .> 


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms