SharePoint 2010: An error has occurred with Access Services

I received the following error while working with Access Databases in SharePoint 2010.

“An error has occurred” with no further information.

Capture

It worked after I refreshed the browser 3-5 times and failed again the 6th time.

The following messages appeared in the ULS Viewer which I have seen before.

Error while executing web part: System.StackOverflowException: Operation caused a stack overflow.
at Microsoft.Xslt.NativeMethod.CheckForSufficientStack()
at <xsl:apply-templates mode=”Control”>(XmlQueryRuntime , XPathNavigator , IList`1 )
at <xsl:template match=”d:Border” mode=”Cell”>(XmlQueryRuntime , XPathNavigator , IList`1 )
at <xsl:template match=”d:ColumnDefinition” mode=”Column”>(XmlQueryRuntime , XPathNavigator , Double , IList`1 , IList`1 )
at <xsl:apply-templates mode=”Column”>(XmlQueryRuntime , XPathNavigator , Double , IList`1 , Double )
at <xsl:template match=”d:RowDefinition” mode=”Row”>(XmlQueryRuntime , XPathNavigator , Double , IList`1 )
at <xsl:template match=”d:Grid” mode=”Grid”>(XmlQueryRuntime , XPathNavigator , IList`1 , IList`1 )
at <xsl:template match=”a:Section” mode=”Section”>(XmlQueryRuntime , XPathNavigator , IList`1 , IList`1 )
at <xsl:template match=”d:DataTemplate” mode=”Records”>(XmlQueryRuntime , XPathNavigator , IList`1 , IList`1 , IList`1 )
at <xsl:template match=”a:Form” mode=”Form”>(XmlQueryRuntime , XPathNavigator )
at <xsl:template match=”/”>(XmlQueryRuntime )
at Root(XmlQueryRuntime )
at System.Xml.Xsl.XmlILCommand.Execute(Object defaultDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter writer, Boolean closeWriter)
at System.Xml.Xsl.XmlILCommand.Execute(IXPathNavigable contextDocument, XmlResolver dataSources, XsltArgumentList argumentList, XmlWriter results)
at System.Xml.Xsl.XslCompiledTransform.Transform(IXPathNavigable input, XsltArgumentList arguments, XmlWriter results)
at Microsoft.SharePoint.WebPartPages.DataFormWebPart.ExecuteTransform(XslCompiledTransform xslCompiledTransform, XsltArgumentList xmlArguments, Boolean bDeferExecuteTransform)
at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)

Resolution

The above message is related to the XSLTTransformTimeOut.

Before SP1 the timeout was set to 5 seconds and Microsoft changed this to 1 with SP1. You can change this setting after CU February 2012 with the following command:

$farm = get-spfarm
$farm.xslttransformtimeout = 5
$farm.update()

The Access database should work again.

Leave a Reply

Your email address will not be published. Required fields are marked *