On one of our pi servers the Point Source Table contains a couple of point sources that I don't use anymore (attached number of points is zero). Is there a way to remove them from the list? I don't see this option in PI SMT.
I have asked OSIsoft Techsupport about this some time ago, and this was the answer I got:
You cannot remove entries from the PointSource Table plug-in unless you reset a file directly on the PI Server:
1. Stop the PI Base Subsystem service2. Rename the original piptsrcind.dat file inside \PI\DAT\ to something like piptsrcind.dat.old 3. Start the PI Base Subsystem service 4. Check the PointSource list in System Management Tools.
If you are running a PI 3 server version 3.4.375.14 or greater, there is also another way to clean up the point source table.
Add a set tuning parameter "pointDB_RemoveEmptySource" to 1 by doing thefollowing:
Open the command prompt and launch piconfig under PI\adm folder then type in the following:
@mode edit@table pi_gen,pitimeout@istr name, valuePointDB_RemoveEmptySource, 1@ends
Once you do this, after pibasesss is stopped and restarted it will check and if there are empty point sources and if so, it will delete them. For this to work, you must edit at least one point with the point source that you want deleted. Set the point source to that point source and then change it to some other point source.
This works!! Thanks!!!
You can use this procedure too:
Retrieving data ...