SQL error in AICC interface when "Store score and status for each attempt" is checked.

Date: January 14, 2003

Version affected: v1.61 This patch is included in the 1.61 upgrade patch if downloaded after 1/14/2003.

Symptoms:
When a lesson is set to "Store score and status for each attempt" (Lesson properties, "Flags" tab) the ISTATS table does not receive any information. (ISTATS is intended to contain the individual session statistics). If interface debugging is enabled then the log file shows the following error message during the ExitAU request (actual data will vary):

Module: /wbtmanager/asp/aicc_int.asp
At: AddIndividualStats
Statement: insert into istats ( stud_id, course_id, lnktype, lnk, instnc, lastdt, status, fscore, ftottime,instruc_id,secrefid ) values (1060,1055,'L',1283,6,#2003-1-13 9:8:34#,'i',null,5789null,null) Error In: Microsoft OLE DB Provider for ODBC Drivers
Error Code: -2147217900
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '5789null'. SQLState: 37000

Cause:
A programming error resulted in an invalid SQL statement (missing comma) that was not caught during testing.

Correction:
A new version of the interface DLL has been provided which corrects the SQL statement.

wbtman3g.dll

version 1.61.0.2

Installing the patch file

1. Unzip the patch file to a temporary directory on the web-server
2. Stop IIS by starting a console prompt and entering net stop iisadmin
3. Move the DLL to the system32 directory on the web-server
4. Use file properties to verify that the new dll has the same NTFS security settings as the other WBT Manager dlls (wbtman3a.dll for instance).
5. Start IIS by starting a console prompt and entering net start w3svc
6. Use the services applet on the control panel to restart FTP and SMTP services if needed.

Version 1.6 Patches