Hello PI Square!
Let me introduce you before we get to the question.
I had some tag (~2k) with weird value. Look like my RDBMS interface had some kind of error in the SQL query. It was easier for me to wipe theses tags et feed them again from scratch, since my SQL query can retreive everything in a short period of time.
So I did use PI Builder in Excel 2013, made a search to get all my tag in error, deleted them then recreated them immediatly with exactly same configuration. Basicly, this has wipe the data and change de PI point ID.
Starting from there, I did run my RDBMS interface to feed back these 2k tags with data from ~2006 to now, which was less than 50k result.
I had no problem at all in sight, isn't first time i do it like this.
Bad thing did start to happen after that, when my client did try to update his Excel Sheet. There was some tag with only 1 value behind the creation date, and there some other tag with more than 1 value.
Every tag having only 1 value behind the creation date act very weirdly, using PI Archive value, compress data, sampled data, etc. give me "No data" for every date behind the creation date of theses "new" tags. They do interpolate well after the creation date.
Here how it could look :
Creation datetime ~2015-03-19
Using Archive value =>
I realy need to get this fix, and I m kind of out of idea to find a solution to this. Only idea I got is to add some "false" value for theses tag, but I dont want to use this way.
I m using theses version :
mscorlib 220.127.116.11 4.0.30319.18063 built by: FX45RTMGDR
Microsoft.VisualStudio.Tools.Office.Runtime 10.0.0.0 10.0.50903.0
System.Core 18.104.22.168 4.0.30319.17929 built by: FX45RTMREL
System 22.214.171.124 4.0.30319.34238 built by: FX452RTMGDR
System.Configuration 126.96.36.199 4.0.30319.18060 built by: FX45RTMGDR
System.Xml 188.8.131.52 4.0.30319.34234 built by: FX452RTMGDR
System.Security 184.108.40.206 4.0.30319.18055 built by: FX45RTMGDR
Microsoft.VisualStudio.Tools.Applications.Hosting 10.0.0.0 10.0.50903.0
Microsoft.VisualStudio.Tools.Applications.Runtime 10.0.0.0 10.0.50903.0
System.Deployment 220.127.116.11 4.0.30319.34244 built by: FX452RTMGDR
Microsoft.VisualStudio.Tools.Applications.ServerDocument 10.0.0.0 10.0.50903.0
System.Windows.Forms 18.104.22.168 4.0.30319.18047 built by: FX45RTMGDR
System.Drawing 22.214.171.124 4.0.30319.18021 built by: FX45RTMGDR
System.Xml.Linq 126.96.36.199 4.0.30319.17929 built by: FX45RTMREL
Microsoft.Office.Tools 10.0.0.0 10.0.50903.0
Microsoft.Office.Tools.Excel.Implementation 10.0.0.0 10.0.50903.0
Microsoft.Office.Tools.Common.Implementation 10.0.0.0 10.0.50903.0
Microsoft.Office.Tools.Common 10.0.0.0 10.0.50903.0
Microsoft.Office.Tools.Excel 10.0.0.0 10.0.50903.0
OSIsoft.PIDataLink.UI 188.8.131.52 184.108.40.206
Microsoft.Office.Tools.Common.v4.0.Utilities 10.0.0.0 10.0.30319.1
OSIsoft.PIDataLink.Resources 220.127.116.11 18.104.22.168
OSIsoft.PIDataLink.AFData 22.214.171.124 126.96.36.199
OSIsoft.AFSDK 188.8.131.52 184.108.40.20658
OSIsoft.PI.Net 220.127.116.11 18.104.22.168
OSIsoft.PI.Configuration 22.214.171.124 126.96.36.199
Microsoft.CSharp 188.8.131.52 4.0.30319.17929
System.Dynamic 184.108.40.206 4.0.30319.17929
Anonymously Hosted DynamicMethods Assembly 0.0.0.0
CustomMarshalers 220.127.116.11 4.0.30319.17929 built by: FX45RTMREL
System.Runtime.Serialization 18.104.22.168 4.0.30319.34234 built by: FX452RTMGDR
OSIsoft.PI.Configuration.PISDKRegDirectoryProvider 22.214.171.124 126.96.36.199
System.ServiceProcess 188.8.131.52 4.0.30319.17929 built by: FX45RTMREL
OSIsoft.PI.Resources 184.108.40.206 220.127.116.11
Accessibility 18.104.22.168 4.0.30319.17929 built by: FX45RTMREL
OSIsoft.PIDataLink.Notifications.Common.dll 22.214.171.124 126.96.36.199
OSIsoft.PIDataLink.Notifications2007.UDF.dll 188.8.131.52 184.108.40.206
OSIsoft.PIDataLink.Notifications2007.UI.dll 220.127.116.11 18.104.22.168
Copyright (c) 2013, OSIsoft, LLC
let me know if you need any clarification.