AQ JMS Application Using JDBC 11.2.0.3 Fails With JMS-120 and ORA-01878 (Doc ID 1574121.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

After Daylight Saving Time(DST) changes, when AQ JMS applications using JDBC 11.2.0.3 receives a message, dequeue fails with the following messages:

<BEA-010079> <An error occurred while attempting to receive a message from JMS for processing by a message-driven bean: oracle.jms.AQjmsException: JMS-120: Dequeue failed
Nested exception: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval

The exception is : oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:315)
at oracle.jms.AQjmsConsumer.jdbcDequeue(AQjmsConsumer.java:1620)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:1035)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:960)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:938)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:790)
at weblogic.ejb.container.internal.NewJMSMessagePoller$1.run(NewJMSMessagePoller.java:264)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.ejb.container.internal.JMSConnectionPoller.doPrivilegedJMSAction(JMSConnectionPoller.java:2752)
at weblogic.ejb.container.internal.NewJMSMessagePoller.processOneMessage(NewJMSMessagePoller.java:260)
at weblogic.ejb.container.internal.NewJMSMessagePoller.run(NewJMSMessagePoller.java:120)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Caused by: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4Caqdq.processError(T4Caqdq.java:497)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4Caqdq.doOAQDQ(T4Caqdq.java:183)
at oracle.jdbc.driver.T4CConnection.doDequeue(T4CConnection.java:4704)
at oracle.jdbc.driver.PhysicalConnection.dequeue(PhysicalConnection.java:17863)
at oracle.jdbc.driver.PhysicalConnection.dequeue(PhysicalConnection.java:17949)
at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection.dequeue(Unknown Source)
at oracle.jms.AQjmsConsumer.jdbcConnectionDequeueCheck25242(AQjmsConsumer.java:1713)
at oracle.jms.AQjmsConsumer.jdbcDequeue(AQjmsConsumer.java:1295)
... 12 more

Changes

Cause

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