Better Database Management / utilities

mwaite · ‎Aug 15, 2019

I was re-vaulting from one master to another. The job finished and I checked the source vault, it was empty.

I ran wContentVerify against the source and target, no problems reported.

I tried to delete the root folder of the source and Windchill told me it was still in use. I opened a ticket and the support engineer pointed me to Article - CS53958.

I deleted the orphaned fvitem records and I was able to delete the root folder. My initial thought was that there should be a WinRu to clean up orphaned records. Then I thought they are type of un-referenced file, so that should clean them up.

PTC says the records are not a problem and that is why there is an article.

I started looking at other tables like MasteredOnReplicaItem and StreamData. Same problem there.

Sometimes I find a relationship records where Object A or Object B was deleted, but the relation still points to it.

I used to admin a different PLM system and it had utilities for purifying the database. They would look for missing references and report them to the admin. The admin decides what to do about it. I think it helps to keep the database cleaned up. There types of discrepancies cause big problems with Windchill Bulk Migrator.

I suggest that PTC provide utilities ( not sql scripts ) to identify data inconsistencies and give the admin the visibility and opportunity to decide what to do about it. Maybe even make a recommendation. The other PLM system provided a report that could be easily converted to sql using search and replace.

BenLoosli · ‎Aug 15, 2019

A nice data front end on a utility like this is just a cover for the SQL scripts that do the actual work.

I do agree that this whole process of database cleanup and maintenance needs to be better documented and PTC should build a DButility program that executes the scripts needed to do this work.

I have built a small library of SQL scripts from the PTC calls I have had that have dealt with DB issues over the years. My biggest issue is that my primary Windchill system is not on the internet so I have to either burn the information from a CS article to a CD and transfer it or manually enter the SQL commands.

olivierlp · ‎Oct 03, 2023

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.