Archive for September, 2014

Primer on SharePoint Hosting for External Collaboration

Wednesday, September 24th, 2014

Primer on SharePoint Hosting for External Collaboration

V: 1.0

Scope:

The scope of this document covers the On-Premises SharePoint and using it for your external partners, vendors and customers in compliance scenarios or public organization where they decide to keep the data internal only rather than on the cloud. This topic doesn’t cover the hybrid approaches either.

It does not imply that the Office 365, Azure or other recent cloud services are short of features. These services offer so much robust features, time & cost savings and other benefits that can be beneficial to any organization. [Review my blog post and presentation on the comparison of On-Premises, Office 365 and Hybrid]

This document can be used as a case study to persuade the company management to cloud based solutions. On-Premises SharePoint deployment, operation, management and support may require a wide knowledge of different technologies, processes and best practices [Review my article on SharePoint Brainstorming Plan]. You need more breadth of skills versus depth of skills in most if not all situations.

Pieces of the SharePoint Puzzle:

In order to do the SharePoint hosting for external collaboration, you need to know different elements. Following are some of the skills, knowledge and experience that are needed to host the On-Premises SharePoint for external collaboration.

  1. IIS Web Server
  2. SQL Server Database
  3. Windows Servers
  4. Firewall – CISCO ASA or others
  5. Authentication – Active Directory
  6. Claims / FBA (Riolinx Extradium)
  7. IP Addressing
  8. DNS – Internal
  9. DNS – External (Zone Edit or others)
  10. Wildcard SSL certificates with SAN (DigiCert or others)
  11. URL address name space and A records
  12. SharePoint ins and outs
  13. WebApp, Site collections, sites
  14. Office Web Apps
  15. .NET

Not knowing all these pieces, will require additional skills in the company. Below is our pieces of puzzle pyramid diagram.

Softvative Plan - SharePoint Pieces of Puzzle Pyramid
Softvative Plan – SharePoint Pieces of Puzzle Pyramid

One important thing, this is just a framework we created and have been using. In different scenarios, customer needs and integration requirements, you might have little more in the plate.

Plan your SharePoint Pieces:

Once you know what pieces are involved, then you have architect the plan on how you will be connecting the pieces. I use white boarding and Microsoft Visio for that purpose. Below is the abstract of one of the implementation  we worked on.

Sharepoint Hosting for External Collaboration - Architecture Planning on white board
Sharepoint Hosting for External Collaboration – Architecture Planning on white board

After this stage, you move on to the next stage of the project planning and execution. I’ll cover more on this topic in future versions.

Linked Excel Files and SharePoint

Wednesday, September 17th, 2014

Linked Excel Files and SharePoint

V: 1.0

I’ve been working lately with Microsoft Excel data report files that were linked and were uploaded to SharePoint. There are few scenarios where the linked files can cause issues if not used properly. I’m describing few scenarios below:

Scenario 1: User created MS Excel files on the desktop, linked those files (desktop or shared drive). then uploaded both files to SharePoint

Scenario 2: User created MS Excel files on the desktop, linked those files (desktop or shared drive). then uploaded only container file to SharePoint

Scenario 3: User created MS Excel files on the desktop, linked those files (desktop or shared drive). then uploaded both files to SharePoint and updated the linked files using their SharePoint links

Scenario 2 is common among Excel users. Users create linked excel files and upload only the main file aka the container file. In most cases the linked file was on the desktop of the user. Now when another user tries to open the Excel container file from SharePoint or from their desktop by copying it, they get errors / warning messages. That is due to container file not able to reach to author’s desktop file from SharePoint.

I copied the container excel file on my desktop and went through it.

MS Excel Container File that has linked files
MS Excel Container File that has linked files

Click on the File menu > Info. Under security warning section you will see the warning details.

MS Excel Container File that has linked files - File Info Security Warning section
MS Excel Container File that has linked files – File Info Security Warning section

Now you click on Enable Content from either the top middle  of file or within File > Info section in an attempt to get the complete data and you are presented with a warning as shown in following image.

Error:
We can’t update some of the links in your workbook right now.
You can continue without updating their values, or edit links you think are wrong.

MS Excel Container File Warning - Linked file not Reachable
MS Excel Container File Warning – Linked file not Reachable

You may get following warning message.

Error:
This workbook contains links to one or more external sources that could be unsafe.
If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have.

MS Excel Container File Warning - Linked file could be unsafe warning
MS Excel Container File Warning – Linked file could be unsafe warning

How to view the Linked Files in Container Excel File:
To view the linked files from container Excel file, go to Data ribbon tab and under Connections group click Edit Links.

MS Excel Container File - Edit Links to Linked File
MS Excel Container File – Edit Links to Linked File

In Edit Links window, if you select a source, you will see its location. In situations, you will find it pointing to the local desktop profile of users. Nice work with the data report, but not nicely executed.

MS Excel Container File - Edit Links window
MS Excel Container File – Edit Links window

MS Excel Container File on SharePoint and Linked file not reachable:

Now if you try to open the file directly from SharePoint, you will get warning messages. See the URL address has been appended with the linked file address!

Error:
We can’t connect to http://sharepoint.domain.com/users/WindowsProfile/desktop/excelfile.xls

Open MS Excel File from SharePoint - Linked file missing - See URL
Open MS Excel File from SharePoint – Linked file missing – See URL

Click Ok and you will be greeted with another warning. See the image below.

Error:
Microsoft Excel cannot access the file http://sharepoint.domain.com/users/WindowsProfile/desktop/excelfile.xls. There are several possible reasons.

  • The file name or path does not exist
  • The file name is being used by another program
  • The workbook you are trying to save has the same name as a currently open workbook.
Open MS Excel File from SharePoint - Linked file missing - Possible Reasons listed
Open MS Excel File from SharePoint – Linked file missing – Possible Reasons listed

My Treat for Linked Excel Files and SharePoint:

I’ll cover the other details in of different testing scenarios may be little later as time permits. I created a container and linked files with some test data. Feel free to download and play around with it on your SharePoint test farm.

Download the Test Excel Container File and Linked File

Note it down that office Web apps doesn’t support linked files. You will get prompts when viewing the Excel container file using Office Web Apps in SharePoint.

MS Excel Container File Opened in Office Web Apps in SharePoint - Linked file not supported
MS Excel Container File Opened in Office Web Apps in SharePoint – Linked file not supported

Few Resources on the Excel Linked files:

SharePoint Content Type Issues and Fixes

Friday, September 12th, 2014

We’ll discuss the following scenarions of SharePoint Content Type Issues and fixes

a. A Duplicate Content type was found

b. The specified name is already in use

Issue Summary

Recently I an issue got escalated to me where a user (with site collection admin permission) was getting errors when creating, deleting or modifying a SharePoint content type under a sub site.

Details

Error 1 – When creating, deleting or modifying a Content Type under a sub-site:

Error
A duplicate content type “0x010100672A3FCA98991645BE083C320B7539B7” was found. 
Troubleshoot issues with Microsoft SharePoint Foundation. 
Correlation ID: 448054d8-6897-429d-80db-3b1fba29f678 
Date and Time: 9/11/2014 10:32:20 AM 

Error when creating or deleting a content type in SharePoint
Error when creating or deleting a content type in SharePoint 

SharePoint ULS Logs:

SharePoint Farm’s ULS logs were not giving any helpful clue. I use the Query Correlation ID codeplex tool from SharePoint Central Admin website. It is quick and easy way to search on Correlation  ID errors.

Time Process Area Category Level EventID Message 
09/11/2014 10:32:20.70  w3wp.exe (SPWFEServer:0x13EC)  SharePoint Foundation  Logging Correlation Data  Medium xmnv Name=Request (POST:http://sharepoint.domain.com:80/sites/department/subsite/_layouts/ctypenew.aspx) 
09/11/2014 10:32:20.70  w3wp.exe (SPWFEServer:0x13EC)  SharePoint Foundation  Logging Correlation Data  Medium xmnv Site=/sites/department 
09/11/2014 10:32:20.82  w3wp.exe (SPWFEServer:0x13EC)  SharePoint Foundation  Runtime  Unexpected tkau Microsoft.SharePoint.SPException: A duplicate content type “0x010100672A3FCA98991645BE083C320B7539B7” was found. at Microsoft.SharePoint.SPContentTypeCollection.CheckConsistency() at Microsoft.SharePoint.SPContentTypeCollection.Update() at Microsoft.SharePoint.SPContentTypeCollection.AddContentType(SPContentType contentType, Boolean updateResourceFileProperty, Boolean checkName, Boolean setNextChildByte) at Microsoft.SharePoint.SPContentTypeCollection.Add(SPContentType contentType) at Microsoft.SharePoint.ApplicationPages.ContentTypeCreatePage.BtnOK_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPos… 
09/11/2014 10:32:20.82* w3wp.exe (SPWFEServer:0x13EC)  SharePoint Foundation  Runtime  Unexpected tkau …tBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
09/11/2014 10:32:20.82  w3wp.exe (SPWFEServer:0x13EC)  SharePoint Foundation  Monitoring  Medium b4ly Leaving Monitored Scope (Request (POST:http://sharepoint.domain.com:80/sites/department/subsite/_layouts/ctypenew.asp Execution Time=129.946403802718 

What content type is associated with the “0x010100672A3FCA98991645BE083C320B7539B7” listed on the error? Let’s come to that point in a minute.. (or scroll down this article 🙂 )

Even though the error was thrown, the site content type was created. I went into the Content Type page by clicking on its name under Site Actions > Site Settings > Site Content Types (under Galleries) > clicking on the name of the site content type (left column). I could see all the settings of the content type I created as a test.

SharePoint Site Content Type Settings Page
SharePoint Site Content Type Settings Page

A quick glance at the list of site content types revealed the duplicate content type – E-mail Submission.

SharePoint Duplicate Site Content Types - E-mail Submission
SharePoint Duplicate Site Content Types – E-mail Submission

Thinking that I found the problem, I went into the E-mail Submission site content type in an attempt to delete it. And guess what, not just the delete but the whole Settings section of the site content type was empty. :O At this point I was about to click the SharePoint’s ‘I Like it’ button but then I decided to to control the emotions. 🙂

SharePoint Site Content Type - E-mail Submission - Empty Settings area
SharePoint Site Content Type – E-mail Submission – Empty Settings area

Looking at the columns under the E-mail Submission Site Content Type, I decided to take a peak at Site Columns. I went to Site Actions > Site Settings > Site Columns (under Galleries group) > Locate the Site Columns related to E-mail Submission. I found there were duplicate site columns there for each instance of Site Content Type.

SharePoint Site Columns - Duplicate E-mail Submission Columns
SharePoint Site Columns – Duplicate E-mail Submission Columns

I clicked on the site column in order to delete it. Guess what, the delete button was not there :O. At this point I was thinking there should be ‘I Love It’ button there for me to click.

SharePoint Site Column - Delete button not present
SharePoint Site Column – Delete button not present

Resolution Process

At this point, I tried different things to resolve this issue. In my case, it was the last step. In your scenario, you might be able to fix it using any of these attempts (conditions apply based on your environment).

Attempt a – Try to enable & disable the related Site Feature

I tried to enable the ‘Content Organizer’ and ‘E-mail Integration with Content Organizer’ feature. I got another error.

SharePoint - Site Features
SharePoint – Site Features

Error when trying to activate the Site Features

Error 
The specified name is already in use.
Please try again with a new name. 
Troubleshoot issues with Microsoft SharePoint Foundation. 
Correlation ID: 72adbfb7-6416-466b-9d5f-2f94ca58e41c 
Date and Time: 9/11/2014 10:43:53 AM 

SharePoint - Site Feature Error - The Specified name is already in use.
SharePoint – Site Feature Error – The Specified name is already in use.

ULS Logs:
Time Process Area Category Level EventID Message 
09/11/2014 10:43:53.76  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Logging Correlation Data  Medium xmnv Name=Request (POST:http://sharepoint.domain.com:80/sites/department/subsite/_layouts/ManageFeatures.aspx) 
09/11/2014 10:43:53.78  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Logging Correlation Data  Medium xmnv Site=/sites/department 
09/11/2014 10:43:53.82  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  Medium 88jb Feature Activation: Activating Feature ‘DocumentRouting’ (ID: ‘7ad5272a-2694-4349-953e-ea5ef290e97c’) at URL http://sharepoint.domain.com/sites/department/subsite. 
09/11/2014 10:43:53.82  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  Medium 72bf SPContentTypeBindingElement.ElementActivated(). Applying ContentType ‘0x0100DC2417D125A4489CA59DCC70E3F152B2’ to list ‘RoutingRules’ on web ‘http://sharepoint.domain.com/sites/department/subsite’ 
09/11/2014 10:43:53.86  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  Medium 72bg SPContentTypeBindingElement.ElementActivated(). Successfully applied ContentType ‘0x0100DC2417D125A4489CA59DCC70E3F152B2’ to list ‘RoutingRules’ on web ‘http://sharepoint.domain.com/sites/department/subsite’ 
09/11/2014 10:43:53.86  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  Medium 75fb Calling ‘FeatureActivated’ method of SPFeatureReceiver for Feature ‘DocumentRouting’ (ID: ‘7ad5272a-2694-4349-953e-ea5ef290e97c’). 
09/11/2014 10:43:53.90  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  High 8kh7 The specified name is already in use. Please try again with a new name. 
09/11/2014 10:43:53.92  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Feature Infrastructure  High 88jm Feature receiver assembly ‘Microsoft.Office.Policy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’, class ‘Microsoft.Office.RecordsManagement.Internal.DocumentRoutingFeatureReceiver’, method ‘FeatureActivated’ for feature ‘7ad5272a-2694-4349-953e-ea5ef290e97c’ threw an exception: Microsoft.SharePoint.SPException: The specified name is already in use. Please try again with a new name. —> System.Runtime.InteropServices.COMException (0x81020043): The specified name is already in use. Please try again with a new name. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) at Microsoft…. 
09/11/2014 10:43:53.92* w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Feature Infrastructure  High 88jm …SharePoint.Library.SPRequest.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) — End of inner exception stack trace — at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) at Microsoft.SharePoint.SPGroupCollection.AddInternal(String name, SPMember owner, SPUser defaultUser, String description) at Microsoft.SharePoint.SPGroupCollection.Add(String name, SPMember owner, SPUser defaultUser, String description… 
09/11/2014 10:43:53.92* w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Feature Infrastructure  High 88jm …) at Microsoft.SharePoint.Utilities.SPUtilityInternal.CreateDefaultSharePointGroups(SPWeb web, String strUserLogin, String strUserLogin2, String strGroupNameSeed) at Microsoft.Office.RecordsManagement.Internal.DocumentRoutingFeatureReceiver.<>c__DisplayClass2.<FeatureActivated>b__0() at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code) at Microsoft.Office.RecordsManagement.Internal.DocumentRoutingFeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties) at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce) 
09/11/2014 10:43:53.92  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  High 72by Feature Activation: Threw an exception, attempting to roll back. Feature ‘DocumentRouting’ (ID: ‘7ad5272a-2694-4349-953e-ea5ef290e97c’). Exception: Microsoft.SharePoint.SPException: The specified name is already in use. Please try again with a new name. —> System.Runtime.InteropServices.COMException (0x81020043): The specified name is already in use. Please try again with a new name. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) at Microsoft.SharePoint.Library.SPRequest.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, I… 
09/11/2014 10:43:53.92* w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  High 72by …nt32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) — End of inner exception stack trace — at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) at Microsoft.SharePoint.SPGroupCollection.AddInternal(String name, SPMember owner, SPUser defaultUser, String description) at Microsoft.SharePoint.SPGroupCollection.Add(String name, SPMember owner, SPUser defaultUser, String description) at Microsoft.SharePoint.Utilities.SPUtilityInternal.CreateDefaultSharePointGroups(SPWeb web, String strUserLogin, String strUserLogin2, String str… 
09/11/2014 10:43:53.92* w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  General  High 72by …GroupNameSeed) at Microsoft.Office.RecordsManagement.Internal.DocumentRoutingFeatureReceiver.<>c__DisplayClass2.<FeatureActivated>b__0() at Microsoft.Office.Server.Utilities.CultureUtility.RunWithCultureScope(CodeToRunWithCultureScope code) at Microsoft.Office.RecordsManagement.Internal.DocumentRoutingFeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties) at Microsoft.SharePoint.SPFeature.DoActivationCallout(Boolean fActivate, Boolean fForce) at Microsoft.SharePoint.SPFeature.Activate(SPSite siteParent, SPWeb webParent, SPFeaturePropertyCollection props, SPFeatureActivateFlags activateFlags, Boolean fForce) 
09/11/2014 10:43:53.92  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Monitoring  High b4ly Leaving Monitored Scope (Feature Activation: Activating Feature ‘DocumentRouting’ (ID: ‘7ad5272a-2694-4349-953e-ea5ef290e97c’) at URL http://sharepoint.domain.com/sites/department/subsite.). Execution Time=96.1532820512104 
09/11/2014 10:43:53.92  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Runtime  Unexpected tkau System.Runtime.InteropServices.COMException: The specified name is already in use. Please try again with a new name. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) at Microsoft.SharePoint.Library.SPRequest.AddGroup(String bstrUrl, String bstrName, String bstrDescription, Int32 lOwnerID, Boolean bOwnerIsUser, UInt64 iPermMask, Int32 lUserId, Boolean bUseExisting, Boolean bSelfOwner) 
09/11/2014 10:43:53.92  w3wp.exe (SPWebServer3:0x2708)  SharePoint Foundation  Monitoring  Medium b4ly Leaving Monitored Scope (Request (POST:http://sharepoint.domain.com:80/sites/department/subsite/_layouts/ManageFeatures.aspx)). Execution Time=152.340032043179

Attempt b – Use SharePoint Designer to delete Site Content Type and Site column
I was not able to delete Site Content type and site column using SharePoint Designer.

Attempt c – Use SharePoint Manager and try to delete Site Content Type and Site Column
I downloaded the SharePoint Manager codeplex solution and tried to delete the Site Content Type and Site Column. No success.

Attempt d – Use the power of Power Shell to delete the Site Content Type and Site Column
Many SharePoint geeks have posted their nice Power Shell scripts. I tried couple of those but none of those were successful.

Attempt e – Dig into MS SQL Database and get rid of Site Content Type and Site column
It is not a recommended method unless all your options have failed. Test and verify it in your pre-production first and make sure you have the database backups.

To use this method, you need to find the SharePoint Content Database that is associated with the site in this issue. [Hint: SharePoint Central Administration website > Application Management > Manage Content Databases > select the web app from the Web Application menu].

SharePoint - SQL Query to find the Site Content Types and Columns
SharePoint – SQL Query to find the Site Content Types and Columns

SQL Queries to find the Site Content Types and Site Columns

When you know the Content Database in question, then use the following SQL queries.

1. Query to Find the Site Content Types
select * from WSS_Content_BusinessDept.dbo.ContentTypes
where Scope = ‘sites/department/subsite’ 
and
IsFromFeature = 1
–ResourceDir like ‘Email Submission’
–ContentTypeId like ‘0x010100672A3FCA98991645BE083C320B7539B7’
–ResourceDir like ‘Translation Document’
–ContentTypeId like ‘0x010100E4FE8612EC394E3690F102C0A1A07563’

2. Query to delete the Site content Types (Remove /* and */ from the query statement for novice users, others know it. You might have to update the where clauses for your environment. Read the below statement in blue, Its Punjabi 🙂 Make sure you know the SQL, knowing Punjabi, leave it for some other time. It’s complex)
/*delete from WSS_Content_MainStreet_BusinessSolutions.dbo.ContentTypes
where Scope = ‘sites/businesssolutions/alignedsolutions’ 
and
IsFromFeature = 1
and
ResourceDir like ‘Email Submission’
*/

??????   ??  ????? ??? ? ?????  ?? ???  ??  ????  ?? ?? ???? ???  ??? ??  ???? ?? ?

3. Query to find the Site Columns for a sub-site
— Find the site columns that are causing issue
SELECT * FROM WSS_Content_MainStreet_BusinessSolutions.dbo.ContentTypes
 WHERE 
 Scope = ‘sites/businesssolutions/alignedsolutions’ and
 Definition LIKE (‘%bcc%’)

4. Query to delete the Site Columns for a sub-site
 /*
 –Delete the site columns that are causing issue
Delete FROM WSS_Content_MainStreet_BusinessSolutions.dbo.ContentTypes
 WHERE 
 Scope = ‘sites/businesssolutions/alignedsolutions’ and
 Definition LIKE (‘%bcc%’)
 */

Make sure you delete one data row and then review the SharePoint Content Types / Site Columns from the gui. Afer confirming the objects are not showing up in the site, then delete other objects causing errors. I first deleted only E-mail Submission duplicate Site Content Types. Test content Types creation and got duplicate content type error for a different content type. It was Translation Document content type. It was not showing up in GUI but deleting it from the same content database table resolved the issue.

Error 
A duplicate content type “0x010100E4FE8612EC394E3690F102C0A1A07563” was found. 
Troubleshoot issues with Microsoft SharePoint Foundation. 
Correlation ID: 70cbffd1-99f4-445c-bd9b-4c8df34ad9d2 
Date and Time: 9/11/2014 2:16:55 PM  

At the end I created coupe of test Site Content Types and Site Columns and I was able create those without the error.

SharePoint Site Content Type created without error
SharePoint Site Content Type created without error

References:
1. List of All Default SharePoint 2010 Content Types
http://blogs.msmvps.com/ivansanders/list-of-all-default-sharepoint-2010-content-types/

2. Content Type Hub | Duplicate Content Type Error “A content type with the name already exists”

http://blogs.msdn.com/b/varun_malhotra/archive/2012/01/17/content-type-hub-duplicate-content-type-error-quot-a-content-type-with-the-name-already-exists-quot.aspx

3. A Duplicate Content Type Found Error

https://social.technet.microsoft.com/Forums/ie/en-US/5e30ade2-93b0-4f5c-8acd-25b73946500c/content-type-creation-problem-a-duplicate-content-type-was-found?forum=sharepointgeneralprevious

4. Inherit Content Types



5. Content Types and Inheritance

http://social.technet.microsoft.com/Forums/office/en-US/ca7b97ee-6f03-4beb-b7b8-7aa20227ac6e/content-types-and-inheritance?forum=sharepointdevelopmentprevious

6. Deleting content Types in Sharepoint 2007: A troubleshoot

http://blog.tylerholmes.com/2008/02/deleting-content-types-in-sharepoint.html

7. A duplicate name was found creating content type

http://social.technet.microsoft.com/Forums/sharepoint/en-US/afd9b718-6da9-4042-9dcb-a6fafa9fe77b/a-duplicate-name-was-found-creating-content-type?forum=sharepointadminlegacy

8. The Content Type Is In Use – SharePoint 2010 Error Redux

http://nickhadlee.wordpress.com/2010/05/24/the-content-type-is-in-use-sharepoint-2010-error-redux/

9. Can’t remove a site column from a content type or list in SharePoint? Use PowerShell

http://get-spscripts.com/2010/10/cant-remove-site-column-from-content.html

10. “I cannot delete this column from my list??” – Well that must be a SharePoint 2010 Peristent column

http://sharepointinsimple.blogspot.com/2012/05/i-cannot-delete-this-column-from-my.html

11. Corrupt site column cannot be deleted

http://blog.sharepointsite.co.uk/2011/05/corrupt-site-column-cannot-be-deleted.html

12. Persistent SharePoint 2010 Site Columns

http://blog.metrostarsystems.com/2011/05/11/persistent-sharepoint-2010-site-columns/

Keywords:

  • How to delete duplicate Site Content Type
  • Deleting duplicate Site Content Type
  • How to remove duplicate Site Content Type
  • Site Content Type Setting section is empty
  • Site Content Type Setting section is blank
  • Site Content Type Setting section is missing
  • Primer on Content Types
  • Primer on Site Content Types
  • Primer on Sharepoint Content Types
  • Primer on Site Columns
  • Corrupt Content Type
  • Content Organizer
  • Enterprise Content Management
  • ECM
  • Information Architecture

Ten effective Sharepoint ProjectServer training resources

Wednesday, September 10th, 2014
Question:
What are really effective end user training resources?

Answer:
Role based training containing real world examples are the most effective and keep the users engaged. SharePoint 2010 User Adoption training videos from Microsoft were short, precise and extremely good for business users.

Video training are also effective. Having videos in LMS is bonus plus. I’ve effectively used the following training formats for my customers:

  1. Small 2-3 minutes structured personalized on-demand videos that you can host within SharePoint or on a streaming media server. Use Jing, Microsoft Expression Encoder, Camtasia Studio, Articulate or similar resources to record, edit, create, encode and publish contents
  2. Creating a SharePoint site collection just for training where users can practice 
  3. Use step by step word / PDF guide divided into chapters that users can download and print. Make training contents relevant to the training site collection is most valuable
  4. Using WebEx to deliver live or on-demand training and also use Webex LMS with user registration
  5. Using LMS format training
  6. Conducting pre-training and post-training surveys to measure the trainee’s skillset, performance and training effectiveness.
  7. Structuring training based on roles is best. That was users increase their knowledge level and will be motivated to move to next role training
  8. Create a FAQ Blog under the training site collection where cover weekly / monthly posts on new topics, most frequent problem and other hot pressing issues.
  9. Tie your ticket support system with the SharePoint knowledge base within the training site collection. Don’t just fix or resolve issues, but document and create knowledge base that will go with you for long
  10. Please contact my company Softvative Inc for your Sharepoint, Project Server EPM / PPM and PMO training needs.
Keywords:
  • SharePoint end user training resources
  • SharePoint role based training resources
  • SharePoint best training resources
  • SharePoint video training resources
  • SharePoint LMS training resources
  • SharePoint training guides
  • SharePoint document based training
  • SharePoint On-Premises training
  • SharePoint Office 365 training
  • Best Sharepoint training in Minnesota
  • Best Sharepoint training MN
  • Best Sharepoint training in Midwest
  • SharePoint training in Minnesota
  • Office 365 SharePoint training
  • SharePoint Online training
  • ProjectServer end user training resources
  • ProjectServer role based training resources
  • ProjectServer best training resources
  • ProjectServer video training resources
  • ProjectServer LMS training resources
  • ProjectServer training guides
  • ProjectServer document based training
  • ProjectServer EPM training
  • ProjectServer MSPS training
  • MSProjectServer training
  • ProjectServer video training
  • ProjectServer role based training
  • ProjectServer training in Minnesota
  • Best ProjectServer training in Minnesota
  • Best ProjectServer training in MN
  • Best ProjectServer training in Midwest