Oracle Realtime Scheduling (ORS) v1 Database Updates Stuck In 'Initiated' Due to GUI or Process Running With a Different or Invalid Timezone
(Doc ID 1097777.1)
Last updated on JULY 27, 2022
Applies to:
Oracle Real-Time Scheduler - Version 10.3 and laterInformation in this document applies to any platform.
Symptoms
Some updates to ORS are not processing.e.g. SELECT * FROM resource_manager.stop a WHERE a.stop_id = '107054132/T1'
The update is stuck in ‘initiated’, however reports success in web service.
This example is from 8am, but by 4pm the customer had 30 outstanding database updates stuck in INITIATED which caused quite a problem for schedulers allocating work to techs throughout the day since the current status was not known. Manual intervention was required to reprocess. These stuck statuses happened throughout the day.
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 |