[SCHEDULER-569]  Monitor Mode rescheduling prematurely
Type Bug
Priority High
Severity Major
Component Dispatch Scheduler Engine
Fixed In Version [3.33.3
Versions Affected [3.23.2
Severity Closed
Resolution Complete
Reported By Bob Denny
Resources Bob Denny
Start Date 1/17/2011

Description
See attached files to make a repro scenario. The log shows that Monitor Mode is requeueing a request if it just completed best sfforts or failed strict constraints or??? Look at the log. It keeps happening over and over. This is a major bug!

Comments
1/17/2011 1:19:37 PM   Bob Denny
SVN Comment
Author rbdenny
Repository svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
SVN Revision 144
Affected files /trunk/Database/Database.cs (Modified)
/trunk/Empty SchedulerData.mdb (Modified)
/trunk/Help/RelNotes.htm (Modified)
/trunk/Scheduler/AssemblyInfo.cs (Modified)
/trunk/SchedulerSetup/Custom Actions/UpdateDatabase.vbs (Modified)
/trunk/SchedulerSetup/SchedulerSetup.vdproj (Modified)
Check-in comment Correct SelectPlansForMonitorMode SQL query, database -> 2.2, many dependent changes. GEM:569
1/17/2011 12:26:28 PM   Bob Denny
S**t, the database upgrader in the installer had the wrong/incorrect database query for selecting plans for monitor mode requeueing. It was missing the date/time constraint in the SQL. The EmptySchedulerData.mdb template was correct. This affects only older databases that are being upgraded.

This will cause the DB to go to version 2.2.