Messages Going To Suspended State In Consumer Mediator (Doc ID 2507057.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

On : 11.1.1.7.8 version, Fabric

Messages going to suspended state in consumer mediator


ERROR
-----------------------
< < failed to handle the messages for the group oracle.tip.mediator.common.persistence.MediatorGroupStatuscomponentDn=default/SyncConsignmentV2GTSProvABCS!4.0.10/SyncConsignmentV2GTSConsumerMediator, operation=Consume_Message, groupId=14729-SUP-CSMTEST33, status=1, sequencingType=BestEffort, sequencing Level=OPERATION_SEQUENCING, lastSequenceIdProcessed=-1
java.lang.Exception: failed to get the resequencedMessages
at oracle.tip.mediator.resequencer.ResequencerDBWorker.getIterator(ResequencerDBWorker.java:93)
at oracle.tip.mediator.resequencer.ResequencerDBWorker.handleMessage(ResequencerDBWorker.java:148)
at oracle.tip.mediator.resequencer.ResequencerDBWorker.process(ResequencerDBWorker.java:355)
at oracle.tip.mediator.common.listener.AbstractWorker.run(AbstractWorker.java:81)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused By: oracle.tip.mediator.infra.exception.MediatorException: ORAMED-03006:[Resequencer Message Retreival Failed]Unable to retrieve Resequencer message. " Failed to get the resequencer messages for BestEffort Iterator"Possible Fix:Unable to retrieve Resequencer message. Check your database connection.
at oracle.tip.mediator.dispatch.resequencer.toplink.BestEffortResequencerToplinkDatabaseHandler.getNextMessages(BestEffortResequencerToplinkDatabaseHandler.java:200)
at oracle.tip.mediator.resequencer.besteffort.BestEffortIterator.init(BestEffortIterator.java:33)
at oracle.tip.mediator.resequencer.ResequencerDBWorker.getIterator(ResequencerDBWorker.java:83)
at oracle.tip.mediator.resequencer.ResequencerDBWorker.handleMessage(ResequencerDBWorker.java:148)
at oracle.tip.mediator.resequencer.ResequencerDBWorker.process(ResequencerDBWorker.java:355)
at oracle.tip.mediator.common.listener.AbstractWorker.run(AbstractWorker.java:81)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused By: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Cause

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