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.

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

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.

TS1110227 hotfix

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

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.

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

The utility is version 14.1.63.40.

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

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.