Autodesk®
Vault Manufacturing 2010 - Item File Link Fix Utility

In a continuing effort to provide high quality products, Autodesk has released this utility for updating existing item to file links.

This README file highlights how to utilize the utility and other important information regarding this tool.

CONTENTS

Description of the Issue
System Requirements
Related Hotfixes and Utilities
Known Issues
Warnings
Files Affected
Update Verification
Installation Instructions

Description of the Issue

Multiple item to file links may result in items that have out of date file links. Depending on the item state, this could result in some
blocked workflows such as assign item, update item and change state. This utility migrates non primary link types to standard
component links for all internal sub components to allow these operations. Only items that are related to files as a primary link
are affected on subsequent update operations.

System Requirements

- Autodesk Data Management Server 2010 Update 1 (Manufacturing)

Related Hotfixes and Utilities

TS1110227 hotfix

Known Issues

If file iterations do not contain BOM data the file BOM data needs to be corrected before the item links can be updated.

Warnings

It is strongly recommended to perform a back up prior to the application of this update.

The actions of this utility cannot be reversed. To revert to a pre hotfix state, a restore of a previous back up must be performed.

Files Affected

No files are changed when using this utility. This utility modifies values in the Autodesk Data Management Server database.

Update Verification

The utility is version 14.1.63.40.

After successfully running the utility, test all item related workflows to ensure proper behavior.

Installation Instructions

NOTE: Always ensure that a successful backup has been performed before using any utilities.

1. Begin with Autodesk Data Management Server 2010 Update 1 installed with the database restored.
2. Hotfix TS1110227 must be installed before proceeding.
3. Extract the utility to a temporary directory on the ADMS server.
4. Ensure no users are accessing the KnowledgeVaultMaster or Vaults.
5. Open a command prompt and navigate to the temporary directory.
6. Stop the web service by typing IISRESET /stop at the command prompt.
7. Run ItemFileLinkMigration.exe in command line mode to generate an initial report:

- ItemFileLinkMigration -S=servername\instance -D=VaultName -A=Action [REPORT/FIX] -U=sql_user -P=sql_password
- Example: ItemFileLinkMigration -S=MyServername\AutodeskVault -D=Vault -A=REPORT
- NOTE: The last two command line parameters are required only if the 'vaultsys' password is not the default password.

8. Examine the content of 'ItemFileLinkMigration_Report.txt'.
9. Run ItemFileLinkMigration.exe in command line mode to perform an initial link update:
   - Example: ItemFileLinkMigration -S=myservername\AutodeskVault -D=Vault -A=FIX
   - Any SQL error will be captured in a file named 'Output_EDMS_NNNNNNNNNNNNNNNNNN.txt'.
10. Run ItemFileLinkMigration.exe in report mode and examine ItemFileLinkMigration_Report.txt.
11. If any files remain in the report you must manually initiate an update to parse the file's BOM data.

1. Start the web service by typing IISRESET /start at the command prompt.
2. Search for each file name in the vault.
3. Go to the item associated with the file as the primary link.
4. Invoke an update operation but do not proceed. NOTE: this may require changing the item state to WIP.
5. At the first dialog in the update operation cancel the update.
6. Repeat for each file listed in the report.
7. Return to step 8 to re-run the utility in fix mode to repeat the process.

12. Any remaining unresolved files should be examined to ensure that the file's BOM data is accurate.

Copyright © 2010 Autodesk, Inc.
Autodesk does not guarantee that you will be able to successfully implement any hotfix, service pack, utility or workaround,
or any of the tips, tricks, examples or suggestions outlined in any Autodesk product support technical documents. Technical
documents, hotfixes, service packs, utilities or workarounds are subject to change without notice to you. Autodesk provides
technical documents, hotfixes, service packs, utilities or workarounds "as is" without warranty of any kind, whether express or
implied, including warranties of merchantability and fitness for a particular purpose. In no event shall Autodesk or its suppliers
be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of data, or loss of business
profits or special damages, that may occur as a result of implementing any hotfix, service pack, utility or workaround, or any
suggestion outlined in any Autodesk product support technical document, even if Autodesk or its suppliers have been advised of
the possibility of such damages.