AnsweredAssumed Answered

PI Datalink Error "is not marked as serializable."

Question asked by jirvine on Feb 17, 2020
Latest reply on Feb 18, 2020 by jirvine

I have one user that has a spreadsheet built out that has been working fine up until recently. He's using Datalink to pull in PI Data from Asset Framework. In all of his cells he is getting:

 

"Type 'OSIsoft.AF.Data.AFDataProvider+AFQueryDataProvider' in assembly 'OSIsoft.AFSDK, Version=4.0.0.0, Culture=neutral, PublicKeyToken=6238be57836698e6' is not marked as serializable."

 

When I open it on my end, I get the same errors but I can open each PI entry and hit enter and it'll pull in the data. I can't get it on mine to pull all the data in at the same time, I have to do each line individually.

 

On his system, it never pulls in any PI data. 

 

He's pulling a time-weighted average over 24 hours. His time frame is within range and has data.

 

=PIAdvCalcVal("EC Carpenter C1 Mole%",'Elk Creek'!C34,"+24h","average (time-weighted)","time-weighted",0,1,0,"\\SRVPIHOME01POKE\NGL Plants\Optimization Data\NGL System Tool")

 

 

Anyone ever encountered "Is not marked as serializable"?

Outcomes