We recommend that you have JavaScript enabled to enjoy the awesomeness of this site!

  • The page you are on right now   ⟶
  • EM Articles   ⟶
  • Updating Replica Server Mount Paths

Updating Replica Server Mount Paths

This past weekend I was apart of a massive upgrade of Windchill 9.1 to Windchill 10. One the things I ran into, and I thought I would share, was that the Vault Configuration UI under the File Server Administration module within Windchill 10 doesn't allow you to update the mount paths. For this specific upgrade we needed to move the remote vault root folders and replica folders to a more central location on all of the remote cache servers. Prior to the upgrade the root and replica folders was located under the Windchill 9.1 Windchill folder (D:PTCWindchill_9.1WindchillVaults). For this upgrade we moved these folders to the root of the D drive (D:Windchill_Vaults).

After the upgrade of the master server  was complete all of the root and replica folder mounts were invalid. For whatever reason the Vault Configuration UI doesn't allow you to update these mounts. So I wrote followings SQL scripts to update the Root Folder mount path, and the Replica Folder mount path. The steps below will take you through the process of updating the mount paths via 3 fairly simple SQL scripts.

  1. First we need to query the FvHost table to locate the IDA2A2 number for the specific host that we are going to be working. The IDA2A2 is the unique identifier for host we are going to be working with.

    Pull specific host information
    select hostName, idA2A2 from SCHEMENAME.FvHost
    where hostName = 'host.name.inquestion'


    Pull specific Host information
    select hostName, idA2A2 from SCHEMENAME.FvHost

     
  2. Now with the IDA2A2 located run the following script to get the mount path of the ROOT folder for this specific site. The IDA3A5 is the foreign key in the RootMount table that associates it to the FvHost table

    select path, IDA3A5 from wtuser.RootMount
    where idA3A5 = '3493567'
    You can remove the path and IDA3A5 with an * and it will return every column from that table

     
  3. The script above shows us the original mount path. The update script below will update the path to the new location. Just like in the script above the IDA3A5 column associates this update only to the record specific to the site we are working with.

    update wtuser.RootMount
    set
    path = 'D:Windchill_VaultsVault_01'
    where idA3A5 = '3493567'
     
  4. Now, refresh your Vault Configuration screen by pressing the resfresh button.

     
  5. Expand the site in question, and you will now see the Path in the UI has been updated.


    Here is a screen shot of the UI before the update:

     
  6. With the root folder mount now updated you need to update the mount path for the Replica Folders. The following script will show you what the paths are for specific site / host you are working with.

    select path, idA3B5, idA2A2 from wtuser.FvMount
    where idA3B5 = '3493567'

     
  7. With the IDA2A2 identified for each mount path run the following scripts with the updated file path to the folder

    update wtuser.FvMount
    set
    path = 'D:Windchill_VaultsVault_01ao01_vault_RootFolder_1_Folder_1'
    where idA2A2 = 4511028

    update wtuser.FvMount
    set
    path = 'D:Windchill_VaultsVault_01ao01_vault_RootFolder_1_Folder_2'
    where idA2A2 = 4511622
     
  8. Run the select statement again, and your results will show the newly updated path

     
  9. Now go back to the Vault Configuration UI, and refresh the screen just like in step 4. Expand the Replica folders for the site in question, and you will now see that the path for the mounts have been updated.

     
  10. With the root and replica folder mount paths updated you can how broadcast the configuration, and validate the mounts.

If you have any question on this feel free to email me at patrick@exposuremind.com.