Archive for August, 2011

SharePoint 2010 – Database is up to date, but some sites are not completely upgraded

August 16, 2011 Leave a comment

I was updating my current SharePoint 2010 farm with the latest and greatest SharePoint Server 2010 SP1 update and after applying the update and attempting to run the SharePoint 2010 Products Configurations Wizard to complete the installation the wizard was failing on Step 9 of the process.  After trying to run the wizard again I was able to successfully complete the wizard with no errors.

However, as I was looking at Central Administration I noticed the SharePoint Health Analyzer was detecting some errors.  Checking the issues I noticed that their were errors in Configuration, so I clicked on the Update and Migration link to the left and clicked on the Review database status link under Upgrade and Patch Management.

I noticed that the Content Database status was set to ‘Database is up to date, but some sites are not completely upgraded’

That told me that even though the SP1 applied  the database was not completely upgraded.

If you ever run into this message or problem, this is what I did to fix the issue.

1.  Log into your Central Administration Server
2.  Bring up SharePoint 2010 Management Shell (PowerShell)
3.  Type Get-SPContentDatabase -Identity [name of database]
4.  This will list the GUID (ID) of the database that needs to be upgraded.
5.  Right click inside PowerShell select Mark
6.  Highlight the database GUID (ID) and right click (this will save the ID in the clipboard)
7.  Next type
upgrade-spcontentdatabase -id [GUID] (right click and paste the ID you copied from Step 6)
8.  Hit Enter
9.  You will then be prompted to confirm:

Are you sure you want to perform this action?
Performing operation “Upgrade-SPContentDatabase” on Target Database GUID
[Y] Yes [A]Yes to All [N] No [L] No to All [S] Suspend [?] Help
<default is “Y”>:

Type: Y at this stage and hit enter.

10.  You will see the progress of completion percentage increase.
11.  Once it reaches 100% its complete and you can now close out of PowerShell.
12.  Go back to Central Administration -> Manage Database Update Status and refresh the page.
13.  You should now see the database status set to No Action required.

Creating different views for SharePoint 2007 Surveys

August 2, 2011 Leave a comment

The one thing I dislike about MOSS 2007 Surveys is inability to create different views within the survey list settings itself.  Not sure why this was not included like other lists.  A simple create view from the settings option would have been nice, however its not there so I had to turn to other means of doing this.

I was tasked to create different views for MOSS 2007  survey so that the data can be separated by a specific category instead of having all the data reside in one view.

For me to accomplish this I had to use SharePoint Designer 2007.

1.  Using SharePoint Designer, open up the site that  has the SharePoint Survey List.
2.  Expand the List directoy(tree) and select the name of the Survey created within SharePoint.
3.  Expand the Survey directory(tree) and select the AllItems.aspx page.
4.  Right click and select copy.
5.  Click and highlight the name of the Survey directory (top of  the tree) again and right click and select paste.
6.  This will paste a copy of the AllItems.aspx page inside the Survey directory.
7.  Right click and rename the copy of the AllItems.aspx page to a different name, perferabley to a name of the new view.
8.   Go back to the SharePoint site that has the Survey List and navigate to the overview page.
9.   Click the drop down next to View on the right: and you will see a second entry for All Responses.
10.  Select the second occurance of the All Responses to change to that view.
11.  Next select Site Actions -> Edit Page
12.  The click Edit -> Modified Shared Web Part for the All Responses view webpart
13.  In the List View, click the Edit Current View link under selected view.
14.  As you can see the web address for the view is the name you gave it when you created it within SharePoint Designer.
15.  Now just change the View Name, select what columns you want to show, and make your sorts, filters, etc.
16.  Click Ok

Now when you go back to the Overview page for the Survey, and you select the drop down next to view you will see the name of the new View, clicking on it will take you to that view page with your view options.