=================================================================================== Notice to Autodesk Vault and Productstream Customers =================================================================================== In a continuing effort to provide high quality products, Autodesk has released this hotfix which addresses Content Center library migration, property indexing and search issues. This README file highlights how to install this hotfix, and other important information regarding this update. NOTE: Be sure to carefully follow the Installation Instructions to ensure the successful application of this hotfix. =================================================================================== CONTENTS =================================================================================== - Description of the issue - System Requirements - Related Hotfixes - Known Issues - Warnings - Files Affected - Update Verification - Installation Instructions =================================================================================== Description of the issue: =================================================================================== Updates to Autodesk Data Management Server Console 2009 exposes a SQL Server issue where SQL 2000 databases can become corrupted. The issue may also be exposed in SQL 2005 if the libraries were created in SQL 2000 and SQL is not upgraded until after the installation of Autodesk Data Management Server Console 2009. When opening the Autodesk Data Management Server Console, and when performing certain operations, an error may be generated stating "The system database login is invalid". - SQL 2000 has reached the retirement date for mainstream support - Autodesk recommends upgrading to SQL 2005 SP2 - Upgrade SQL before installing Autodesk Data Management Server 2009 This hotfix includes; - An update to correct an issue where a corrupted Content Center library could not be deleted from the Autodesk Data Management Server Console. - An update to the Autodesk Data Management Server Console to avoid further Content Center library corruptions. - A correction is also included for property extraction where a conversion from an object containing a real type to a double type causes error 227 during a search. - Improper handling of float properties in non ENU locales resulting in a failed check in with or without a 1103 error. - Corrections to search that allow a leading wildcard as part of the search criteria, including utilization in 'is' searches, and increasing search proximity for better token handling. =================================================================================== System Requirements: =================================================================================== Autodesk Data Management Server R2009 SP0 (Vault and Productstream) =================================================================================== Related Hotfixes: =================================================================================== TS1087082 - Content Center configuration dialog may fail to invoke TS1086568 - Content Center and Search Issues (all updates are contained within this hotfix) TS1087968 - Content Center, Search Issues and Property Indexing (all updates are contained within this hotfix) =================================================================================== Known Issues: =================================================================================== =================================================================================== Warnings: =================================================================================== =================================================================================== Files Affected: =================================================================================== - Connectivity.Platform.dll - Connectivity.Content.dll - Migrations.xml =================================================================================== Update Verification: =================================================================================== The updated Connectivity.Platform.dll file is version 13.0.47.600. The updated Connectivity.Content.dll file is version 13.0.47.340. The updated Migrations.xml file will have a date of 6/17/2008. =================================================================================== Installation Instructions: =================================================================================== 1) Begin with Autodesk Data Management Server R2009 SP0 installed. 2) Run TS1093427.msp to install the hotfix. NOTE: The dialog "The system database login is invalid" will continue to display until all corrupted libraries are successfully deleted. Please be sure to select OK to dismiss the dialog for all instances. 3) Open ADMS Console and display the list of Libraries. 4) Select each library, one at a time, to determine whether the error dialog "The system database login is invalid" is invoked. 5) For each corrupted library right click on the corrupted library and select Delete. 6) Make sure all databases are fully migrated to the latest version. Migrate all unmigrated databases before proceeding. NOTE: All corrupted libraries must be deleted and all databases migrated to proceed. 7) Close the ADMS Console application. 8) Open a command prompt and navigate to the installed location of Connectivity.ADMSConsole.Exe 9) Run ADMS Console b2bmigrate operation in command line mode: Ex: Connectivity.ADMSConsole.Exe -Ob2bmigrate -VUadministrator -VP -DBUsa -DBPAutodeskVault NOTE: Replace with the appropriate administrator password for the -VP switch. The last two command line parameters are required only if the ‘sa’ password is not the default password.) 10) A 'migration successful' dialog will display when the b2bmigrate operation has completed. 11) Reset the web service by typing 'iisreset' at the command prompt. 12) Restore deleted libraries from backup copies. 13) Install the hotfix on all ADMS servers. 14) Run property re-indexing to complete the extraction of all desired properties. =================================================================================== Thank you for your commitment to Autodesk products. Respectfully, Autodesk Data Management Team