Gyrus Knowledge Base
Article Number:		04992251
Article Title:		Error in SP_WIZARD_INIT when starting Training Wizard

Training Wizard 98, schema 197 through 209

After logging into Training Wizard, you may sometimes receive a SQL error with the following description:

Warning, null value eliminated from aggregate.

The error occurs when the stored procedure sp_wizard_init is automatically run as Training Wizard loads.

The error actually occurs within another stored procedure, named sp_completecurriculum, that will get called by sp_wizard_init. One of the functions of this stored procedure is to set the completion date of a student's curriculum when that student has completed all of the courses in that curriculum. This will fail with the above error if the following is true:

The student is enrolled into multiple classes of the same course.
All of these classes are completed.
The student does not have a completion date for all of these enrollments.
The course is part of the student's curriculum.
The student has completed every course in their curriculum at least one time.

This problem has been fixed in Training Wizard 2001 3.0.23. Upgrading to this release will eliminate this defect.

If you are still running Training Wizard 98 with schema 197 through 209, you may patch your database. A revised version of SP_COMPLETECURRICULUM is available that will eliminate this error. You may download a SQL script that will patch your database and fix this problem from one of the following locations (based on the DBMS engine you are using):

• For Oracle: ftp://web.gyrus.com/patches/04992251/oracle.sql
• For SQL Server 6.5: ftp://web.gyrus.com/patches/04992251/mssql65.sql
• For SQL Server 7: ftp://web.gyrus.com/patches/04992251/mssql7.sql
• For Sybase SQL Anywhere: ftp://web.gyrus.com/patches/04992251/sybase.sql

04002143 - Summary Of Changes In Training Wizard 2001 3.0.23

THIS INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. GYRUS SYSTEMS DISCLAIMS ALL WARRANTIES, EITHER EXPRESSED OR IMPLIED. GYRUS SYSTEMS SHALL NOT BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS, OR SPECIAL DAMAGES, EVEN IF GYRUS SYSTEMS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

For additional assistance send email to support@gyrus.com or phone technical support at 1-800-284-9787
Gyrus Systems, Inc. is located at Gyrus Center, 620 Moorefield Park Drive, Richmond, VA 23236-3692.
Office Phone: (804) 320-1414 Office Fax: (804) 320-2323 Located on the web at www.gyrus.com