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 188.8.131.52 4.0.30319.18063 built by: FX45RTMGDR
Microsoft.VisualStudio.Tools.Office.Runtime 10.0.0.0 10.0.50903.0
System.Core 184.108.40.206 4.0.30319.17929 built by: FX45RTMREL
System 220.127.116.11 4.0.30319.34238 built by: FX452RTMGDR
System.Configuration 18.104.22.168 4.0.30319.18060 built by: FX45RTMGDR
System.Xml 22.214.171.124 4.0.30319.34234 built by: FX452RTMGDR
System.Security 126.96.36.199 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 188.8.131.52 4.0.30319.34244 built by: FX452RTMGDR
Microsoft.VisualStudio.Tools.Applications.ServerDocument 10.0.0.0 10.0.50903.0
System.Windows.Forms 184.108.40.206 4.0.30319.18047 built by: FX45RTMGDR
System.Drawing 220.127.116.11 4.0.30319.18021 built by: FX45RTMGDR
System.Xml.Linq 18.104.22.168 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 22.214.171.124 126.96.36.199
Microsoft.Office.Tools.Common.v4.0.Utilities 10.0.0.0 10.0.30319.1
OSIsoft.PIDataLink.Resources 188.8.131.52 184.108.40.206
OSIsoft.PIDataLink.AFData 220.127.116.11 18.104.22.168
OSIsoft.AFSDK 22.214.171.124 126.96.36.19958
OSIsoft.PI.Net 188.8.131.52 184.108.40.206
OSIsoft.PI.Configuration 220.127.116.11 18.104.22.168
Microsoft.CSharp 22.214.171.124 4.0.30319.17929
System.Dynamic 126.96.36.199 4.0.30319.17929
Anonymously Hosted DynamicMethods Assembly 0.0.0.0
CustomMarshalers 188.8.131.52 4.0.30319.17929 built by: FX45RTMREL
System.Runtime.Serialization 184.108.40.206 4.0.30319.34234 built by: FX452RTMGDR
OSIsoft.PI.Configuration.PISDKRegDirectoryProvider 220.127.116.11 18.104.22.168
System.ServiceProcess 22.214.171.124 4.0.30319.17929 built by: FX45RTMREL
OSIsoft.PI.Resources 126.96.36.199 188.8.131.52
Accessibility 184.108.40.206 4.0.30319.17929 built by: FX45RTMREL
OSIsoft.PIDataLink.Notifications.Common.dll 220.127.116.11 18.104.22.168
OSIsoft.PIDataLink.Notifications2007.UDF.dll 22.214.171.124 126.96.36.199
OSIsoft.PIDataLink.Notifications2007.UI.dll 188.8.131.52 184.108.40.206
Copyright (c) 2013, OSIsoft, LLC
let me know if you need any clarification.