Reason and Solution for <ERROR> <core.logSQLException> <Timer-9> <SQL Exception 0 : Transaction BEA1-0346EEC1AAB31FE38EAF not active anymore (Doc ID 1375819.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.0.1 and later
Information in this document applies to any platform.
Checked Currency on 20-Jul-2015

Goal

How to get rid of the following exceptions in the logs which are coming continuously after the restart of the server.

<08-Nov-2011 9:32:08,933 CET PM> <ERROR> <core.logSQLException> <Timer-9> <SQL Exception 0 : Transaction BEA1-0346EEC1AAB31FE38EAF not active anymore. tx status = Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException]>
java.sql.SQLException: Transaction BEA1-0346EEC1AAB31FE38EAF not active anymore. tx status = Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException]
at weblogic.jdbc.jts.Driver.getTransaction(Driver.java:542)
at weblogic.jdbc.jts.Driver.connect(Driver.java:110)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:346)
at com.mslv.oms.dataaccesslayer.a.getConnection(Unknown Source)
at com.mslv.oms.dataaccesslayer.QueryProxy.getConnection(Unknown Source)
at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
at com.mslv.oms.dataaccesslayer.QueryProxy.execute(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcherEJB.processTimeout(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.processTimeout(EventDispatcher_86q3j1_EOImpl.java:73)
at com.mslv.oms.poller.a.handleNotification(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor$ListenerWrapper.handleNotification(DefaultMBeanServerInterceptor.java:1732)
at javax.management.NotificationBroadcasterSupport.handleNotification(NotificationBroadcasterSupport.java:257)
at javax.management.NotificationBroadcasterSupport$SendNotifJob.run(NotificationBroadcasterSupport.java:322)
at javax.management.NotificationBroadcasterSupport$1.execute(NotificationBroadcasterSupport.java:307)
at javax.management.NotificationBroadcasterSupport.sendNotification(NotificationBroadcasterSupport.java:229)
at javax.management.timer.Timer.sendNotification(Timer.java:1237)
at javax.management.timer.Timer.notifyAlarmClock(Timer.java:1206)
at javax.management.timer.TimerAlarmClock.run(Timer.java:1289)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)

 

Solution

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