Gyrus Knowledge Base
Article Number:		04002146
Article Title:		Removing Sample Data and then adding Sample Data generates SQL errors

Training Wizard 98 (all versions)

If you add Sample Data, then remove Sample Data and then add Sample Data again, you will sometimes encounter SQL errors.

The SQL script used to removed Sample Data was not properly deleting all Event records relating to self-paced registrations. Because these records were not removed, integrity constraint violation (duplicate primary key value) would be encountered if Sample Data was added back to the database. Note that the choices of which Sample Data set to add does not affect this scenario.

This problem has been resolved in Training Wizard 2001.

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