OSB - Error in Sbconsole opening report body detail (Doc ID 1364980.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Mar-2013***

Symptoms

In Oracle Service Bus (OSB) sbconsole navigate to operations --> message reports, then search for a message, and select one message. When you click on report body - detail, you get an Internal Server Error.



MESSAGE : [ServletContext@478090965[app:ServiceBus_Console module:sbconsole path:/sbconsole spec-version:2.5]] Servlet failed with Exception
java.lang.RuntimeException: error: Unexpected end of file after null
at com.bea.wli.reporting.jmsprovider.runtime.ReportingDataAccessImpl.getMessageDataDetail(ReportingDataAccessImpl.java:237)
at com.bea.alsb.console.oam.reporting.jmsprovider.ReportingHelper.getMessageDataDetail(ReportingHelper.java:173)
at jsp_servlet._jsp._reporting._jmsprovider.__viewmessagedetail._jspService(__viewmessagedetail.java:82)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:417)



In addition you might see below exception:


<2010/09/28 11:13:38 AM> <Error> <BEA-Reporting> <BEA-473514> <An unexpected error occurred while receiving the message in ReportingMDB java.io.IOException: ORA-22920: row containing the LOB value is not locked
java.io.IOException: ORA-22920: row containing the LOB value is not locked
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(OracleBlobOutputStream.java:164)
at com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting.insertMsgContentForOracle(MDBMessageR
eporting.java:475)
at com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting.processData(MDBMessageReporting.java:
216)
Truncated. see log file for complete stacktrace
>
<2010/09/28 11:13:38 AM> <Error> <BEA-Reporting> <BEA-473514> <An unexpected error occurred while receiving the message in ReportingMDB java.io.IOException: ORA-22920: row containing the LOB value is not locked

java.io.IOException: ORA-22920: row containing the LOB value is not locked
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(OracleBlobOutputStream.java:164)
at com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting.insertMsgContentForOracle(MDBMessageR
eporting.java:475)
at com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting.processData(MDBMessageReporting.java:
216)
Truncated. see log file for complete stacktrace

Changes

none

Cause

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