Excel Calculation Services User Defined Function Exception

Microsoft.SharePoint.2013.SPServiceInstance.Excel.ECSUdfException (UnitMonitor)

A warning state of this Monitor indicates that a User Defined Function has thrown an exception. User Defined Functions are custom code that is deployed to the server which can be used by Excel Services Application. Any workbooks that require this User Defined Function may not be calculating properly. The User Defined Function may need to be fixed and redeployed to the server.

Knowledge Base article:

Summary

To get the most current Knowledge Article from the Microsoft TechNet site, visit:

http://go.microsoft.com/fwlink/?LinkId=244889

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

TargetMicrosoft.SharePoint.2013.SPServiceInstance.Excel
Parent MonitorSystem.Health.ConfigurationState
CategoryConfigurationHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SharePoint.RepeatedEventLogManualReset2StateMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SharePoint.2013.SPServiceInstance.Excel.ECSUdfException" Accessibility="Public" Enabled="onEssentialMonitoring" Target="MOSS15Core!Microsoft.SharePoint.2013.SPServiceInstance.Excel" ParentMonitorID="Health!System.Health.ConfigurationState" Priority="Normal" TypeID="WSS!Microsoft.SharePoint.RepeatedEventLogManualReset2StateMonitorType">
<Category>ConfigurationHealth</Category>
<OperationalStates>
<OperationalState ID="ManualResetEventRaised" MonitorTypeStateID="ManualResetEventRaised" HealthState="Success"/>
<OperationalState ID="RepeatedEventRaised" MonitorTypeStateID="RepeatedEventRaised" HealthState="Warning"/>
</OperationalStates>
<Configuration>
<RepeatedComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</RepeatedComputerName>
<RepeatedLogName>Application</RepeatedLogName>
<RepeatedExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">6467</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="String">Microsoft-SharePoint Products-Excel Services Application</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</RepeatedExpression>
<Interval>600</Interval>
<Count>5</Count>
</Configuration>
</UnitMonitor>