Leftover publish_params.xml files in my old vault folder

[avillanueva]

Millions of files and there is bound to be some errors. 6 in fact which blocks me removing an old vault.  They are all "public_params.xml" files that show up in the vault but will not move. I ran WTContenVerify and it reports back Business object missing. So I get that I have a valid FVItem but the object its tied to is done, a Derived Image. Some related articles on this topic:

https://www.ptc.com/en/support/article/CS121641?source=search

https://www.ptc.com/en/support/article/CS110809?source=search

https://www.ptc.com/en/support/article/CS280885?source=search

It sounds like I have to prune the FVItem, Holder2Content, ApplicationData related to these entries. Anyone been down this road before? Tips appreciated. Was hoping there was a WinRU to fix this.

[mmeadows-3 · Accepted solution]

Yep, you need to prune.  These will work in your use case, but shouldn't blindly apply them to all cases of missing business object.

-- Using internal_id from the vaulting report in delete statements...

delete from ApplicationData where idA2A2 in (select htc.idA3B5 from ApplicationData ad, HolderToContent htc where ad.idA2A2=htc.idA3B5 and htc.idA3A5 in (comma separated list of {internal_id} values));

delete from HolderToContent where idA2A2 in (select idA2A2 from HolderToContent where idA3A5 in (comma separated list of{<internal_id} values));

I get missing business objects regularly with published files.  It is really rare on other object types.

[avillanueva]

Voila! Which is french for... "aaand then i found out..."