java.sql.BatchUpdateException and Message Loss on MQ Topic with JMS Adapter and Database Failure (Doc ID 1231353.1)

Last updated on APRIL 14, 2011

Applies to:

Oracle SOA Platform - Version: 11.1.1.2.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

When the JMS Adapter is used to read messages from an MQ Topic, messages are getting lost if the SOA-INFRA database is not available or other errors occur, such as running out of tablespace space. The following exception is thrown on the server log.


Exception Log:
[2010-05-24T07:30:39.328-04:00] [WLS_SOA1] [ERROR] [] [oracle.soa.mediator.service] [tid: orabpel.invoke.pool-3.thread-1] [userId: <anonymous>] [ecid: 0000IZA52_s7MAx5KBEgMe1Bt4tq0000dQ,0:1:100006266] [APP: soa-infra] [composite_name: QQCM_SyncChemistryRS] [component_name: QQCM_SyncChemistryRS] [component_instance_id: C7762B40672711DFBF96E1C4A5479A96] [composite_instance_id: 359325] re-throwing the received exception oracle.fabric.common.FabricInvocationException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.2.0) (Build 091016)): oracle.toplink.exceptions.DatabaseException[[
Internal Exception: java.sql.BatchUpdateException: ORA-01654: unable to extend index USS_SOAINFRA.COMPOSITE_INSTANCE_CREATED by 16 in tablespace SOAINFRA_SX

Error Code: 1654: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.2.0) (Build 091016)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01654: unable to extend index USS_SOAINFRA.COMPOSITE_INSTANCE_CREATED by 16 in tablespace SOAINFRA_SX

Error Code: 1654 oracle.fabric.common.FabricException: oracle.fabric.common.FabricInvocationException: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.2.0) (Build 091016)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01654: unable to extend index USS_SOAINFRA.COMPOSITE_INSTANCE_CREATED by 16 in tablespace SOAINFRA_SX

Error Code: 1654: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.2.0) (Build 091016)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01654: unable to extend index USS_SOAINFRA.COMPOSITE_INSTANCE_CREATED by 16 in tablespace SOAINFRA_SX

Error Code: 1654
at oracle.integration.platform.blocks.local.LocalInvocationProcessor.createCompositeInstance(LocalInvocationProcessor.java:640)
at oracle.integration.platform.blocks.local.LocalInvocationProcessor.doPreInvocationProcessing(LocalInvocationProcessor.java:192)
at oracle.integration.platform.blocks.local.LocalInvocationProcessor.post(LocalInvocationProcessor.java:166)
at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.post(WebServiceExternalBindingComponent.java:578)
at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:142)
at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:194)
at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:204)
at sun.reflect.GeneratedMethodAccessor947.invoke(Unknown Source)
.........

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