13 April, 2014

No Save Site As Template SharePoint 2013

‘Save site as template’ is a pretty useful feature which has been carried out from SharePoint 2007 version and it’s still there in SharePoint 2013. Useful functionality when we want to transfer the site structure from one location to another with small data as it has a size limitation. I don’t want to discuss about size limitation in this article as it altogether a different issue and needs a separate set of troubleshooting.

In the past, I have written some useful articles to share the knowledge based on the same topic. Please find the following references:

Mystery of save site as template in SharePoint 2010

Save site as template using SharePoint Designer 2010

Save site as template is missing

How to activate the site template in the solution gallery

Unexpected error has occurred while saving the site as template

IMP NOTE:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Problem description:
One user has reported an incident that he is not able to save the site as template. – That’s a plain description. Previously I thought that he might be facing some problem/error while saving the site as template but further probing revealed the fact that he is not able to see the option “save site as template”.

Error message:
There is no error message here as the link is missing so NA.

Let me tell you some facts which are useful to understand the logic behind this-
It’s been pretty clear that if you have the publishing feature activated on your site collection then ‘save site as template’ won’t be there.

Reference:
SharePoint Publishing feature does not support "Save Site as Template" option

But there is a tweak here for SharePoint 2007 and SharePoint 2010 versions as people can get this functionality / access that page by appending http://sitename/_layouts/savetmpl.aspx !

But this is a closed loop in SharePoint 2013 as you cannot browse that page by making the changes in the URL.

But after when I realized that it’s not possible using GUI so i started exploring SharePoint Designer 2013 and found the solution.

Resolution / Here are the complete details:
1.   Open the SharePoint Designer 2013
2.   Top Ribbon
3.   You will see the ‘site options’
4.   Click on it
5.   You will see 4 different tabs (Parameters, language, advanced and navigation)
6.   Click on parameters tab and you will see the option of “SaveSiteAsTemplateEnabled” is set to False
7.   Select the option ->click on Modify
8.   Set it true
9.   Click on Apply and OK

Please refer the following screenshot for better clarity.



If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues. Thank you.

Product Applies To:
o   SharePoint 2013

11 April, 2014

401 unauthorized + Dashboard Designer + PerformancePoint: SharePoint2010/SharePoint2013

I think I am loving this functionality i.e. PerformancePoint Services as every time i tried doing something then always get some new error message. This time also I got this error while trying to launch the dashboard designer:

Error message#1: 401 unauthorized

Error message#2: The remote server returned an error: (401) Unauthorized

How to reproduce this issue?
1.   Open your business intelligence (BI) site
2.   You will see a button on the home page named as Dashboard Designer
3.   Click on it and BOOM
4.   You will get the above mentioned error message.

Troubleshooting done:
1.   Tried in Internet explorer, Mozilla Firefox and Google chrome but all the giving me the same error message.
2.   I don’t have a multiple domains so avoiding the possibility of dashboard not recognizing the credentials
3.   There is no chance of permissions here as I am already having site collection admin access.
4.   ULS logs and event logs

I have checked the ULS and found the found details:

BrowserSettings browserSettings, String& errorPageUrl)
   at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
  --- Inner Exception ---
  System.Net.WebException
  - The remote server returned an error: (401) Unauthorized.
  - Source: System
  - Stack trace:
   at System.Net.HttpWebRequest.GetResponse()
   at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

After lot of trial and exception, found the following details which are ultimately a resolution.

Resolution#1:
1.   Open your SharePoint site
2.   When it prompts for credentials then please check the option
3.   Remember my credentials
4.   That’s it- you will be able to launch “Dashboard Designer” without any issues.

Resolution#2:
1.   Open this link and follow the instructions (windows 7)
3.   Save your credentials and check the results.

Resolution#3:
1.   Open a blank IE (internet explorer)
2.   Tools
3.   Internet options
4.   Security
5.   Local Intranet -> sites -> add your site here ->click OK only once
6.   Coming back to security tab ->custom level
7.   Scroll towards the bottom
8.   Select prompt for username and password
9.   Click OK completely -> close the browser -> open a new IE ->open the BI site and check the results.

In case of any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Note:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product applies to:
- SharePoint 2010
- SharePoint 2013 

References:
An error occurred during the processing of /PerformancePoint/Pages/ppssample.aspx. Code blocks are not allowed in this file http://sharepointknowledgebase.blogspot.com/2013/11/code-blocks-are-not-allowed-in-this.html

We're sorry. We ran into a problem completing your request. Please try that again in a few minutes:
http://sharepointknowledgebase.blogspot.com/2014/04/were-sorry-we-ran-into-problem.html

Unattended service account for PerformancePoint
http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

This data source cannot be used because performancePoint services is not configured http://sharepointknowledgebase.blogspot.com/2013/10/this-data-source-cannot-be-used-because.html

Cannot connect to PerformancePoint Services in SharePoint 2010 http://sharepointknowledgebase.blogspot.com/2013/07/cannot-connect-to-performancepoint.html

Performance Point Service could not connect to the specified data source
http://sharepointknowledgebase.blogspot.com/2014/04/performance-point-service-could-not.html 

10 April, 2014

PerformancePoint Error: The list containing this item no longer exists or you do not have permission to view it

Error Messages:
The list containing this item no longer exists or you do not have permission to view it. The item cannot be viewed. Additional details have been logged for your administrator.

The following lists cannot be accessed from SharePoint Server. These lists have been deleted or you no longer have permissions to open them. If you lost your network connection, please try again after the connection is restored."

IMP:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.


Some known facts / additional notes:
1.   Performance Point doesn't support claims-based

2.   Make sure the account you use to logon the server has proper permissions to the data connection list since when SharePoint open dashboard designer from client side, it use the current account of the server not the current account of the SharePoint site.

3.   Does the web app pool identity have permissions to connect to performance point service application?

4.   Have you configured the unattended service account?


6.   The service account that runs the IIS app pools had to be added as a reader in the BI Center.

7.   Run this command:
$w = Get-SPWebApplication -Identity http://SharePointGalaxy

$w.GrantAccessToProcessIdentity(“domainPerformance Point Web App Service Account”)

Reference:
Planning and Architecture Guide for Planning Server

PerformancePoint Training Documentation:

BI-VPC (This is a Virtual image that includes all aspects of PPS and BI including samples 2 parts):

Part 1:

Part 2:

PerformancePoint Documentation Library:

PerformancePoint Marketing Site:  http://www.microsoft.com/business/performancepoint



If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:
1.   SharePoint 2010
2.   SharePoint 2013

09 April, 2014

Performance Point Service could not connect to the specified data source

One more performance point issue! Previously I have written some articles based on Performance Point Services (PPS) issues and their resolutions, as follows:






Note:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

I have faced the following error while working on PPS and trying to connect SharePoint list via Dashboard Designer.

Error Message:
PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.



How to reproduce this error?
1.   Open your site in browser
2.   Click on Run Dashboard designer


3.   You will see two options Data connections and PerformancePoint content
4.   Right click on Data connections -> New Data source


5.   Select the data that you are trying to connect (SP list, SQL Server table, analysis services, excel services)
6.   BOOM -> You will get the error at this step!

How to resolve this issue?

Here are the details: [2 step resolution]

Make sure the unattended account has already created. If this is not yet created then please use this link: http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

Before you start any troubleshooting, please ensure you check your ULS logs as it will give you the exact root cause behind it. When we checked our ULS logs then we found out that “the account needs Read Permission”)

It’s pretty simple once I know the cause. How to check this?
1.   Central administration
2.   Manage web applications
3.   Select the web application which is associated with your site
4.   User Policy
5.   Assign full read permission to unattended service account.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:
-SharePoint 2010
-SharePoint 2013

Reference:
http://office.microsoft.com/en-us/dashboard-designer-help/getting-started-performancepoint-dashboard-designer-HA100800792.aspx