M1_Alert Records Creating Database Contention, Slow Dispatching and Unresponsive CDI Portal (Doc ID 1596274.1)

Last updated on JUNE 16, 2017

Applies to:

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

Goal

We are experiencing a mass blocking situation when schedulers are running. System is almost unusable (almost no dispatches to PDA, application servers not responding). The issue appears as soon as the schedulers are booted and seems that schedulers and online operation compete for M1_SCHED_REG records.
 

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