InfluxDB reset value

Find and share HowTos to various installations / configurations!
Search

Post Reply
11 posts • Page 1 of 2
andrea.spinelli
Posts: 9
Joined: Thu Sep 27, 2018 3:29 pm

InfluxDB reset value

Post by andrea.spinelli »

Hello,

I am using WinCC OA 3.17 with the latest update.
I do not find any commands or a simple button on the gedi, for delete the archive e alarms value with NGA archive.
Is there a command for reset them?
Or if there is the possibility to delete the archive/alarm values by deleting manually some folders in the project.

User avatar
adaneau
Posts: 310
Joined: Tue Feb 21, 2012 9:49 am

Re: InfluxDB reset value

Post by adaneau »

Hi,

You can just stop the project. delete the folder influx in db/wincc_oaand replace it with the one in C:\Siemens\Automation\WinCC_OA\3.17\db\wincc_oa

This will provide you with a clean influxdb, without any data and with default etm login credentials.

BR
Alex

andrea.spinelli
Posts: 9
Joined: Thu Sep 27, 2018 3:29 pm

Re: InfluxDB reset value

Post by andrea.spinelli »

Thank you for the reply but it is not what that's not what I mean.

Normally I create the customer's project on my workstation. During the test, maybe I have to simulate some archived values and alarms.
Then, when I complete it, I have to prepare the customer's PC.
I want to put on the customer's PC the project cleaned of all archived data but maintaining all settings.

User avatar
leoknipp
Posts: 2926
Joined: Tue Aug 24, 2010 7:28 pm

Re: InfluxDB reset value

Post by leoknipp »

If you want to get rid of data created during engineering and/or testing you can use the following approach:
-- Make an ASCII export of the current configuration
-- Create a new database using the tool WCCOAtoolCreateDb
-- Start the project
-- Make the ASCII import

Best Regards
Leopold Knipp
Senior Support Specialist

andrea.spinelli
Posts: 9
Joined: Thu Sep 27, 2018 3:29 pm

Re: InfluxDB reset value

Post by andrea.spinelli »

But is it possible to manually delete the folder where the values are stored?
As for non-NGA archives, where you could delete VAxxxxx folder.

User avatar
adaneau
Posts: 310
Joined: Tue Feb 21, 2012 9:49 am

Re: InfluxDB reset value

Post by adaneau »

Hi Andrea,

This is exactly what I explained to you. Deleted influx folder only delete historical data. I am not talking about deleting the whole db folder.

BR
Alex

User avatar
leoknipp
Posts: 2926
Joined: Tue Aug 24, 2010 7:28 pm

Re: InfluxDB reset value

Post by leoknipp »

If you delete only the VA folders in a project using standard archiving the database will still contain the historical alerts.
Therefore it is easier to generate a new database.

If the influx folder is deleted and the project is restarted the internal datapoints still have information saved for the archive groups which was valid before deleting the folder.
I am not sure if the project will then work without some negative effects.

Best Regards
Leopold Knipp
Senior Support Specialist

User avatar
adaneau
Posts: 310
Joined: Tue Feb 21, 2012 9:49 am

Re: InfluxDB reset value

Post by adaneau »

As far as I have tested, it will recreate the groups as configured when you use a clean influxdb.

User avatar
leoknipp
Posts: 2926
Joined: Tue Aug 24, 2010 7:28 pm

Re: InfluxDB reset value

Post by leoknipp »

Yes, the groups are created. The question is if the segment list saved in WinCC OA fits the database?
In my tests the segment list still had information for data aready deleted.

Best Regards
Leopold Knipp
Senior Support Specialist

EER
Posts: 17
Joined: Fri Jun 12, 2015 1:31 pm

Re: InfluxDB reset value

Post by EER »

Anyone found a easy "delete all history" option?

I agree manually deleting files would be a nice option. But the residue information Leopold mentions is an issue.. Tmost reliable path I found is just manually deleting the segments using the "runtime engineering".

Post Reply
11 posts • Page 1 of 2