AnsweredAssumed Answered

PI Datalink - no data from past to tag creation even if there is data

Question asked by PierreMarcil on Mar 20, 2015
Latest reply on Mar 25, 2015 by fzhang

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

 

TagTimestampValue
A2010-01-01'ABC'
B2010-01-10'DEF'
B2011-01-01'GHI'

 

Using Archive value =>

Data itemTimestampValue
A2013-01-01No data
A2015-03-20'ABC'
B2013-01-01'GHI'
B2015-03-20'GHI'

 

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 :

PI DataLink

Version 5.0.0

  mscorlib 4.0.0.0 4.0.30319.18063 built by: FX45RTMGDR

  Microsoft.VisualStudio.Tools.Office.Runtime 10.0.0.0 10.0.50903.0

  System.Core 4.0.0.0 4.0.30319.17929 built by: FX45RTMREL

  System 4.0.0.0 4.0.30319.34238 built by: FX452RTMGDR

  System.Configuration 4.0.0.0 4.0.30319.18060 built by: FX45RTMGDR

  System.Xml 4.0.0.0 4.0.30319.34234 built by: FX452RTMGDR

  System.Security 4.0.0.0 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 4.0.0.0 4.0.30319.34244 built by: FX452RTMGDR

  Microsoft.VisualStudio.Tools.Applications.ServerDocument 10.0.0.0 10.0.50903.0

  System.Windows.Forms 4.0.0.0 4.0.30319.18047 built by: FX45RTMGDR

  System.Drawing 4.0.0.0 4.0.30319.18021 built by: FX45RTMGDR

  System.Xml.Linq 4.0.0.0 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 4.0.3.0 5.0.0.0

  Microsoft.Office.Tools.Common.v4.0.Utilities 10.0.0.0 10.0.30319.1

  OSIsoft.PIDataLink.Resources 4.2.0.0 5.0.0.0

  Microsoft.GeneratedCode 1.0.0.0

  OSIsoft.PIDataLink.AFData 5.0.0.0 5.0.0.0

  OSIsoft.AFSDK 4.0.0.0 2.6.2.6558

  Microsoft.GeneratedCode 1.0.0.0

  OSIsoft.PI.Net 1.3.8.0 1.3.8.58

  OSIsoft.PI.Configuration 1.3.8.0 1.3.8.58

  Microsoft.GeneratedCode 1.0.0.0

  Microsoft.CSharp 4.0.0.0 4.0.30319.17929

  System.Dynamic 4.0.0.0 4.0.30319.17929

  Anonymously Hosted DynamicMethods Assembly 0.0.0.0

  CustomMarshalers 4.0.0.0 4.0.30319.17929 built by: FX45RTMREL

  System.Runtime.Serialization 4.0.0.0 4.0.30319.34234 built by: FX452RTMGDR

  OSIsoft.PI.Configuration.PISDKRegDirectoryProvider 1.3.8.0 1.3.8.58

  System.ServiceProcess 4.0.0.0 4.0.30319.17929 built by: FX45RTMREL

  OSIsoft.PI.Resources 1.3.8.0 1.3.8.58

  Accessibility 4.0.0.0 4.0.30319.17929 built by: FX45RTMREL

  PIPC64.xll 5.0.0.0

  OSIsoft.PIDataLink.Notifications.Common.dll 5.0.0.0 5.0.0.0

  OSIsoft.PIDataLink.Notifications2007.UDF.dll 5.0.0.0 5.0.0.0

  OSIsoft.PIDataLink.Notifications2007.UI.dll 5.0.0.0 5.0.0.0

Copyright (c) 2013, OSIsoft, LLC

 

 

let me know if you need any clarification.

Outcomes