My Oracle Support Banner

Unable To Save A Periods of Unavailability Getting Time Out Error Due to 1000+ Records (Doc ID 2127309.1)

Last updated on JUNE 05, 2024

Applies to:

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

Symptoms

Unable to save a Periods of Unavailability (POU) getting time out error

There is a POU created in production having occurrences created till 2029. Now, when trying to edit and change the occurrences it is giving a time out and error and hence cannot be edited.

ERROR
-----------------------
Invalid field values [501419281925] for foreign key reference code M1-CREW

And then Query Time out message.

The crew 501419281925 is existing in production and both the mobile worker and crew are active. But this crew is not for which the POU is being edited, not sure why it is processing this crew.

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.