We
experienced an error related to access services.
What was the funny part?
First the SharePoint log message was a surprise, how
many times do you see the sentence "Please open a bug"?? . Second that it
was happening in 3 farms, in other 3 farms was working perfectly. The version
on all these farms was the same, SharePoint 2010 SP1.
The incident
was that when we added Access Services, created a site with Access sheet and we
tried to use it in a standard basic way it was working randomly. Once it failed we needed to delete the
whole service and re-create it again. We tried several ways, including the
Wizard and power shell, but nothing worked out.
The Error:
System.StackOverflowException: Operation caused a
stack overflow. at
Microsoft.Office.Access.Server.UI.PageChopper.GetPageContent(String pageName,
String parentId, SharedDataBaseInfo dataBaseInfo) at
Microsoft.Office.Access.Server.UI.AccessPortal.GetSubFormInternal(SharedDataBaseInfo
dataBaseInfo, GetSubFormParameter parameter) at Microsoft.Office.Access.Server.UI.AccessPortal.b__0(SharedDataBaseInfo
database, Object param) at
Microsoft.Office.Access.Server.UI.AccessPortal.ExecuteWebMethodHandler(CoreWebMethodHandler
coreWebMethodHandler, SharedDataBaseInfo dataBaseInfo, Object param, Boolean
writeOperation). Please open a bug.
After
opening a ticket in the Microsoft support team they recommended us to follow
the link bellow:
There were
not similarities between our error (behavior of the service) or the SharePoint
log, but it fixed the problem.
The solution:
- Upgrade the server/farm with the CU February 2012. We had to install both, Foundation and server, and it was a long upgrade. The foundation takes around an hour, but the server package took 4 hours on a standalone.
- Restart the server/farm. It will not ask for it but when you run the commands the error continues until you restart the SharePoint Server/farm
- Run the commands:
$farm = Get-SPFarm
$farm.XsltTransformTimeOut = 10
$farm.Update()
- Try access.
No hay comentarios:
Publicar un comentario