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.

How to use ULSViewer for SharePoint 2010

ULSviewer.exe is the perfect tool to monitor ULS logs. By applying filters on the ULS logs you can view the error that has occurred.

ULSViewer.exe can be downloaded at http://archive.msdn.microsoft.com/ULSViewer

In this blog I show a way to identifiy correlation ID’s

Open ULSViewer

image

Click on ‘File -> Open From –> ULS

image

Select the location where you store ULS Logs

image

Press on the filter button

image

Enter the following information: ‘Correlation equals <Correlation ID>

image

You will then find the related information. You have to recreate the error so that it will be logged when you are filtering the realtime data.

image

This way you can identify the error and perhaps find the solution

If you post a question on technet it is recommended to add the results from the ULS logs so people can answer the question faster and better.