PerformancePoint error: “Code blocks are not allowed in this file.”

While creating a new BI Center at my company we had no trouble building the site in dev, creating dashboards, Excel reports, etc.  Everything worked fine.  We were rolling the solution out to production (keeping in  mind, our dev and prod installations of SharePoint 2010 were created identically), but when we clicked on “Start Using PerformancePoint Services”, we were met with the error page and the message

An error occurred during the processing of /<BI Center>/Pages/ppssample.aspx.  Code blocks are not allowed in this file.

I started researching what could cause this, and saw numerous posts talking about modifying web.config.  Tried them all and got nowhere.  On top of that, I have a real hard time with just modifying web.config on a production system to fix a problem on a single site.  Fortunately, thanks to the @Statera contractors assisting us with the installation, we came across this TechNet article explaining how to fix this that made a LOT more sense.

Basically, you need to open the affected BI site in SharePoint Designer.  Click All Files under Navigation on the left, then in the pane to the right open the Pages folder and click on ppssample.aspx to open it.  When prompted to check out the file, check it out.  Locate the JavaScript function near the top called OpenDD() and edit the following two lines:

var siteCollection = "<%=SPHttpUtility.UrlPathEncode(siteCol.Value,false,true)%>";
var siteLocation = "<%=SPHttpUtility.UrlPathEncode(site.Value,false,true)%>";

And change them to this:

var siteCollection = "/";
var siteLocation = "///";

So if your bi center is located at http://server/sites/site/bicenter, var siteLocation should look like this:

var siteLocation = "/site/bicenter/";

Save the file and publish a Major version. You should now be able to click on “Start Using PerformancePoint Services” and run Dashboard Designer.

Hope this helps!

Eric

Eric Oszakiewski is a professional software developer based in Scottsdale, AZ with over 35 years of IT experience, and 19 years Native American Gaming experience. He is currently working as a Sr .Net/SharePoint Developer for General Motors, and also as a consultant.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube