Contents:

M2006042101 - Scheduled training attendance report shows students with canceled reservations.
Students with canceled reservations were appearing on the Scheduled Training Attendance report. This has been corrected.

M2006051701 - Date range not enforced in the "Scheduled Training Attendance Report".
If a date range was selected when running the "Scheduled Training Attendance Report" and "All" course sections were reported on then the report included sections outside of the selected date range. This has been corrected. The report will no longer show course or lesson sections outside the the selected date range.

M2006053101 - Date selector won't select June on May 31.
On days near or on the end of the month the date selector would not allow the user to select a month which contained fewer days than the current date. For example, since June has only 30 days, on May 31 a date in June could not be specified. This has been corrected.

M2006053102 - core_vendor truncated to 98 characters under oracle oledb connection with oracle 9.
A compatibility problem between some places in the web-server application and LONG VARCHAR columns when running under the Oracle OleDB Provider (required for the Oracle 9.x client software) was causing some data elements to be truncated. Specifically, places in the application where a SQL join resulted in more than one LONG column to be included in the column list of a SELECT statement resulted in all long columns in the list to be truncated to 98 characters. This affected the core_vendor field in the "Enter/Edit Results" function and several fields in the communications interface for the Offline Student Module.
A script has been provide to convert the affected data columns to from LONG VARCHAR to CLOB. In the next release of WBT Manager all LONG VARCHAR columns will be converted to CLOB or NCLOB.

M2006060601 - SQL error in Training Schedule (by Date) report.
A SQL error of "ORA-00933: SQL command not properly ended" was encountered when running the "Training Schedule (by Date)" report. This has been corrected

M2006021501 - ILT calendar report shows some dates in mm/dd format even when system date format is dd/mm
(Eur format).
The ILT Calendar report includes dates in month/day format to indicate the starting date of a week. On systems where UK date format (dd/mm/yyyy) is used the week starting dates were still displayed as mm/dd instead of dd/mm. This has been corrected.

M2006020201 - SQL error in Course Results report for long reports
For reports on large populations of students the "Course Results" report displayed an "unable to connect or SQL Server not found" error message under SQL Server. The report has been modified to correct this.

Installation:

First unzip the patch files to a temporary directory. Copy the ASP and XSL directories to the web-server where WBT Manager is installed.

Database Schema:

Oracle users:
Several column definitions must be changed from LONG VARCHAR to CLOB. The indices on the affected tables must also be rebuild. The rebuild process could take significant time. You may want to do a trial run against a copy of your production database to estimate how long the system will be out of service.

Perform a database backup (very important).

Launch the runSQL.exe program found in the database directory in this patch.

Connect to the WBT Manager database and log on as the wbtmanadmin user (or whatever user account was used to create the WBT Manager tables).

Execute the oracle_longtoclob1.sql script found in the database directory in this patch. It should execute with no errors.

Web-Module:

On the web-server where the WBT Manager Web-Server Application is installed:

Copy To

asp\r_adm2.asp ASP directory

asp\r_adm4.asp ""      ""

asp\r_adm7.asp ""      ""

asp\r_adm8.asp ""      ""

asp\r_adm9.asp ""      ""

asp\r_stu5.asp ""      ""

asp\dtpickjs.asp ""      ""

xsl\dtpick.xsl HTML\XSL directory

xsl\dtpickns4.xsl ""      ""

Replaced files

Web-Module
Destination	File	Version	Date
	dtpickjs.asp		2006/05/31 3:51 PM
	r_adm2.asp		2005/12/29 1:18 PM
	r_adm4.asp		2006/02/02 4:16 PM
	r_adm7.asp		2006/05/23 2:58 PM
	r_adm8.asp		2006/02/15 3:58 PM
	r_adm9.asp		2006/06/12 11:32 AM
	r_stu5.asp		2006/02/15 4:00 PM
<web-dir>/xsl	dtpick.xsl		2006/05/31 2:57 PM
	dtpickns4.xsl		2006/05/31 3:45 PM

*end of file*

Copy	To
asp\r_adm2.asp	ASP directory
asp\r_adm4.asp	"" ""
asp\r_adm7.asp	"" ""
asp\r_adm8.asp	"" ""
asp\r_adm9.asp	"" ""
asp\r_stu5.asp	"" ""
asp\dtpickjs.asp	"" ""
xsl\dtpick.xsl	HTML\XSL directory
xsl\dtpickns4.xsl	"" ""