Oct 26

ULS log Event ID 5240 “There was an error in communicating with Excel Calculation Services”

I started seeing this error in my ULS logs, and the Event Viewer on the server was packed full of red x’s. Fount this TechNet article that talked about this specific error – http://technet.microsoft.com/en-us/library/ee513104.aspx. My error text mentioned a service account that hasn’t has any problems otherwise, but for whatever reason it cant communicate with the Excel Services app. The “solution” to fix it proposed by Microsoft was to restart the server. Now, during my IT support days we would use this to fix 99% of those “my computer is broken” type tickets. I just didn’t think dropping the entire app server during the day would make my users very happy, so I kept looking.

I ran across this article from Eric Harlan about how to look through IIS to find out which Web Application is controlling your Service Applications. Using his process, I figured out which app pool contained my Excel Services service app. In our environment it contains all of our Office service applications (Excel, Word, PP, Visio, Access). I recycled this specific Application Pool and my Event View is no longer a sea of red. It’s been a few days now since I recycled it and I haven’t seen the error come back, so I’ll chalk this one up as complete 🙂

Jan 26

“Security validation for this page is invalid”

Our SharePoint 2010 Enterprise environment was recently upgraded to SP1 and the June 2011 CU. Came in this morning to a error form an Infopath form. After checking it out, I got the same error myself when switching views on a browser form:

“The security Validation for this page is invalid. Click back in your Web Browser, refresh the page and try your operation again.”

Ran the error through el Goog and ran across this TechNet post pointing the finger at a new OnLoad event in the June CU. The August 2011 CU supposedly fixes (removes) it. But we’re not there yet, so here’s another way to bypass the problem:

  1. In the 14 hive, under template/layouts, find the formserver.aspx file.
  2. Backup the file and then edit it with any text tool, say, notepad.
  3.  Under the <body> tag, add the blue line of code.

<body runat=”server” id=”PageBody”>
<SharePoint:FormDigest runat=”server” />

 Save it and give the form another go, you should be good as new.


Dec 01

Show content of a specific folder in a LVWP

Quick post about a request that came in this morning. A user is showing the contents of a doc library on a page, but only wants the contents of a specific folder to appear. By default the list shows all contents of the doc library. Modifying the view through the browser will not allow you to speficy a folder. What we need to do is create a filtered view through SP Designer. Here’show that’s done:


  • From the library, click the view drop-down menu and choose Create View


  • Select the option to crate a custom view in SPD

  • SharePoint Designer will open, then ask you to give your new view a name. Once that’s done, click on the link to edit the view

  • Once the page editor opens, select your LVWP on the page, then go to the Folder scope drop-down list on the ribbon to select “Show All Files of All Folders”

  • You’ll notice the contents of the web part change to show all folders in the doc library. Now we need to filter the items. Select the filter option from the left side of the ribbon and the following window will appear. Choose “Path” from the first drop down, and enter the Value in this format:  /SiteCollection/Site/SubSite/Library/Folder

  • If all goes well you should see the contents of your folder appear in the LVWP. When I first looked into doing this, the blog posts/threads didnt mention the syntax for doing this on a subite, so it took some trial and error before I got the filter value correct.

If you don’t want to read all of the above, this YouTube video is a great walkthrough of the same process 🙂

Jul 07

Flash and SharePoint

Found a great article here about how to add Flash to your SharePoint site. Here are the basic steps:

  • Make sure Browser File Handling is set to “Permissive” on the webapp’s Central Admin – General Settings page
  • Upload your flash and associated files to a library somewhere on your SP site
  • Copy the shortcut to the index.html file you just uploaded
  • Add a Page Viewer web part to your page and paste the shortcut to the index.html file as the web part source

And that’s pretty much it. Depending on the resolution of your flash file, you may have to adjust the dimensions in the web part appearance settings.