My Oracle Support Banner

Batch Scheduler Failing With "Unexpected Exception While Setting Db Context User To 'SYSUSER'" in DISTRIBUTED Mode (Doc ID 1643662.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Information in this document applies to any platform.

Goal

 Our BatchScheduler is failing with the following error.

The root LoggedException was: Unexpected exception while setting module name to 'TUGBU Idle'
and
The root LoggedException was: Unexpected exception while setting db context user to 'SYSUSER'

A restart seems to have fixed the issue, but need to understand the cause and if there is a fix.

 

Threadpoolworker logs include:

-  2014-03-20 13:23:51,126 [Sched_Req:SchedulerManager] ERROR (support.context.FrameworkSession) Error initializing framework session
-  2014-03-20 13:23:51,129 [Sched_Req:SchedulerManager] ERROR (support.context.SessionExecutable) Caught exception from SessionExecutable.execute()
-  2014-03-20 13:23:51,129 [Sched_Req:SchedulerManager] ERROR (scheduler.process.SchedulerManagerImpl_ISD) Scheduler exited!
-  2014-03-20 13:23:51,129 [Sched_Req:SchedulerManager] INFO  (scheduler.process.SchedulerManagerImpl_ISD) received request to shut down Scheduler Sched_Req
-  2014-03-20 13:23:51,309 [Sched_Opti:SchedulerManager] ERROR (support.context.FrameworkSession) Error initializing framework session
-  2014-03-20 13:23:51,310 [Sched_Opti:SchedulerManager] ERROR (support.context.SessionExecutable) Caught exception from SessionExecutable.execute()
-  2014-03-20 13:23:51,310 [Sched_Opti:SchedulerManager] ERROR (scheduler.process.SchedulerManagerImpl_ISD) Scheduler exited!
-  2014-03-20 13:23:51,310 [Sched_Opti:SchedulerManager] INFO  (scheduler.process.SchedulerManagerImpl_ISD) received request to shut down Scheduler Sched_Opti
-  2014-03-20 13:23:51,499 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.FrameworkSession) Error releasing hibernate session
-  2014-03-20 13:23:51,501 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.FrameworkSession) Error commiting session
-  2014-03-20 13:23:51,502 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.SessionExecutable) Caught exception from SessionExecutable.execute()
-  2014-03-20 13:23:51,504 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.FrameworkSession) Error rolling back session's transaction
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:183)
at com.splwg.base.support.context.FrameworkSession.rollback(FrameworkSession.java:715)
...
-  2014-03-20 13:23:51,511 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.FrameworkSession) Error releasing hibernate session
-  2014-03-20 13:23:51,512 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (support.context.FrameworkSession) Error rolling back session
-  2014-03-20 13:23:51,513 [Thread-16:SpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)] ERROR (grid.space.AbstractTask) Exception running taskSpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)
-  2014-03-20 13:23:51,513 [Thread-16] ERROR (grid.space.ThreadPool) Error encountered running task: SpaceChangePollerTask-322-Space:MAIN of class com.splwg.base.support.grid.space.SpaceChangePollerTask
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.grid.space.AbstractTransactionalTask.runOutsideTransaction(AbstractTransactionalTask.java:31): Exception running taskSpaceChangePollerTask(SpaceChangePollerTask-322-Space:MAIN)
com.splwg.base.support.context.FrameworkSession.releaseHibernateSession(FrameworkSession.java:740): Error rolling back session
com.splwg.base.support.sql.OracleFunctionReplacer.releaseConnection(OracleFunctionReplacer.java:366): Error releasing hibernate session

The root LoggedException was: Unexpected exception while setting module name to 'TUGBU Idle'
at com.splwg.shared.common.LoggedException.wrap(LoggedException.java:150)
at com.splwg.base.support.sql.OracleFunctionReplacer.setConnectionName(OracleFunctionReplacer.java:295)
at com.splwg.base.support.sql.OracleFunctionReplacer.clearConnectionName(OracleFunctionReplacer.java:312)
at com.splwg.base.support.sql.OracleFunctionReplacer.releaseConnection(OracleFunctionReplacer.java:366)
       ...
Caused by: java.lang.NullPointerException
at oracle.jdbc.driver.T4CTTIiov.unmarshalV10(T4CTTIiov.java:199)
at oracle.jdbc.driver.T4C8Oall.readIOV(T4C8Oall.java:544)
       ...
-  2014-03-20 13:23:52,502 [Thread-18:SpaceChangePollerTask(SpaceChangePollerTask-323-Space:MAIN)] ERROR (support.context.FrameworkSession) Error initializing framework session
-  2014-03-20 13:23:52,502 [Thread-18:SpaceChangePollerTask(SpaceChangePollerTask-323-Space:MAIN)] ERROR (support.context.SessionExecutable) Caught exception from SessionExecutable.execute()
-  2014-03-20 13:23:52,502 [Thread-18:SpaceChangePollerTask(SpaceChangePollerTask-323-Space:MAIN)] ERROR (grid.space.AbstractTask) Exception running taskSpaceChangePollerTask(SpaceChangePollerTask-323-Space:MAIN)
-  2014-03-20 13:23:52,502 [Thread-18] ERROR (grid.space.ThreadPool) Error encountered running task: SpaceChangePollerTask-323-Space:MAIN of class com.splwg.base.support.grid.space.SpaceChangePollerTask
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.grid.space.AbstractTransactionalTask.runOutsideTransaction(AbstractTransactionalTask.java:31): Exception running taskSpaceChangePollerTask(SpaceChangePollerTask-323-Space:MAIN)
com.splwg.base.support.context.ApplicationContext.createThreadBoundSession(ApplicationContext.java:580): Caught exception from SessionExecutable.execute()
com.splwg.base.support.sql.OracleFunctionReplacer.initializeConnectionForNewSession(OracleFunctionReplacer.java:259): Error initializing framework session

The root LoggedException was: Unexpected exception while setting db context user to 'F1SYSUSR'
at com.splwg.shared.common.LoggedException.wrap(LoggedException.java:150)
at com.splwg.base.support.sql.OracleFunctionReplacer.setClientIdentifier(OracleFunctionReplacer.java:404)

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.