Wednesday, July 31, 2013

SharePoint 2013 PerformancePoint CodeBlocks Not Allowed followed by PerformancePoint designer stopped working Error Code: clr20r2

When moving a BI Site collection from server to server using backup and restore of the site 9/10 times PerformancePoint doesn't work.

The 2 basic steps below usually work for me

1- Go to the web.config file of the web application within the <PageParserPath> header add the following line.
<PageParserPath VirtualPath="<insert PPSSample Path Here>" CompilationMode="Always" AllowServerSideScript="true" />
IISReset /noforce

The default path for the ppssample aspx is probably /Pages/ppssample.aspx
if after fooling around with the above script PerformancePoint still gives you the codeblocks are not allowed error try the below to get it working for debugging purposes but this is a security concern if used especially on production
<PageParserPath VirtualPath="/*" CompilationMode="Always" AllowServerSideScript="true" />

Now sometimes when this error has been resolved PerformancePoint decides to throw another error stating the below
PerformancePoint designer stopped working Error Code: clr20r2 
This happens especially frequently if you have been using PerformancePoint on this machine before restoring this site because the cache contains incorrect references. To solve this issue we go to step 2

2- 
Go to C:\Users\<CurrentLoggedInUser>\AppData\Local\Apps\2.0
Delete all the files and folder in this path
Try to start PerformancePoint now and it should work