My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.