Problem

A tag that is the output of an Online or Interval Expression has a calculation error; AND

The Baze.Calculation.Service.Host.exe.Service.log file indicates that the expression compilation failed with a message like:


ERROR - FormulaError - Error compiling tag: <tagid> formula: <formula>
ExpressionEvaluator.Parser.ExpressionParseException: Cannot resolve member <SomeString> on type "FunctionScope"


Resolution



This error indicates that the function <SomeString> in the tag's formula is not a valid function in the Bazefield Calculation Service. To resolve the issue, verify that the function is spelled correctly. NOTE: Functions are case-sensitive -- so Sqrt() is a valid function, but SQRT() and sqrt() are not valid functions. 


To verify proper spelling and case-sensitivity, see the list of valid functions below. For detailed explanations of each function and how to apply it, see the Baze Calculation Function Reference instead.


AbsLogSqrtTagIntStartV_DBL
AngAvglowerSquareOfSumsTagIntStartNV_Int
AvgLowerSquareOfSumsParamsTagLastV_Obj
AvgNMaxStartsWithTagLastNV_OBJ
AvgVarsMaxNStrTagMaxV_SelectLatest
BatActivityTimeMaxTimeStrArrayTagMaxNV_SelectLatestTime
ContainsMaxTimeNSubstringTagMinV_Str
ContainsAllMaxTimeVarsSubtractTagMinNV_STR
ContainsAllWildcardMinSumTagPrevV_Time
ContainsAnyMinNSumNTagPrevTimeValue
ContainsAnyWildcardMinTimeSumOfSquaresTagRawValueAsBool
CosMinTimeNSumOfSquaresParamsTagStartValueAsDouble
DayMinuteSumVarsTagStartNValueAsString
DaysInMonthMinVarssunRiseTimeTagStdDevValueBuffer
DblModSunRiseTimeTagStdDevNYear
DegToRadMonthsunSetTimeTagSum
EndsWithNowSunSetTimeTagSumN
ExpandOverrideQualityTagAggregateTagTimeAvg
ExpandNOverrideQualityNTagAggregateNTagTimeAvgN
FindIndexOverrideTimeStampTagAvgTagTotal
HasSunRisenOverrideTimeStampNTagAvgNTagTotalN
HasSunSetPowTagCountTan
HourQ_ByteTagCountNTimeGreater
HoursInMonthQ_IntTagCurrentTimeIsLocal
IfQualityAsByteTagCurrent_ClipIntervalTimeIsUtc
IFQualityAsIntTagCurrentNTimeNow
If_Then_ObjRadToDegTagCurrentN_ClipIntervalTimeNowUtc
If_Then_StrRandomTagCurrentStrTimeStamp
IntregexMatchTagCurrentTimeTimeToLocal
IntervalTimeRoundTagCurrentTimeNTimeToUtc
IntervalTimeWithConditionSecondTagDeltaToLower
IsMinValueSetIgnoreResultTagDeltaNTotalIntervalTime
IsNaNSetQualityTagEndToUpper
IsNotNullSetQualityIfTagEndNTrim
IsNullSetQualityNTagFirstupper
IsRangeMatchSetTimeStampTagFirstNUpper
IsSunRisingSetTimeStampNTagIntV
IsSunSettingSetValueIfValidTagIntEndV_Bool
IsTimeBetweenSunRiseAndSunSetSignTagIntEndNV_ClipInterval
IsTimeBetweenSunSetAndSunRiseSinTagIntNV_Dbl


Product Environment and Version

Last updated for Bazefield Calculation Service 1.0.1.9