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