Skip to main content
B
BK_102906936-Contributor
6-Contributor
September 9, 2024
Solved

Data archival of ThingWorx Stream data based on a Scheduler

  • September 9, 2024
  • 3 replies
  • 810 views

I have 1000's of Streams and want to archive the old data in database using a scheduler in PostgresSQL. Can anyone please help me with a detailed steps, how to proceed to it?

 

Best answer by nmutter

I can only provide you this link:

There is unfortunately no straight forward mechanism. When impelemnting a purge solution make sure to purge in batches so that the thingworx ScriptTimeout does not kick in and kill your service.

You could also implement something in the database directly if you want to take the risk (might break in the next twx version when e.g. the schema changes).

3 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
September 9, 2024

Similar discussion - "Best practice to store data in Stream": https://community.ptc.com/t5/ThingWorx-Developers/Best-practice-to-store-data-in-Stream/td-p/839910 

N
nmutter16-PearlAnswer
16-Pearl
September 9, 2024

I can only provide you this link:

There is unfortunately no straight forward mechanism. When impelemnting a purge solution make sure to purge in batches so that the thingworx ScriptTimeout does not kick in and kill your service.

You could also implement something in the database directly if you want to take the risk (might break in the next twx version when e.g. the schema changes).

V
vnamboodheriCommunity Manager
Community Moderator
September 13, 2024

Hello @BK_10290693, 

 

It looks like you have some responses from some community members. If any of these replies answered your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.

Terms & ConditionsCookie settingsAccessibility statement