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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. 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

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.

abhiramk
13-Aquamarine
(To:TanmeyTWX)

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.

Announcements


Top Tags