
oneOffVersionIdA2oneOffVersi is NULL then ( '.' )Įlse doc. When we migrated the system assigned those values.įind a family table that was migrated and one that was created new in PDM Link then run this query on them. The ft_version did not exist in Intralink 3.X. Most of our problem family tables came from migrated data. To get around this PTC had to provide a delete utility that lets us remove these items that fail on purge. Not sure why the ft_version does not follow the pro_version. Since ft_version has a different revision (- and A) the system won't purge because they are the latest on that revision. You would think that this data would purge leaving the -.5 locating_ring.prt and it's instances, but it won't.
Ies ve useless pro#
Notice the pro_version column, all the pro e files are at a - revision. Here is an example of family table data that will not purge. Now the technical "tip" - the main tools to get rid of obsolete/useless data are "Purge" and "Delete non-latest iterations" and they do help in many cases. But again, it's not about Windchill, it's about PDM in general. But in non-trivial cases like this, revisions, family tables, LCs/workflows etc comes into account, it's getting much more complex. You can only delete the document if you delete it together with the part of if you delete part's non-latest iterations first. if you have a part which references a document and you then remove the reference, you still won't be able to delete the document since part's previous iteration(s) has reference to the document. If you "brake" the relations, in most cases your object gets iterated and, thus, while the latest iteration has no links/relations, previous iteration(s) still have.Į.g. You can't delete an object while it has relateions to other objects in the system.

This "issue" (I quoted this because I don't think it's ctually an issue) is relevant to all PDM systems.Īs you correctly noted, this is mainly because of relations between objects stored in Windchill. Deleting old versions, iterations of objects or totally deleting objects can be tricky (and it is most times) and not always possible.
