No Appointment Slots Returned While RMGW Not Reading From Database With 'Ora-21780: Maximum Number Of Object Durations Exceeded' (Doc ID 1304216.1)

Last updated on MARCH 03, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 1.5.0.10 and later   [Release: 1.5 and later ]
Information in this document applies to any platform.

Symptoms

Users report that they are unable to receive appointment slot requests from ORS. Errors are shown in RMGW logs stating:

RMGW260 24/09/10 13:00:14.95 WARNING: assertion << Failed to select from process_status: ORA-21780: Maximum number of object durations exceeded.^JQOCI: Unable to execute select statement >> failed in gen\src\rmGen\postBox.c at line 891: continuing.

Also, no shifts are shown in the Planner Client. Restarting the Resource Manager Gateway service clears the problem.

Cause

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