16 April, 2014

Charts for SharePoint

With Charts for SharePoint Professional edition you can easily aggregate and chart data from multiple sites. End-users can also filter the displayed data by using a configurable filter web part!


Install/Download using Web  Installer





Description
Version
Install Link
Standard Evaluation (SharePoint 2010/2013)
11.1.03
Professional Evaluation (SharePoint 2010/2013)
11.1.03


Download Installable Packages





Description
Version
Install Link
Standard Evaluation (SharePoint 2010)
11.1.03
Standard Evaluation (SharePoint 2013)
11.1.03
Professional Evaluation (SharePoint 2010)
11.1.03
Professional Evaluation (SharePoint 2013)
11.1.03



Documentation & Tools





Description
Version
Install Link
Admin Guide
11.1.03
KWizCom Resource Translator Utility -
1.1.00
Automatically translates KWizCom add-on


to any language


KWizCom Resource Translator User Guide
1.1.00

15 April, 2014

Cannot uninstall Language Pack 0 because it is not deployed

SharePoint 2013 is really a good product w.r.t. functionality and awesome GUI to work with! But today’s article is based on the error that I faced while updating the solution.

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.

Here is the error message:
Cannot uninstall Language Pack 0 because it is not deployed when attempting to uninstall-spsolution

One thing we always need to understand is the logic would be same for the functionality irrespective of which SharePoint version you are working!

I have written one article in the past for SP2010 based on the same concept: http://sharepointknowledgebase.blogspot.com/2013/11/solution-deployment-stuck-on-deploying.html and today I am going to elaborate more on the same theory as I have resolved the above mentioned error message with the same funda.

What’s that funda? – Here we go:
If you are facing this error message then I would suggest checking the status of your solution in central administration. How to check this? Here are the details:
o   Central Administration
o   System Settings
o   Manage Farm Solutions
o   It will open the solution management
o   Here you can check the status of your solution

If your solution is showing updating, deploying or retracting status then first and top most check that you need to verify the status of your TIMER JOB across all WFE’s.  How to check this? – Here are the details:
o   Login to your web front end (WFE)
o   Start
o   Run
o   Type “services.msc” and hit enter
o   It will open the services console
o   Click on any service and press S
o   It will directly show you the SharePoint Services
o   Second service will be SharePoint Timer Service
o   Check the status across all your servers

Two outcomes will be there:
1.   Timer service will be stopped one of the server:
If this is the case then start the timer job on that specific server and check the results by executing the commands that you are using.

2.   Timer service is started on all the servers:
If this is the case then restart all the SharePoint Timer Services across all servers. Once this done then execute the commands that you are doing and check the results

If you are looking out command reference then please refer this link in which I have given the reference of add solution as well as update solution:

Details notes:
Add-SPSolution
Add-SPSolution -LiteralPath c:\nameofyoursolution.wsp

Install-SPSolution
Install-SPSolution -Identity nameofyoursolution.wsp –GACDeployment

Uninstall-SPSolution
Uninstall-SPSolution -Identity nameofyoursolution.wsp

Remove-SPSolution
Remove-SPSolution -Identity nameofyoursolution.wsp

Update-SPSolution
Update-SPSolution -Identity nameofyoursolution.wsp -LiteralPath c:\nameofyoursolution.wsp -GACDeployment

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
o   SharePoint 2010
o   SharePoint 2007

14 April, 2014

'We hit a snag' Mysite error - SharePoint 2013

Before I hit the actual scenario, let me share some existing documentation on the same:
1.   Clicking on a followed site returns "We hit a snag" in a publisher-consumer scenario: http://support.microsoft.com/kb/2831053/EN-US

2.   "We’ve hit a snag" error message when a user clicks the Followed Sites or Followed Documents button in a consuming SharePoint Server 2013 farm

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:
I came across this issue with respect to Mysites when I clicked on the section “Sites I’m following”, following the error message:

Error message:
"We hit a snag. This link doesn't work anymore, likely because the item was moved or deleted. You might have luck searching for it and following it in its new location."

Troubleshooting done:
1.   Recycled the app pool but that didn’t solve the issue.
2.   Tested the link by directly opening in browser but that also didn’t solve the issue
3.   Executed IISRESET – resolved the issue temporarily but reoccurred again after some time.
4.   Tried changing the app pool account of Mysites with the Farm account – Success! But this is not a solution for me!

What’s the bottom line? – With the help of 4th troubleshooting step, it’s very clear that Mysites app pool account doesn’t have sufficient permissions.

I have already cross checked that this account (i.e. Mysites apppool account) has sufficient permissions from the SharePoint side but I wasn’t sure about the SQL side.

Finally I got it!

Resolution:
1.   Open the SQL Server management studio
2.   Security -> Logins
3.   You will see the complete list of accounts
4.   Right click on the mysite app pool account -> Properties
5.   Go to User Mapping directly
6.   Click on the specific database where the problem is and database role membership will get highlighted
7.   Select the checkbox ‘SPDataAccess’ and click OK
8.   That’s it – You are done! (FYI – it doesn’t required IISRESET)

Please check the results and let me know in case of any queries. I would be more than happy to help you as well as resolves your issues, Thank you.

Product Applies To:
o   SharePoint 2013

Reference:

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