Replacing files on previous versions of Windchill Document

Forum|Forum|4 years ago
July 7, 2022
6 replies
1632 views

Newbie***

I am Looking for any SQL to remove Primary Content or Secondary Content of a Windchill document without increasing the iteration of the object.

***Additionally would like to replace, the removed files with an additional corrected file.

I know this fully goes against the purpose of Windchill principles and auditing, but need to correct an object.

Bus_System Administration

T

TomU

23-Emerald IV

It won't just be SQL, it will also require getting the new files into the file vault (or the database). It's very straight forward to do with a custom utility, but you will need to build this or have someone build it for you (like @d_graham).

R

RW_10288324

Author

1-Visitor

I was considering manipulation Windchill Tool - ContentVerify to confirm the files in the vault and than manipulate to replace the files.

R

rhart

16-Pearl

Hi @RW_10288324

How about rolling back one iteration first (delete the latest iteration) then check-in your new file. That way the iteration won’t be increased.
Or is it more a case that you don’t want anyone to know what you’ve done!?!?!?

B

BenLoosli

23-Emerald III

BUT what IF the object only has 1 iteration in Windchill.

Why would you need to hide a mistake?

Make the correction as the wcadmin, accept that the iteration has increased and move on.

Better to correct the mistake with a note than hide it and have someone find it later through log files.

D

d_graham

18-Opal

@RW_10288324 , hi

@TomU is correct. Deleting any Primary or Secondary content via SQL is no problem but adding content should be done using the APIs and can be done using the APIs without iterating the Document.

David

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.