Maintenance Module Bug Fixes:
SQLServer2000 date
conversion problem in non-US systems - Students may be dropped
prematurely. Control program cannot save purge criteria.
"Drop Inactive
Students" not working.
Date: October 17, 2003
Version affected: v1.61 Maintenance Module
Symptoms:
SQLServer2000 date conversion problem in non-US systems - Students may be dropped prematurely. In installations running against SQLServer2000 where the database server is using a non-US date format (yy/dd/mm rather than yy/mm/dd), confusion about how the date is to be converted may cause an error. For dates which are valid in either format data purge, certificate expiration, or auto-drop of courses may occur prematurely. An example of this would be a maintenance module run on August 12, 2003. The value presented to SQLServer in SQL statements would be in ODBC Canonical format. ie: CONVERT(datetime,'2003-08-12 00:00:00')
For US systems this would be interpreted as August 12, 2003. For European systems this would be interpreted as December 8, 2003 causing premature data purge. This is the same problem corrected for the Web Module by patch160_2.
Control program cannot save
purge criteria.
Once a checkbox on the "History Table Maintenance"
tab of the maintenance module control program is checked and saved futher
changes to that tab are no longer saved.
"Drop Inactive Students" not working.
If a student has
never entered a particular course the "Drop Inactive Students" feature will not
work for that assignment.
Correction:
SQLServer2000 date
conversion problem in non-US systems - Students may be dropped
prematurely.
It appears that SQLServer 2000 no longer recognizes ODBC
Canonical date format (yyyy-mm-dd hh:mm:ss) by default. The Maintenance Module
program has been modified to include the format specifier for ODBC Canonical in
the CONVERT statement.
ie: CONVERT(datetime,'2003-08-12
00:00:00',120)
Control program cannot save
purge criteria.
A bug in the control program caused the previous
settings to reload before saving changes. This has been corrected.
"Drop Inactive Students" not working.
A bug in the SQL
statement used to identify inactive course assignments caused assignments which
never had any activity to be missed. This has been corrected.
This patch contains a updated versions of:
File Version Date wbtm_mnt.exe 1.612 10/17/2003 11:32 wbtm_mntctrl.exe 1.612 10/16/2003 15:10
After unzipping the patch file to a temporary directory, replace all copies of the above files with the new versions. Do this on all systems used to run the maintenance module (typically this would be on the web-server only).
It is not necessary to re-start the web-server.