lunes, 21 de enero de 2013

SP2010::Access Services : Please open a bug and the CU February 2012


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