There are certain calls that cannot be buffered and "Delete from ..." is equivalent to the PI SDK call "RemoveValues" which is not buffered, so PI OLEDB will not execute the call.
You need an alternative method to remove the data from each member of your PI Collective...AF SDD, PI Config, ...
Read this, in particular the limitations section: KB00572 - PI SDK Buffering: Benefits, installation, configuration and other FAQs
Thank you for your response. Do you have any recommended code snippet which will help me delete the data from each member of collective separately.
Thanks in advance again.
2 of 2 people found this helpful
Here is a code snippet using AF SDK using buffering:
PIServer myPI = new PIServers()["YourPIServer"]; PIPoint tag = PIPoint.FindPIPoint(myPI, "YourTag"); string filter = @"'YourTag' = ""Configure"" or 'YourTag' = ""bad"""; AFValues values = tag.RecordedValues(new AFTimeRange("*-2h", "*"), AFBoundaryType.Inside, filter, false); tag.UpdateValues(values, AFUpdateOption.Remove, AFBufferOption.Buffer);
Make sure that buffering (PI Buffer Subsystem) is enabled. For more information about buffering with AF SDK, refer to this previous discussion.
Alternatively, you can use piconfig for each member of the collective separately. More information can be found in: