Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error handling message (rolling back). java.sql.SQLException: ORA-06575: Package or function EDN_DEQ

924563Jul 16 2015 — edited Sep 21 2015

Hi,

We have BPM Managed Server and after started the same we have found that our <MiddlewareHome> space is getting full within some time.

After analyzing we have found that ManagedServer.out (BPM_M1.out) file is filling frequently with following error:

<Jul 16, 2015 8:40:08 PM IST> <Warning> <oracle.integration.platform.blocks.event.saq> <SOA-31013> <Error handling message (rolling back).

java.sql.SQLException: ORA-06575: Package or function EDN_DEQUEUE_OAOO_DELIVERY is in an invalid state

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)

        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

        at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)

        at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.readOAOODelivery(SAQBusinessEventBus.java:1585)

        at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleSingleOAOODelivery(SAQBusinessEventBus.java:858)

        at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleQueueEvents(SAQBusinessEventBus.java:731)

        at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.access$000(SAQBusinessEventBus.java:90)

        at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus$1.run(SAQBusinessEventBus.java:372)

        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)

>

Please help in this issue. Some urgency please.

Regards,

Sumit Matta

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2015
Added on Jul 16 2015
0 comments
827 views