AnsweredAssumed Answered

ACE Calculation calcfailed

Question asked by kokolopr on Jan 30, 2017
Latest reply on Feb 1, 2017 by gregor

ACE 2010 R2. Objective is to read lab sample values from Oracle Database, validate if already written to Sample PI Tag; skip is exists else write value to the tag. In validations I am checking the following. While ACE testing it works perfectly without error but again once I schedule it on the same server, it write "Calfailed" inside the PI tag.

 

Dim SampledDatetime as Date
<SampledDateTime is populated by SQL to LIMS database>
IF LabInput.ResultTimeStamp.LocalDate.ToString("MM/dd/yyyy HH:mm:ss") = SampledDatetime.ToString("MM/dd/yyyy HH:mm:ss") then
    LabInput.SendDatatoPI = False
else
     LabInput.Value(SampledDateTime) = xxxx
end if

 

It works fine if I use "LabInput.Value(SampledDateTime) = xxxx"

Appreciate and Thanks

Outcomes