11 March, 2013

Missing Webparts- One of the crtitical error from HEALTH ANALYZER

Missing server side dependencies- The Umbrella which covers 4 critical issues
Missing features has already been covered under this section:

Remaining ones are missing webparts, missing setup files and missing assemblies.

Let’s concentrate on Missing Webparts section:
[galaxy.SPWP.FSODataParser,
Culture=neutral,
PublicKeyToken=fc9c10bf499fbb4b])
[WSS_Content_SP2010],
in
database
[WSS_Content_SP2010],
farm.
[EasyTabParts,
Culture=neutral,
PublicKeyToken=b15a43dfe3a17723])
[WSS_Content_SP2010],
[MC_Menu,
Culture=neutral,
PublicKeyToken=d088e98baa178219])
[WSS_Content_SP2010],

[Microsoft.Office.Server.Search,
Culture=neutral,
[SharePoint_AdminContent],
[Microsoft.SharePoint.Portal,
Culture=neutral,
[SharePoint_AdminContent],

Some webparts are belongs to SharePoint_AdminContent database. While debugging further on this, we tried to find out the leaf names as well as dir names are a part of which links/URL’s exactly but we didn’t find anything. That’s strange to troubleshoot further.

The GUIDS which are belongs SharePoint_AdminContent Database are as follows:
[baf5274e-a800-8dc3-96d0-0003d9405663]
[9eba9c17-3b89-a2e7-a3cf-0ee3d7c2adb1]
[07f48b68-2e69-c86a-ebe4-16359e03ebc2]
[23091f6c-295d-4493-504c-1714a20d65a2]
[7d319bdd-d90e-7861-b7f0-2f9f4cec3004]
[c744e2b2-158c-c2f8-2f80-54bf046ff644]
[36f2680f-4855-f100-da5b-5dd1d07ae62b]
[b36f9dfe-325a-1b44-e6bb-645dcf79c770]
[0a60f514-1dea-8537-b588-64ee5e224da3]
[9f56656f-6aa3-0d55-a812-711bf65864ea]

Further research on this, we came to a conclusion that this is a known issue regarding this GUIDS belongs to AdminContent DB and we can certainly ignore that. This will gets fixed in the next CU.


Example:

Error Message:
[MissingWebPart] WebPart class [a03a7e7e-aab8-9045-8bf2-54d79ff53595] (class [PowershellWebpart.PowershellWebPart.PowershellWebPart] from assembly [PowershellWebpart, Version=1.0.0.0, Culture=neutral, PublicKeyToken=0bf26c041eeaa3b0]) is referenced [1] times in the database [WSS_Content_Sharepoint.SP2010], but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database [WSS_Content_Sharepoint.SP2010], but are not installed on the current farm. Please install any feature or solution which contains these web parts.

As we can see, the error gives you a “WebPart class” GUID, the name of the content database, and how many times it is referenced in the database but no site collection link.

Following SQL query will be used to find out the site ID, LEAF name and Directory name.
"SELECT * from AllDocs inner join AllWebParts on AllDocs.Id = AllWebParts.tp_PageUrlID where AllWebParts.tp_WebPartTypeID = '4575ceaf-0d5e-4174-a3a1-1a623faa919a'" | select Id, SiteId, DirName, LeafName, WebId, ListId, tp_ZoneID, tp_DisplayName | Format-List

SITE ID: we can easily find out the site collection link based on the fetched site ID details
LEAF name: this will be a page on which that faulty webparts exist
DIR name: this will be a document library in which those pages exist.

Output will be like this:
Id       : 657a472f-e51d-428c-ab98-502358d87612
Name     :
SiteId   : 337c5721-5050-46ce-b112-083ac52f7f26

To find the site collection URL using the information output from the query, type the following command:
$site = Get-SPSite -Limit all | where {$_.Id -eq "337c5721-5050-46ce-b112-083ac52f7f26"}
$site.Url

Once we have the site collection URL, we can use the relative path specified by the DirName property to find the location of the file.

To remove the web part from the page, type the page URL in the browser and add?contents=1 to the end of it.

That’s it. You will see the web part maintenance page on which faulty/corrupted webparts are listed.

If you have any questions/queries regarding the above mentioned information then please let me know. Thank you.

05 March, 2013

Approval Workflow Error : "An error has occured in Approval"

I have came accross 2 -3 tickets in this week in which the user gets an error in the approval workflow. I knew the solution to it but the user wanted something documented . So tried to check on my blog if i have posted it and found that it was not . so adding to the list .

Issue : Error on Approval Workflow : "An error has occured in Approval"

User has a SharepPoint OOB Approval workflow which can be created through the site and easily be attached to a document library and it starts manually or automatically when a new document gets created and get the required approvers to review and approve the document for publishing.

How to configure a Approval workflow :

For a document library or list

Go to Settings->Workflow Settings->Add Workflow
Choose the Approval workflow from the list, make it start on item creation go to the next page.

Select the approvers and check "Update the approval status"

Click Finish and the workflow is created .

Although this is a easy way to configure the workflow It might end-up with a error:

 Error  System Account :  An error has occured in Approval

A small setting can change the whole error .

This is an approval workflow which should after getting the approvals update the approval status of the document .

The workflow will start and run flawlessly until the end and when it will try to update the approval status.If this setting under Versioning settings is not set  to require content approval it will fail to update the status and thorws the error.

An error has occured in Approval

So, if you come accross an Approval Workflow

Go into the document library settings and go to Versioning Settings Page

Set "Require content approval for submitted items to?"

To Yes and everything should be fine.

This would not make any changes to the Existing status of the workflow . Terminate the workflow and run it again .

01 March, 2013

New Learning Roadmaps for SharePoint 2013

A learning roadmap is a way of organizing content (articles, white papers, videos, blog posts, etc.) to provide a customized and optimized learning path for a technology, feature, product, or solution. Starting with prerequisites and then moving on to introductory, intermediate, and advanced learning goals, learning roadmaps enables a novice to ramp up quickly and an experienced technology person to build more expertise in a particular area.
My colleagues on the SharePoint IT pro writing team have been very busy publishing the following additional learning roadmaps:
If you need to technically ramp up in any of these areas, take a look at these articles to understand the prerequisite knowledge and then dive in.
See Learning roadmaps for SharePoint 2013 for the complete list for SharePoint 2013.
See Learning Roadmaps Portal for the complete list across Microsoft products. To create your own learning roadmap, see the Learning Roadmap Template.

Missing server side dependencies



We have done the migration from SharePoint Server 2007 to SharePoint 2010. After the successful migration, when we checked the HEALTH ANALYZER reports then we have seen the following errors:

Exception#1:
[MissingFeature] Database [WSS_Content_101] has reference(s) to a missing feature: Id = [fc5e2840-0b48-42eb-9ad7-076f5add58ad]. The feature with Id fc5e2840-0b48-42eb-9ad7-076f5add58ad is referenced in the database [WSS_Content], but is not installed on the current farm. The missing feature may cause upgrade to fail. Please install any solution which contains the feature and restart upgrade if necessary.

Exception#2:
[MissingWebPart] WebPart class [8d6034c4-a416-e535-281a-6b714894e1aa] is referenced [20] times in the database [SharePoint_AdminContent_8c793f3b-123c-4965-81b3-b7bbed64d8ae], but is not installed on the current farm. Please install any feature/solution which contains this web part. One or more web parts are referenced in the database [SharePoint_AdminContent_8c793f3b-123c-4965-81b3-b7bbed64d8ae], but are not installed on the current farm. Please install any feature or solution which contains these web parts.

Exception#3:
[MissingSetupFile] File [themes\THEME\alldaydefault_granite.gif] is referenced [4] times in the database [WSS_Content], but is not installed on the current farm. Please install any feature/solution which contains this file. One or more setup files are referenced in the database [WSS_Content], but are not installed on the current farm. Please install any feature or solution which contains these files.

Exception#4:
Assembly [Nintex.Workflow.Features, Version=1.0.0.0, Culture=neutral, PublicKeyToken=913f6bae0ca5ae12] is referenced in the database [WSS_Content], but is not installed on the current farm. Please install any feature/solution which contains this assembly. Remedy: One or more assemblies are referenced in the database [WSS_Content], but are not installed on the current farm. Please install any feature or solution which contains these assemblies.

Long series of messages, it’s very difficult to troubleshoot this all messages/exceptions in a single shot so I have targeted one exception: [Missing Feature]

As per the error message, we have the following details as follows:

Name of the database: WSS_Content_101
Feature ID: fc5e2840-0b48-42eb-9ad7-076f5add58ad
Site Collection Link: No Info
Site collection ID: No Info

Hmm...Really difficult to delete this feature if we don’t have a site collection links.

I think if we have a site ID/Link then it’s very simple to delete this feature but the problem is there are so many features which are throwing exceptions against the same database name so there might be so many site collections.

Resolution:
Million Thanks to Codeplex Team

These types of errors can be cleaned up using the SharePoint Feature Administration and Clean Up Tool on Codeplex: http://featureadmin.codeplex.com

Product Applies To:
SharePoint Server 2010
SharePoint Server 2013
SharePoint Foundation 2010

Important Note:
My Troubleshooting is still going on to find out the resolution for further exceptions. Will keep you posted regarding each and every exception. Thank 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.

27 February, 2013

Feature enhancements in SharePoint 2013 than SharePoint 2010.

SharePoint 2013 general model remain same as SharePoint 2010 but has few platform level improvements and new capabilities like
• Shredded Storage
• SQL Improvements
• Cache Service
• Request Management
• Themes
• Sharing

In terms of Service Applications:
• New service applications available and improvements on existing ones
• Office Web Apps is no longer a service application
• Web Analytics is no longer service application, it’s part of search

Enterprise content Management
• Policies:
• Site-level retention policies compliance levels has been extended to sites
• Policies include Retention policy for sites and Team Mailbox associated with site
• Project closure and expiration policy

• Designed for managing discovery cases and holds
• Establishes a portal through which you can access discovery cases to conduct searches, place content on hold, and export content
• eDiscovery capabilities
• Support for searching and exporting content from file shares
• Export discovered content from Exchange and SharePoint
• Team folders
• Seamless integration of Exchange and SharePoint to provide best of both world and end user flexibility

Web Content Management
• Support the tools and workflows designers usage
• Variations & Content Translation
• Search Engine Optimization
• Cross Site Publishing
• Video & Embedding
• Image renditions
• Clean Urls
• Metadata navigation

Social
• Microblogging
• "Share content, links, and media"
• Follow people, sites, content, and conversations"
• Activity Feeds
• Provides a view into recent activity related to content, links, media, and people"
• Communities
• Community sites with self-service administration and moderation
• Modern community features such as achievements and reputation
• Discussions
• Modern discussion boards
• Blogs
• Client application integration
• "Categories, comments, and moderation "

Search
• New Search architecture with one unified search
• Personalized search results based on search history
• Rich contextual previews