Project Server 2010 : PWA Errors and Trouble-shooting

While I was refreshing DEV environment from PROD for Project Server, I ran into many issues.

The following article explained the solution for various of the issues:

MS Project Server 2010 -> PWA Errors & Troubleshooting

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.