OSB - OSB-Reporting:473512 Error in Message Report Console (Doc ID 1191487.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

In Oracle Service Bus (OSB) when viewing message reports

(From OSB console --> Operation --> Reporting --> Message Reports)
The following is seen in OSB console:

Console Error: The server encountered an unexpected condition which prevented it from fulfilling the request.


And the server log file shows the following one/all of the following errors:

<BEA-010026> <Exception occurred during commit of transaction Name=NewJMSMessagePoller.ReportingMDB,Xid=BEA1-4F960524552A1062C3BB(795857361),Status=Rolled back. [Reason=java.lang.RuntimeException: [OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=60,XAServerResourceInfo[WLStore_SOAdevdomain1_FileStore]=(ServerResourceInfo[WLStore_SOAdevdomain1_FileStore]=(state=rolledback,assigned=osb_server1),xar=WLStore_SOAdevdomain1_FileStore40765132,re-Registered = false),NonXAServerResourceInfo[WL_JDBC_LLR_POOL.wlsbjmsrpDataSource]=(ServerResourceInfo[WL_JDBC_LLR_POOL.wlsbjmsrpDataSource]=(state=rolledback,assigned=osb_server1),nonXAResource=JDBC LLR, pool=wlsbjmsrpDataSource, table=WL_LLR_OSB_SERVER1),SCInfo[SOAdevdomain1+osb_server1]=(state=rolledback),properties=({weblogic.transaction.nonXAResource=WL_JDBC_LLR_POOL.wlsbjmsrpDataSource, weblogic.transaction.name=NewJMSMessagePoller.ReportingMDB, weblogic.jdbc=t3://myserver:10003, weblogic.jdbc.llr=wlsbjmsrpDataSource}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=osb_server1+soada01.ieee.org:10003+SOAdevdomain1+t3+, XAResources={WSATGatewayRM_osb_server1_SOAdevdomain1, eis/sunmq/Queue, WLStore_SOAdevdomain1_WseeFileStore, eis/apps/EBSIBP, eis/wls/Queue, eis/tibjms/Queue, eis/tibjmsDirect/Topic, eis/activemq/Queue, eis/AQ/aqSample, WLStore_SOAdevdomain1__WLS_osb_server1, eis/tibjms/Topic, eis/aqjms/Queue, eis/tibjmsDirect/Queue, eis/Apps/Apps, eis/jbossmq/Queue, eis/AQ/TDSEHDS, eis/fioranomq/Topic, WLStore_SOAdevdomain1_FileStore, eis/apps/EBSFIN, eis/aqjms/Topic, eis/pramati/Queue, eis/wls/Topic, eis/aq/TDS, eis/webspheremq/Queue},NonXAResources={})],CoordinatorURL=osb_server1+soada01.ieee.org:10003+SOAdevdomain1+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting@79bcc694
[OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}

 

 

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