September 25, 2009

Whenever we are troubleshooting any performance problem on a Vault Server, one of the first things we can suggest is TS1073046.

This TS# suggests running a script on the SQL database to Update Statistics on specific named Vault databases. So make sure that, if you run it, you enter the correct name of the Vault databases. It would not be of any benefit to run it against any Library database as these are optimised on installation and should be read-only. We have had some reports of this script not having any effect on performance only to find that the script had simply been cut and pasted from the web page without change the <VAULTNAME> value.

If this script does have a dramatic effect on the Servers performance, it is normally indicative of a poorly maintained system. It is not intended for this to replace the recommended Microsoft SQL Maintenance plan as descibed in the "Advanced Configuration Guide".

September 02, 2009

Vault Workgroup, Collaboration and Manufacturing users notice now that when they check out an assembly from Inventor Vault tab (right click on the assembly > Check Out) the check out dialog box doesn't appear anymore and only the assembly without any children will be checked out.

This dialog box is still present in Vault 2010 Standard Version.

In Vault Workgroup, Collaboration or Manufacturing this dialog is combined with "Get Revision" dialog."Get Revision" on the assembly helps to Check Out the Assembly including all the children.

When executing Check Out command in RMB menu you do not see the dialog because, it is purposely disabled based on customers requirement. It is called "Quick-Check Out".

Also, if you would like to checkout more than one file, you may also Multi-select files in Vault browser and invoke Check Out.

In Vault Workgroup, Collaboration or Manufacturing you created a new user property called, for example, "My description" and you mapped it to the "Description" Inventor iProperty (or any other property).You added the user property "My description" column in your Vault interface but values are empty.

First of all you have to be sure you associated your new property to the right Category (<Base> Category for non controlled files).

You assigned your Category correctly, but you still notice that no value will be displayed for previously vaulted files, meanwhile the value is correctly filled for new vaulted files.

You also notice that previously vaulted files don't have the new user property "My description" in the Properties tab.

This is because the already vaulted files don't know about the new user property "My description". Already vaulted files need to be checked out and checked in in order to obtain the new user property definition and value.