17-Peridot

Question

Fastest way to purge data of things

Forum|Forum|5 years ago
November 12, 2020
3 replies
1706 views

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?

16-Pearl

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

Author

17-Peridot

Already tried this but since I have huge data, it is getting timed out for the service execution.

5-Regular Member

5-Regular Member

Hello @TanmeyTWX,

Have you seen the following posts on community:

https://community.ptc.com/t5/ThingWorx-Developers/Purge-stream-entry-and-purge-all-property-values-services-are/td-p/616952

https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-cleanup-value-stream-in-loop/m-p/515277

Hope it helps,

1-Visitor

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.