Health Analyzer problems - SharePoint 2010 + SharePoint 2013

Recently our farm has reflected some strange problems and long list of exceptions in Health analyzer. It was not so critical because Microsoft has made it so easy by publishing these following articles:

The settings for Word Automation Services are not within the recommended limits

Resolution- http://technet.microsoft.com/en-us/library/hh487292.aspx

A State Service Application has no database defined

Resolution- http://technet.microsoft.com/en-us/library/ff805088.aspx

Accounts used by application pools or service identities are in the local machine Administrators group

Resolution- http://technet.microsoft.com/en-us/library/hh344224.aspx

All State Service databases are paused for a State Service Application

Resolution- http://technet.microsoft.com/en-us/library/ff805083.aspx

Some content databases are growing too large

Resolution- http://technet.microsoft.com/en-us/library/hh685079.aspx

Content databases contain orphaned Apps

Resolution- http://technet.microsoft.com/en-us/library/jj891125.aspx

Millions Thanks to Microsoft & the product team for publishing these articles.

one or more field types are not installed properly

Issue: When accessing Managed Content and Structure in SharePoint 2010 site collection, you get an error message.

Error Message: One or more field types are not installed properly. Go to the list settings page to delete these fields: SharePoint 2010.

Background: After recent migration from SharePoint 2007 to SharePoint 2010, when we try to access the Managed content and Structure from the Site settings. It’s through the above error message.

Troubleshooting:

Tried to deactivate the SharePoint Server Publishing Infrastructure features form the Site Collection Features and checked on the site settings page, managed content structure page option was disappeared. Tried to activate Publishing Feature again. It did activate but accessing Managed content and structure again throws the same error.

Resolution:

According to allot many blog/sites on the internet it is said that when this feature is activated it creates an internal List “Relationships List” which is used to store the variations details. This list is a hidden list and cannot be seen from view all site content option. This error occurs because this list was not upgraded correctly.

By looking at difference between a list on SharePoint 2007 and SharePoint 2010 sites. the GroupID field from SharePoint 2007 site has changed to GroupGUID in SharePoint 2010 and the type of field has changed from text to GUID.

The solution is to delete the ‘Relationships List’ manually. You can access the list either directly from the URL.

http://sharepoint2010.com/Relationships%20List/allitems.aspx or

From SharePoint Designer.

From URL, access the list and hit delete the lib from Library ribbon and from designer, just right click on the list and delete.

Note: Before performing deletion from either of the method, don’t forget to deactivate the SharePoint Server Publishing Infrastructure feature and after performing deletion, remember to activate the feature again.

Now you can check the list containing the column GroupGuid of type GUID. Try to access Managed Content and Structure and it should work now.  

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.

Applies to: SharePoint Foundation Server 2010, SharePoint 2010, IE7, IE8, Outlook 2007, and Outlook 2010. 

The Unattended Service Account Application ID is not specified or has an invalid value + VISIO + SharePoint 2010

HEALTH ANALYZER REPORTED ISSUE

Today’s article is based on an alert which has been triggered by Health Analyzer and it’s based on VISIO SERVICE APPLICATION.

What’s the problem? How that alert has been triggered?

Let me explain this scenario step by step so that there will be no confusion-

My manager has asked me to create a Visio service application with respect to some upcoming project that we need to work on…So I simply go ahead and created the requested service application and replied back by saying please start the testing and reach out to me in case of any issues. I was pretty much relaxed as I have done my job and waiting for the inputs.

So far so good- but I have a habit of checking the health analyzer every now and then to check of any errors/exceptions/new alerts/triggers.

Here starts the problem- I checked and found the following problem:

The Unattended Service Account Application ID is not specified or has an invalid value.

Mentioned remedy: http://technet.microsoft.com/en-us/library/hh204612.aspx

If you follow the above mentioned remedy then 100% your issue will be resolved but it’s not very clear and up to the mark and that’s why I am writing this article to make it more clear and concrete one.

Step by Step Resolution:

Phase#1

1)   Central administration

2)   Application management

3)   Manage service application

4)   Select secure store service SA

5)   Now you need to generate a NEW KEY (you can ignore this steps if you have already done it before)

6)   Enter the pass phrase

7)   Click OK

Phase#2:

1)   We have to be on the same page i.e. secure store service application

2)   Now we need to click on NEW

3)   Now you need to fill 4 important textboxes

a)   Application ID: Make sure you enter something unique and note it down somewhere as we cannot change it back.

b)   Display name

c)   Valid email address

d)   Target application type- it should be group here

e)   Click on Next (Don’t change anything, keep the displayed info as it is)

f)    Enter your farm credentials (Domain\username) in both administrators as well as members section.

4)   Click OK

By this way, we have done 70% job completed (Phase 1 and phase 2) with respect to secure store service application.

Now we need to complete 30% with respect to the actual application i.e. VISIO service application.

Phase#3: -last step-

1)   Central administration

2)   Application management

3)   Manage service applications

4)   VISIO Service application

5)   Global settings

6)   You will see a textbox of application id- you need to enter the same application id that we have used in the above steps

7)   Click OK

That’s it- we are done. What you need to do now- very simple!

1.   Central administration

2.   Click on health analyzer link

3.   Click on the alert which is showing for VISIO

4.   Reanalyze now

5.   Gone!

Happy SharePoint to all of you

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 Server 2010

2)   SharePoint Foundation 2010

3)   SharePoint 2013

References:

1)   http://social.msdn.microsoft.com/Forums/en-US/51491329-1556-4e92-b6ab-8fc550774808/the-unattended-service-account-application-id-is-not-specified-or-has-an-invalid-value

2)   http://technet.microsoft.com/en-us/library/ff773327.aspx

3)  http://technet.microsoft.com/en-us/library/ms160340.aspx

You do not have the necessary permissions to use the '' object" + SharePoint2007 + Access

Issue: Connecting a List to Access database throws an error message.

You do not have the necessary permissions to use the '' object. Have your system administrator or the person who created this object establishes the appropriate permissions for you.

Background: One of my clients trying to connect a SharePoint List by MS Access. After waiting some time, getting error message specified above. Also getting the same error message when trying to connect to MS Access from SharePoint by converting the list to data sheet view

System Information:

1)   Windows XP

2)   Office 2007

3)   Access 2007

4)   Access 2010

5)   SharePoint 2007

Troubleshooting:

1)   Tried to save list as a template and created a new list issue persist in both cases when saved with content and without content.

2)   Tried to connect same list to excel and did not work.

3)   Tried repairing the office suit, didn’t work at all.

4)   This seems to be clearly an issue with the SharePoint List.

Resolution:

Tried looking at columns side of the list and did some deep dive based of the exact error were getting and found the below KB from MS, which was the resolution of the problem and gave a clear instructions to reproduce the issue.

http://support.microsoft.com/kb/924739

Checked the columns names on the List and there were two columns which were using more than 64 characters in it title field.

Eliminating them from the list and connecting List again from MS Access to SharePoint does work and vice versa.

Applies to:

1)   Windows SharePoint Service 3.0

2)   MOSS 2007, MS Access 2007

3)   MS Access 2010.

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.

Pages are opening abruptly in IE7 when sending page as Email: SharePoint 2010

Issue: When a client send a SharePoint Site Page via IE it was opening abruptly in Email.

Background: One of my clients was trying to send the SharePoint as a page using the IE options, File – Send – Page by Email the page was opening abruptly. Nothing was in place. As unexpectedly it should be send by as a normal webpage.

Troubleshooting:

Checked the IE settings.

Cleared the cache of IE,

Restored the IE factory settings but no luck in any case.

It seems to be more of the page layout issue.

Trying out IE options doesn’t help me. I gave a try to the play with outlook settings.

Checked various settings with outlook.

Changing the mail format settings to rich text did helped to resolve the issue.

Resolution:

Change the mail format to Rich Text and then send the Page as Email from IE.

For outlook 2007

1.    .Open the outlook

2.    On the Tools menu, click Options, and then click the Mail Format tab.

3.    In the Compose in this message format list, click the format that you want.

4.    Open IE, from File tab open the Send, Click Page by Email.

http://office.microsoft.com/en-gb/outlook-help/change-the-message-format-to-html-rich-text-or-plain-text-HP001232996.aspx

For outlook 2010

Open the outlook.

1. Click the File tab.
2. Click Options.
3. Click Mail.
4. Under Compose messages, in the Compose messages in this format list, click HTML, Rich Text, or Plain Text.

http://office.microsoft.com/en-gb/outlook-help/change-the-message-format-to-html-rich-text-or-plain-text-HA101992313.aspx

5.    Open IE, from File tab open the Send, Click Page by Email.

Following the above steps should send the page in the normal way as you see it in the browser.

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.

Applies to: SharePoint Foundation Server 2010, SharePoint 2010. IE7, IE8, Outlook 2007, Outlook 2010.