Contents:

• M2006050901 - SQL error when upgrading Oracle database from 1.8 to 1.9.
  An error in the database upgrade script oracle_112_to_113.sql results in a SQL error message on some Oracle systems when upgrading from version 1.8 to 1.9 of WBT Manager.
  
  If you have already attempted the upgrade and encountered the following error message please contact customer support for assistance.
  
  (S1000)[Oracle][ODBC][Ora]ORA-02270: no matching unique or primary key for this column-list ALTER TABLE CLASSES ADD CONSTRAINT classes_FK3 FOREIGN KEY (certexp_id) REFERENCES certexp (certexp_id)

• M2006051001 - Sample task plan for version 1.9 upgrade is missing the list of scripts in the database upgrade step.

• M2006051002 - Installation and Customization manual lists wrong sql script in sample task plan for Oracle upgrade.
  The Oracle database script section in the sample upgrade task play listed report_views_sqlserver.sql instead of report_views_oracle.sql.

Note: The corrected script has been added to version 1.9 installation set as of May 20, 2006. If you downloaded your installation set after that date then you will have the correct script.

Installation:

1. Unzip the patch files to a temporary directory.
2. Replace the version of oracle_112_to_113.sql found in your copy of the installation set (utilities\database\scripts directory) with the version in this patch
3. Replace the versions of installcust.pdf and taskplan.rtf found in your copy of the installation set (documentation directory)
4. Upgrade your system from version 1.8 to 1.9 using the new script.

Version 1.9 Patches