My Oracle Support Banner

Oracle Realtime Scheduler Slot Booking is Not Working and Postbox Table Populated With Millions of Records (Doc ID 1089805.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Real-Time Scheduler - Version 10.1.0 to 1.13.0 [Release 10.1 to 1.13]
Information in this document applies to any platform.

Symptoms


Users are unable to book orders through slot requests. Millions of records are in the POSTBOX table and an extra process is in the PROCESS_STATUS table where the PROC_NAME =  "rts_ws.exe".  The POSTBOX table cleared and began to process normally when the Oracle Realtime Scheduler (ORS) Resource Manager Web Service process (rts_ws.exe) was deleted from the PROCESS_STATUS table.

Information to Gather for Issue Clarification:

1. If a process sent the Web Service a SYNC_PLAN request it can be seen in the Web Service logs. The following UNIX command will search  the logs for such an event.


5.  Obtain a dump of the POSTBOX table before clearing any records.

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
 Information to Gather for Issue Clarification:
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.