My Oracle Support Banner

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 OCTOBER 12, 2021

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(
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(
at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(
... 17 more .> 


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.