Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
Hi,
What is the fastest and reliable way to purge data of Things with logged Properties?
doing Value Stream purging from Composer either gets timeout or long ending execution. E.g. PurgeAllPropertyHistory
Is there any way to Purge logged property data of all the Things in one go?
Any postgres query can be triggered from Thingworx to purge all the data?
Hello @TanmeyTWX
Please follow the following article :
https://www.ptc.com/en/support/article/CS271772
Let me know if it doesn't resolve your query.
Thanks
Om Dukiya
Already tried this but since I have huge data, it is getting timed out for the service execution.
Hello @TanmeyTWX,
Have you seen the following posts on community:
https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-cleanup-value-stream-in-loop/m-p/515277
Hope it helps,
If you're looking for fastest way, login to db and delete entries by query. From thingworx query transaction and delete and commit will take little time.