Project Server 2010 : Common errors when a PWA site is deleted ‘incorrectly’

From last few days, I was working multiple Project Server 2010 installations/migrations.

I ran into many issues and I came across the following blog post which helped me in resolving those issues.

Common errors when a PWA site is deleted ‘incorrectly’

Project Server 2010 : Migration or Restore in New Farm

Currently, I am working on Project Server 2010 restoring the PROD copy in DEV/TST environment.

As we know, there are 5 databases related to Project Server 2010 which we need to use for migration/restoring in new farm.

There are many approaches for this operation which are explained well in the following blog posts from Andrew:

Project Server 2010 Database Restore (Part I)

Project Server 2010 Database Restore (Part II)

PowerShell - "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered." or Microsoft SharePoint is not supported with version 4.0.30319.17929 of the Microsoft .Net Runtime

I ran into the following issues, when I open PowerShell management console for SharePoint:

a. The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered
b. Microsoft SharePoint is not supported with version 4.0.30319.17929 of the Microsoft .Net Runtime

The solution is mentioned in microsoft support post.  Click Here to see the post.

Solution:

To work around this issue, change the Target field value for SharePoint 2010 Management Shell. To do this, follow these steps:

• Click Start, and then right-click SharePoint 2010 Management Shell.
• Click Properties.
• Click the Shortcut tab in the SharePoint 2010 Management Shell Properties window.
• Input the following value in the Target field:

 C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Version 2.0 -NoExit " & ' C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\CONFIG\POWERSHELL\Registration\\sharepoint.ps1 ' "

Issues Uploading Large Files To SharePoint

At a client, I came across with an issue with uploading large files to SharePoint.

We have SharePoint servers in US and the user is located in Asian countries. When the user tries to upload large file, the SharePoint site's request is getting time-out message.

I am still trying to know more details but found a blog post which contains various methods/approaches to fix the issue.

Very nicely documented post (we may know some of them but good to see everything related are placed together)  :  Issues Uploading Large Files To SharePoint

SharePoint Config database Log file too big – reduce it!

Today, I wanted to refresh a content database in test environment from production environment.

In test environment, I see the d drive is almost full. Out of 200 GB, only 8 GB was left out.

There were 10 web applications and many service applications were configured in test environment.

I checked the SQL Server and found that transaction log file sizes became huge.

For SharePoint config database log, I see the transaction log file size as 36 GB.

Due to lack of space, I was not able to restore my content db from prod.

I started focusing on shrinking the transaction log files.

We need to ensure that transaction log file backup are taken before we start shrinking. As it is test environment, we don't need to worry about backup as it contains test data.

I was able to shrink all transaction log files for all the config databases and able to get around 60 GB free space.

Note: We can perform shrinking on databases or individual database files (.mdf & .ldf).

Reference article about how to shrink database or files

SharePoint 2010 - Workflow Articles

I have been using workflows in SharePoint from last 5 years in SP 2007/2010. 

I have developed custom visual studio workflows (sequential) and also used out of the box workflows & designer workflows.

Here are good collection of workflow articles, I prefer to read:

Article 1: Understand approval workflows in SharePoint 2010

Article 2: Step by Step : Creating Workflows for SharePoint 2010
Step 1   Step 2  Step 3  Step 4

Article 3:  Walkthrough: Create SharePoint 2010 Workflow Association Form and Initiation Form in Visual Studio 2010 by using Application Pages - Part 1 Part 2 Note: I will keep on adding articles to the above list as and when I find interesting article.

A Complete Guide to Writing Timer Jobs in SharePoint 2010

I wrote SharePoint time jobs many times in SP 2007 and SP 2010.

I read various articles on writing timer jobs.

The following article contains everything about writing timer jobs. 

A Complete Guide to Writing Timer Jobs in SharePoint 2010

https://www.simple-talk.com/dotnet/.net-tools/a-complete-guide-to-writing-timer-jobs-in-sharepoint-2010/

I recommend this article to new or experience timer job developers.

SharePoint 2010 Kerberos Configuration Guidence

For few clients, recently I configured Kerberos.

Kerberos always treated as hard component to configure due to various reasons such as trouble-shooting the issues, understanding the configuration for various services.

Guidence for Kerberos Configuration taken from the following document:

Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

http://www.microsoft.com/en-us/download/details.aspx?id=23176

Delegation tab in Active Directory User Console not available until a SPN is set

Recently, I configured Kerberos for SharePoint 2010.

As part of the configuration, I was trying to set values under delegation table for the user account.

I don't find the delegation tab for the user/service account.

Solution:  We have to set SPN for the user account. Then only, we will see delegation tab for the user account in Active Directory for Users.

Here are few blog posts referring to:
http://blogs.msdn.com/b/mattlind/archive/2010/01/14/delegation-tab-in-aduc-not-available-until-a-spn-is-set.aspx

http://social.technet.microsoft.com/Forums/en-US/winserverDS/thread/589e153f-f8a0-4aa2-a371-8e77ffa216dd/