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

Best practice on Data archiving

gch
11-Garnet
11-Garnet

Best practice on Data archiving

Hello,

 

We are using the Manufacturing apps 9.1 with a MS Sql server. Since the manufacturing apps are receiving and logging a lot of data it will probably be necessary at a certain point of time to archive some of the data in order to keep the system performant.

Is there any guidance about this?

Which table have to be considered? kpielementvalue, kpivalue, value_stream?

1 ACCEPTED SOLUTION

Accepted Solutions
hchanana
16-Pearl
(To:gch)

Hi @gch 

 

Mfg apps already have feature to purge old historical data, PTC.SCA.SCO.HistoricalDataPurgeScheduler is the scheduler used for purging data. You can update the configuration to set how many days data needs to be retained.

More details are available at the below link :

 

https://support.ptc.com/help/thingworx/apps/r9.0/en/#page/thingworx_apps%2FCustomizing_Operator_Advi...

 

Thanks,

Himanshu

 

View solution in original post

4 REPLIES 4
hchanana
16-Pearl
(To:gch)

Hi @gch 

 

Mfg apps already have feature to purge old historical data, PTC.SCA.SCO.HistoricalDataPurgeScheduler is the scheduler used for purging data. You can update the configuration to set how many days data needs to be retained.

More details are available at the below link :

 

https://support.ptc.com/help/thingworx/apps/r9.0/en/#page/thingworx_apps%2FCustomizing_Operator_Advi...

 

Thanks,

Himanshu

 

View solution in original post

gch
11-Garnet
11-Garnet
(To:hchanana)

Hi,

 

which data will be purged?

The logged values, the KPIs?

gch
11-Garnet
11-Garnet
(To:gch)

Since it is specific to the operator advisor, I'm not sure that it will help...

hchanana
16-Pearl
(To:gch)

Hi @gch : This scheduler purge both operator advisor and mfg apps data (from value streams) older than the specified days

Announcements