Patch 5 - Bug fixes
Date: Sept 25, 2007
Version affected: v1.90.
Notes:
Contents:
- M2007031301 - SQL error in one-click menu under FireFox.
Under FireFox, when a the "one-click" menu style is used and error message:
"cannot insert duplicate key in object BEVENT"
is displayed. This has been corrected.
- M2007041901 - Submit button on ILT available course section page in Schedule ILT function results in type mismatch error.
The ILT available course section page uses text links to select a section. The "Submit" button should not display
on that page and has been removed.
- M2007051501-Student selector in reports function takes administrators into assign course or edit results functions.
The "back" button in the student selector was not being initialized properly when the selector
was called from the report criteria form. This caused the system to display pages from the last
fuction in which the student selector was used instead of returning to the report criteria page.
This has been corrected.
- M2007051801 - SQLServer error in long-running Course Results and Course Progress reports.
When running against the MS SQLServer DBMS the "Course Results" and "Course Progress" reports in the
web module return error messages when large volumes of data are included. Typical error message:
SQL Server does not exist or access denied
This has been corrected.
- M2007092001 - Department selector in student edit does not show all departments.
When a level 1 student hierarchy element (department) had a name identical to
the name of the preceding department belonging to the preceding level 2
hierarchy element (organization, as displayed in the System Administrator
module's main navigation tree) then the department did not display on the
department selector used in the student edit function. this has been corrected.
- M2007061101 - Student import utility rejects students with SQL error.
Student records were being rejected with the error message "Invalid column name 'c13'".
The counters table was not being initialized properly when new databases were being created.
The initdb.sql included in the current installation set has been corrected to prevent
this error. If you encounter this error in a live system please contact customer support.
- M2007040501 - Reset course sets course status to "I" instead of "N" in the system administrator module.
The behavior of the "Reset Stats" was
changed in version 1.9 to set a course's status back to "Not Attempted"
instead of "Incomplete". The System Administrator module was still setting the
status to "Incomplete". This has been corrected.
Installation:
First unzip the patch files to a
temporary directory. Copy the web_module directory to the web-server where WBT
Manager is installed.
System Administrator Module:
On each system where the WBT Manager System Administrator Module is
installed.
Copy the contents of the administrator_module
folder to the directory where the System Administrator module
was installed (default installation folder is "C:\Program Files\Integrity
eLearning\WBT Manager 1.9").
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\report.asp |
"" "" |
| asp\selectorg.asp |
"" "" |
| xsl\crssel1a.xsl |
XSL directory |
| xsl\crssel3.xsl |
"" "" |
| xsl\noclick.xsl |
"" "" |
Replaced files
| System Administrator Module |
| Destination |
File |
Version |
Date |
| Program Files\Integrity eLearning\WBT Manager 1.9 |
wbtman.exe |
1.9.0.2 |
2007/04/05 11:02 AM |
| |
|
|
|
| Web-Module |
| Destination |
File |
Version |
Date |
| <web-dir>/asp |
r_adm2.asp |
|
2007/05/18 1:13 PM |
| |
r_adm4.asp |
|
2007/05/18 1:34 PM |
| |
report.asp |
|
2007/10/19 9:53 AM |
| |
selectorg.asp |
|
2007/09/21 11:16 AM |
| <web-dir>/xsl |
crssel1a_a.xsl |
|
2007/04/19 3:10 PM |
|
crssel3.xsl |
|
2007/04/19 3:13 PM |
|
noclick.xsl |
|
2007/03/13 4:26 PM |
Version 1.9 Patches
Patch 1 - Bug
fixes.
- M2005111701 - max_normal check
counts lessons in all courses when shared status enabled.
On a
system converted for shared lesson status. If a course had a restriction
on the number of lessons allowed in an incomplete state ("Max concurrent
lessons" on the "Startup" tab). And if other courses were assigned to the same
student. Then the system would count all of the student's incomplete
lessons (regardless of which course they belonged to) against the "Max
concurrent lessons" limit. This has been
corrected.
- M2006010501 - Flag to hide
Certificate Program tree in course catalog does not hide the
programs.
There is a flag variable
in cat1a.inc which can be set
to "false" if a client does not use Certificate Programs and does not want the
"Certificate Programs" heading to appear on the course catalog page. This flag
was having no effect. This has been corrected.
- M2005092901 - "password" is
spelled "passward" in strings.txt #146021.
Instructions on
the user "Edit Profile" page had incorrect spelling of the word "password".
This has been corrected.
- M2006011301 - SQL error in
self-reg routine under Oracle.
A
SQL error displayed in the regstud.asp script under Oracle when an attempt was
made to self-register a student. This has been corrected.
- M2005082402 - Course results report ignores course category
selection.
When a Course Category
was selected as a criteria to the Course Results report all courses were
included in the report instead of only courses in the selected category. This
has been corrected.
- M2005122901 - SQL error in Course
Progress report for long reports.
Running a long Course Progress
report under SQLServer results in "SQL Server does not exist or access
denied". This has been corrected.
- M2005122101 - Browser information set incorrectly when login
expires during an API lesson.
If a
student is in a lesson which uses the SCORM API and their login session times
out then they experienced strange behavior after they returned from
the lesson unless they closed and re-opened the browser. Typical
symptoms were changes to the navigation bar color and button
spacing.
This has been
corrected.
Patch 2 - Bug
fixes.
- M2006011701 - Local administrators
cannot edit other admins that are selected using the admin selector search
function.
If a local administrator attempted to find and edit an
administrator using the administrator selector search function an error was
displayed. The desired administrator could be edited if selected by navigating
to their assigned hierarchy element using the navigation tree. This has been
corrected.
- M2006011702 - Error adding local
administrator under Access
If a local administrator was added
through the web-based local administrator interface under the Access DBMS an
error ("invalid use of null") occured. This has been corrected.
- M2005121501 - Cannot set page
delay to 0 for student account maintenance page.
If a value of "0"
was set in the pagesettings.ini [pagedelay] group for the "smaint" page, a
javascript error occured on that page instead of jumping immediately to the
student menu. This has been corrected.
- M2006012501 - Add/Edit student in
web module complains that Reference ID is duplicated even though local
administrators cannot edit Reference ID.
When a student was added
by a local administrator the system displays a message indicating that the
student's Rference ID had to be modified to make it unique even though no
Reference ID was entered because the local administrator did not have
rights to enter one. 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.
- M2006021301 -
Language dropdown on profile edit page displays HTML-encoded value for
language names.
When a language was added whose name contained
non-ASCII characters (such as "Français"), the language name displays the HTML
encoding for that name ("Français"). 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.
- M2006022701 - Adhoc reports show
incorrect TOTTIME
The Ad-Hoc report generator formats the "total
time in lesson" field as hhhh:mm:ss. The formatting code was converting the
value from the database incorrectly (the value is in seconds in the database).
When a value's remaining seconds was greater than 30, the minute value was
increased and the second value decreased. For example: if the value were 150
seconds the report would display 0000:02:30 but 151 seconds displayed as
0000:03:29 instead of 0000:02:31. This has been corrected.
- M2006011801 - Student import
returns "Entry modified by another user." if a field in the student's database
record contains trailing blanks.
When updating student records by
importing data with the student import utility, if a student record in the
database contained leading or trailing blanks in any of its
character-type columns, the update was rejected with an "Entry modified by
another user" error. This has been corrected. NOTE: this condition was very
rare and usually associated with direct manipulation of the student record in
the database outside of the WBT Manager application and
utilities.
Patch 3 - Bug
fixes.
-
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
Patch 4 - Bug fixes.
- M2007020901 - Overflow error in aicc interface
If a lesson sent a large number
of interactions in a HACP PutInteractions request (more than 32K bytes of
interaction data) the lesson interface experienced an integer overflow error
and the interaction data was not stored. This has been corrected.
M2006061401 - Adhoc reports cannot be run by
owner without being shared with other admins.
Local administrators who owned adhoc
report definitions could not see those reports when trying to run reports
unless the report was shared with other local administrators. This has
been corrected.
M2006091501 - System Admin course results reports show
"incomplete" when status is "not attempted".
Course results
reports were originally designed to show "incomplete" as a status for all
courses which were not "completed". This has caused some confusion for
clients and has been changed. Reports will not show "not attempted" for
courses which the student has not yet entered.
C2006092101 - Report selectors for org hierarchy always show all
hierarchy elements.
The selectors for each level of
student hierarchy elements on the report criteria form was
originally built to display all hierarchy elements at the level being selected
even if a selection had been made at a higher level
which should narrow the selection at lower levels. This has
been changed. When a higher-level hierarchy element has been selected the
selector will only show descendants of that element when
selecting lower-level hierarchy elements.
M2006110601 - Date selector changes Oct 31 to Oct
1.
When a user attempts to select a day of month that is greater
than the highest day number valid in the current month then the date selector
returns the wrong date (this was a side effect of changes in patch 3 for
"M2006053101 - Date selector won't select June on May 31"). This has
been corrected.
M2006120401 -
Encrypted passwords accept upper case characters.
The system
administrator module allowed users to enter uppercase characters in the
password field of student and administrator records when password format
was set to "encrypted". Since the web-module login function does not
accept uppercase characters (they are forced to lower-case) those
users were unable to log on. This has been corrected. The system administrator
module will now force passwords to lower-case before encrypting
them.
M2006113001 -
EMAILPW does not decrypt encrypted passwords.
The original lost
password email function did not decrypt the passwords on systems where
password format was set to "encrypted". This has been corrected.
M2006070701 -
API applet displays "Press SPACEBAR or ENTER to activate and use this control"
after XP update.
An update to Microsoft Internet Explorer
(required due to a patent dispute settlement) causes IE to require that a user
click on an ActiveX control or Java applet, or hit the spacebar or
enter to activate the user interface of the component. IE displays a
message to that effect for WBT Manager's SCORM API adapter applet. This
does not affect the operation of the API but can cause confusion since the
applet itself is in a hidden frame when the message displays. The course menu
has been modified to prevent the display of the warning
message.
M2007022001 -
Training schedule report does not restrict the selectable training
categories
The Training Schedule (by Course), Training
Schedule (by Date), Training Calendar, and Scheduled Training Attendance
reports either did not restrict the courses and training categories on their
criteria selection forms to the ones which the user has access to or did not
restrict the courses and training categories actually included in the report
when "All" was selected on the criteria form. This has been corrected. The
reports and their selectors will only show reports and training categories for
which the user's student hierarchy element has enrollment
access.
M2006112801 - Scripting interface message files do
not support multiple languages.
The files in the msgtemplates directory
which generate success and error pages had text hard-coded into them with
no provision for multiple language support. New files have been provided.
*end of
file*