cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Fastest way to purge data of things

TanmeyTWX
17-Peridot

Fastest way to purge data of things

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?

4 REPLIES 4
odukiya
15-Moonstone
(To:TanmeyTWX)

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

TanmeyTWX
17-Peridot
(To:odukiya)

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

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.

Top Tags