My Oracle Support Banner

Scheduler Crashing With Long Running acquireAllActivities SQL (Doc ID 2717498.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.3.0.3.0 to 2.3.0.3.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

A Scheduler process is not coming up even after multiple restarts. The batch ends after 5 to 7 minutes post restarts.  Once the scheduler is started it crashes within ~8 mins.  Before it crashes the below SQL is long running and times out:

Changes

 

Cause

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.