Patch 7 - Bug fixes

Date: January 5, 2006 

Version affected: v1.80.

Notes:

Contents:

Installation:

First unzip the patch files to a temporary directory. Copy the web_module directory to the web-server where WBT Manager is installed. Copy the admin_module directory to each system where the WBT Manager System Administrator module is installed (or to a network directory accessible to each of those systems). Copy the student_import_tools directory to each system where the WBT Manager Import Tools are installed (or to a network directory accessible to each of those systems). Copy the maint_module directory to each system where the WBT Manager Batch Maintenance Module is installed (or to a network directory accessible to each of those systems).

Web-Module:

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

Note the NTFS permissions on the WBT Manager DLLs (see "Replaced Files" list below) in the Windows/System32 directory.

If you have a translated version of WBT Manager or have customized the string table (strings.txt ) make a backup copy of strings.txt and update it as described in string table changes below.

If you have customized the file emailpw.inc in the web-module's ASP directory you will need to update your customized version. The version that will be installed by the patch can be found in web_module\standard_files\asp.

If you have customized the email wrapper component (wbtmanemail.dll or wbtmanemail.sct ) get a customized copy of the new version ready. The source for the new version is in utilities\emailcomponent.

If you have customized the standard event handler (wbtman5qp.dll) get a customized copy of the new version ready or make a backup copy of your current version.

Stop IIS web services (skipping this step may cause a system re-boot to be required after installing the patch).

Run the setup.exe program found in the patch's web_module directory. When prompted for the installation directory select the directory where the WBT Manager web-module is installed.

Install the customized copies of emailpw.inc, wbtmanemail.dll, and/or wbtman5qp.dll if necessary (the dlls will need to be registered with regsvr32.exe). 

When the installation is complete re-start IIS. Run the reload.asp script in a browser to verify the installation. If any errors occur verify that the NTFS permissions on the WBT Manager DLLs have not changed. Correct if necessary and re-run reload.asp.

Administrator Module:

On each system where the WBT Manager System Administrator Module is installed:

Run the setup.exe program found in the patch's admin_module directory. When prompted for the installation directory select the directory where the WBT Manager System Administrator Module is installed.

Student Import Utility:

On each system where the WBT Manager Import Tools are installed:

Run the setup.exe program found in the patch's student_import_tools directory. If prompted for the installation directory select the directory where the WBT Manager System Administrator Module is installed.

Batch Maintenance Module

On each system where the WBT Manager Batch Maintenance Module is installed:

Run the setup.exe program found in the patch's  maint_module directory. Select the "repair" option. This will update the directory where the module was initially installed. If additional copies of the directory were made to allow for multiple databases then the files listed for the Batch Maintenance Module under "Replaced Files" below should be copied to each directory.

Installation Set Updates

Replace the copies of utilities\site_configuration\wbtmconfig.exe, utilities\conversion_tools\shared_status\sharestats.exe, utilities\conversion_tools\status_rebuild\rebstat.exe, documentation\instcust.pdf, and the contents of the utilities\emailcomponent and utilities\eventqueue directories in your copy of the WBT Manager 1.8 installation set with the versions in this patch. Or download a new copy of the installation set from http://www.ielearning.com/wbt/trial/application/wbtm180.zip.

String Table Changes

This patch will replace the string table (strings.txt ) used by the web module. If you have a translated version of WBT Manager you will need to obtain a new version from your reseller or add the new strings to your existing file.

To update the file yourself:

  1. Make a copy of your existing strings.txt file.
  2. Translate and add the following new entries to the file.
    214028,Expiration date:
    214029,Target date:
    214030,Your completion target date for "%1" has been passed.
    214031,Your completion target date for "%1" is approaching.
    214032,Course Completion Target Date Passed
    214033,Course Completion Target Date Approaching
  3. Install the patch.
  4. Replace the patch's strings.txt file with your updated one.

Replaced files

System Administrator Module
Destination File Version Date
Program Files\
Integrity eLearning\
WBT Manager 1.8 		 wbtman.exe 1.8.0.3 2005/02/05  3:36 PM
Program Files\
Integrity eLearning\
WBT Manager 1.8 		 impexp.exe 1.8.0.3 2005/01/21  4:12 PM
 
Student Import Utilities
Destination File Version Date
Program Files\
Integrity eLearning\
WBT Manager 1.8\
Import Tools 		 wbtmanager2.dll 1.8.0.2 2005/01/28  5:52 PM
Program Files\
Integrity eLearning\
WBT Manager 1.8\
Import Tools 		 importtools.hlp 2005/02/10 12:42 PM
 
Web-Module
Destination File Version Date
\winnt\system32\  wbtman5a.dll 1.8.0.3 2005/07/11 11:46 AM
\winnt\system32\  wbtman5b.dll 1.8.0.2 2005/02/03 10:46 AM
\winnt\system32\  wbtman5c.dll 1.8.0.2 2005/02/03 10:47 AM
\winnt\system32\  wbtman5d.dll 1.8.0.2 2005/02/03 10:40 AM
\winnt\system32\  wbtman5f.dll 1.8.0.2 2005/02/03 10:49 AM
\winnt\system32\  wbtman5g.dll 1.8.0.2 2005/02/03 10:51 AM
\winnt\system32\  wbtman5h.dll 1.8.0.3 2005/07/11 11:47 AM
\winnt\system32\  wbtman5m.dll 1.8.0.2 2005/02/03 10:55 AM
\winnt\system32\  wbtman5qp.dll 1.8.0.1 2005/07/11  3:07 PM
\winnt\system32\  wbtmanemail.dll 1.9.0.0 2005/07/11 12:33 PM
\winnt\system32\  wbtmanemail.sct 1.9.0.0 2005/07/11  2:17 PM
\winnt\system32\  wbtman5t2.dll 1.8.0.3 2005/07/22  9:05 AM
<web-dir>  strings.txt 2005/02/23  8:31 AM
<web-dir>  global.asa 2005/07/11  1:10 PM
<web-dir>  reload.asp 2005/07/11  1:10 PM
<web-dir>/asp  admin.asp 2005/07/22  9:09 AM
<web-dir>/asp  admin2.asp 2005/07/22  9:09 AM
<web-dir>/asp  admin3.asp 2005/07/22  9:10 AM
<web-dir>/asp  admin4.asp 2005/07/22  9:10 AM
<web-dir>/asp  aicc_int.asp 2005/12/21  1:46 PM
<web-dir>/asp  aicc_int_c1.asp 2005/12/21  1:36 PM
<web-dir>/asp  clsmenu.asp 2005/05/06 10:15 AM
<web-dir>/asp  emailpw.inc 2005/05/10  4:19 PM
 <web-dir>/asp  iltregmsg2.asp 2005/07/11  1:03 PM
 <web-dir>/asp  iltcedit1.asp 2005/08/02  9:50 AM
<web-dir>/asp   kiosk2.asp 2004/10/04  3:32 PM
<web-dir>/asp  kiosk.asp 2004/10/04  3:38 PM
 <web-dir>/asp  orgdic2.asp 2005/07/22  9:07 AM
 <web-dir>/asp  orgdic3.asp 2005/07/22  9:08 AM
 <web-dir>/asp  orgdic4.asp 2005/07/22  9:08 AM
<web-dir>/asp  r_adm2.asp 2005/12/29  1:11 PM
<web-dir>/asp  r_adm4.asp 2005/09/09  9:18 AM
<web-dir>/asp  r_adm7.asp 2005/03/24  9:32 AM
<web-dir>/asp studmsgs.asp 2005/02/25 11:52 AM
<web-dir>/asp  wbtconst.inc 2005/02/25 11:53 AM
<web-dir>/html/xsl clsmenu.xsl 2005/02/06 10:18 AM
<web-dir>/html/xsl  coursesellistcrs.xsl 2005/07/05  2:27 PM
<web-dir>/html/xsl  crssel1a.xsl 2005/07/05  2:58 PM
<web-dir>/html/xsl  crssel3.xsl 2005/07/05  2:28 PM
<web-dir>/jar  kiosk2.jar 2004/10/04  3:42 PM
<web-dir>/jar  kiosk.jar 2004/10/04  3:36 PM
<web-dir>/jar  lmsapi.cab 2005/02/07  1:54 PM
<web-dir>/jar   popwindow.js 2005/10/04  3:43 PM
 
Batch Maintenance Module
Destination File Version Date
<Installation dir > wbtm_mnt.exe 1.8.0.3 2005/08/05 11:08 AM
  wbtm_mntctrl.exe 1.8.0.1 2004/12/23 11:17 AM
  wbtmmnt.hlp 2004/12/27 03:51 PM
  wbtmmnt.cnt 2004/12/27 03:49 PM
crstargetexpired_s.txt 2004/12/28  1:05 PM
  crstargetexpired_ca.txt 2004/12/28  1:05 PM
crstargetexpired_ra.txt 2004/12/28  1:05 PM
crstargetexpired_diva.txt 2004/12/28  1:06 PM
  crstargetexpired_oa.txt 2004/12/28  1:05 PM
crstargetexpired_da.txt 2004/12/28  1:06 PM
  crstargetexpired_c.txt 2004/12/28  1:05 PM
crstargetexpiring_s.txt 2004/12/28 12:54 PM
crstargetexpiring_ca.txt 2004/12/28 12:55 PM
crstargetexpiring_ra.txt 2004/12/28 12:54 PM
crstargetexpiring_diva.txt 2004/12/28 12:55 PM
crstargetexpiring_oa.txt 2004/12/28 12:54 PM
crstargetexpiring_da.txt 2004/12/28 12:55 PM
crstargetexpiring_c.txt 2004/12/28 12:55 PM
 
Utilities
Installation set
location            		 File Version       Date
utilities\
conversion_tools\
shared_status 		 sharestats.exe 1.8.0.2 2005/01/28  6:05 PM
utilities\
conversion_tools\
status_rebuild 		 rebstats.exe 1.8.0.2 2005/01/28  6:08 PM
utilities\
site_configuration 		 wbtmconfig.exe 1.8.0.2 2005/01/28  6:01 PM
 

Version 1.8 Patches

 

 

Prior patches

Patch 6 - Bug Fixes

Patch 5 - Oracle 9 support and bug fixes

 

Oracle configuration notes

Please read these notes carefully and pay attention to the red "cautionary" notes.

See the section below for the version of Oracle you are using.

Oracle 8.1.5:

Application

Driver & version

 

Net-8 8.1.5.0.0
(required by all applications) 

System Administrator Module

Oracle 8i ODBC Driver 8.1.5.5.0 

Web-Server Application
Student Import Tools
Site Configuration Utility

Microsoft ODBC for Oracle 2.575.1022.00 or later

Oracle 8.1.7:

Application

Driver & version

 

Net-8 8.1.7.0.0
(required by all applications) 

System Administrator Module

Oracle 8i ODBC Driver 8.1.7.8.10
WARNING: earlier versions of this driver will
result in errors during database access.

Web-Server Application
Student Import Tools
Site Configuration Utility

Microsoft ODBC for Oracle 2.575.1022.00 or later

Oracle 9.0.1:

Application

Driver & version

 

Oracle client 9.0.1.1.1
(required by all applications) 

System Administrator Module

Oracle 9 ODBC Driver 9.0.1.8.0
WARNING: Using the System Administrator application or Course Import application from versions prior to this patch (1.8.0.3) will result in unexpected loss of course structure information from the database. Identify and upgrade all WBT Manager version 1.8 copies of wbtman.exe and impexp.exe from administrator systems before attempting to use this driver.

Web-Server Application

Oracle OleDB provider 9.0.1.0.1

Configuration: Modify the "connectionstring" keywork in the "[database]" group in appsettings.ini to use OLEDB instead of an ODBC DSN. The following is an example (it should be on a single line in appsettings.ini):

connectionstring=Provider=OraOLEDB.Oracle;
    Data Source= <oracleservicename>;
   UserId=%%uid%%;Password=%%pwd%%

Student Import Tools
Site Configuration Utility

Oracle OleDB provider 9.0.1.0.1
Oracle 9 ODBC Driver 9.0.1.8.0

Note: Log onto the utilities using an Oracle ODBC DSN. Internally the utilities will detect this and reconnect using the OraOLEDB provider.

Oracle 9.2.0:

Application

Driver & version

 

Oracle client 9.2.0.1.0
(required by all applications) 

System Administrator Module

Oracle 9 ODBC Driver 9.2.0.6.3

WARNING: Using the System Administrator application or Course Import application from versions prior to this patch (1.8.0.3) will result in unexpected loss of course structure information from the database. Identify and upgrade all WBT Manager version 1.8 copies of wbtman.exe and impexp.exe from administrator systems before attempting to use this driver.

WARNING: Oracle ODBC Driver 9.2.0.6.5 does not work properly with WBT Manager.

Web-Server Application

Oracle OleDB provider 9.2.0.4.0

Configuration: Modify the "connectionstring" keywork in the "[database]" group in appsettings.ini to use OLEDB instead of an ODBC DSN. The following is an example (it should be on a single line in appsettings.ini):

connectionstring=Provider=OraOLEDB.Oracle;
    Data Source= <oracleservicename>;
   UserId=%%uid%%;Password=%%pwd%%

Student Import Tools
Site Configuration Utility

Oracle OleDB provider 9.2.0.4.0
Oracle 9 ODBC Driver 9.2.0.6.3

Note: Log onto the utilities using an Oracle ODBC DSN. Internally the utilities will detect this and reconnect using the OraOLEDB provider.

Oracle 10.0

Oracle 10 client software has not yet been tested with WBT Manager. It is recommended that you use one of the configurations listed above for earlier Oracle versions to access Oracle 10 databases.

Patch 4 - Maintenance Module Bug Fixes.

The controls for "target date" notifications were not being enabled, disabled, and initialized on the dialog properly when checkboxes were checked and cleared.

The "repeat days" for certificate expiration warnings for "central site notification" were being reset to the default each time the control program was launched.

The property page order was not logical for the student hierarch elements.

"look-ahead" logic used to identify pending expiration of courses, certificates, and target dates was not finding items on the date indicated in the control program. ie: if 5 were entered as the warning days in the control program and the program was run on 12/25/2004 then items expiring on 12/30/2004 would not be identified. They would be identified if the program was run on 12/26/2004.

Patch 3 - Cannot delete Reference Item if it has been launched.

  • M2004122001 - Cannot delete Reference Item if it has been launched.
    Database integrity constraints did not allow a Reference Item to be deleted if it had been launched. An error message similar to the following was displayed when a delete was attempted:

    :DeleteReference().
    The record cannot be deleted or changed because table 'BEVENT' includes related records. State:S1000,Native,-1612,Origin:[Microsoft][ODBC Microsoft Access Driver}

    The delete function was not clearing entries in the BEVENT table related to the launch of the Reference Item. This problem has been corrected.

 

Patch 2 - Version 1.8 bug fixes.

  • M2004101101 - Self-Registration script makes all UserText fields lower-case
    When the user-defined text fields (text1-text10) were included on a self-registration form which called regstud.asp to add a student their contents were forced to lower case prior to being stored in the student record. This has been corrected. 
  • M2004101201 - Self-registration script does not save multiple audience categories when sent by form post.
    When audience categories (audcat) were included on a self-registration form which called regstud.asp to add a student only the first specified category was associated with the student. Additional categories were ignored. This has been corrected.
  • M2004102901 - System Admin login fails if DB Password less than 5 characters long.
    For those DBMSs which require a database password (SQLServer, Oracle), if the password was less than 5 characters in length it was not recovered properly when the System Administrator Module was launched. The password had to be re-entered each time the Administrator Module was launched. This has been corrected.
  • M2004110201 - Mastery Score and Max Score default to 0
    A change was made in version 1.8 to allow a mastery score and a max score of 0 to be used. In prior versions this value was used to indicate the absence of a master score or max score. The System Administrator module was defaulting these values to "0" for new lessons and level 2 hierarchy elements (organizations). This has been corrected.
    Note: mastery score and max score are found on the "AICC/SCORM Data" tab in lesson properties. An override value for mastery score is also found on the "Misc" tab of level-2 student hierarchy elements.
  • M2004110401 - Student import logs primary key constraint error when adding departments
    The initial 1.8 version of the student import component was using the wrong counter to assign the internal ID values for new departments (level-1 hierarchy elements). This results in a "duplicate primary key" error when attempting to add new deparments. This has been corrected and a utility provided to correct the affected counter.
  • M2004110301 - User id block shows all 5 levels even if less than 5 are enabled.
    Version 1.8 added 3 new student hierarchy levels. It allows the number of visible levels to be configured. The web-module was showing all 5 levels regardless of the number of visible levels configured. This has been corrected and an option added to allow all levels to be displayed.
  • M2004100501 - Window focus controls do not work in kiosk mode for NS or Mozilla. Lesson window goes behind course window (patch180_1).
    Changes in the way that Netscape 6+ and Mozilla behave with signed scripts (as different from NS4) caused the window focus controls to stop working properly when a course or lesson was launched in full-screen (kiosk) mode. This has been corrected.

 

Patch 1 - Window focus controls do not work in kiosk mode for NS or Mozilla.
  • M2004100501 - Window focus controls do not work in kiosk mode for NS or Mozilla. Lesson window goes behind course window.
    Changes to window focus control logic made in a previous release were not included in the signed scripts required by Netscape and Mozilla browsers for full-screen mode. When a lesson is selected from a full-screen course menu the lesson window does not always remain on top.