17 April, 2014

InfoPath form library forms cannot be filled out in a Web browser

Today I was monitoring the SP servers along with some regular sanity checks that need to be carried out on daily basis. While doing that, I noticed one error based on this InfoPath rendering in the Health check analyzer!  But let me tell guys InfoPath is perfectly working in our environment without any issues and nobody has reported any incident also then why this error is showing in the health analyzer? – you must be thinking the same but no need to worry about as this is not a big one which will take lot of your time, some minor checks and you are done.

Error message:
InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured.

If this is your new configuration then you need to follow this existing official documentation from Microsoft which is pretty awesome!

In our case, we have already done this configuration long time back and as I said, it’s working fine. The error message is little bit misleading one as its asking you to check the “state service” service application to be online or not but that’s not the case. We have already configured this service application long time back so where exactly the issue is and why it’s throwing the error?

Let me tell you the trick which we sometimes ignored – Look out the error in the HAL rule – see the below:


You will notice that it’s also giving you the URL of the web application for whom its failing and name of the servers also.

In our case, we have recently created a new web application in the farm and its been reflected in that! What it means? Pretty simple – the ‘state service’ service application is not configured for the same.

So what we need to do now for this re-association? Here are the details:

Resolution:
1.   Open the central Administration
2.   Application management
3.   Service applications
4.   Configure service application associations
5.   Select the web application for whim it’s failing
6.   Click on custom
7.   It will open the service application options
8.   Select the state service check box and click OK

Once you are done with the above steps then come back to health analyzer list, click on the same rule and hit “Reanalyze now” – that’s it, you are done.

That error won’t be there! Happy SharePoint once again…
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.

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:
o   SharePoint 2010
o   SharePoint 2013
o   SharePoint Foundation 2013
o   SharePoint Foundation 2010

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