Tag Archives: SharePoint 2010

InfoPath 2013 Add Colour Coding to the Status of a Form

  • Edit your Form Library page.
  • Add a Content Editor web part to the page and move it below the form library.
  • Open the properties for the Content Editor web part and add the path to the StopLight.txt file. Make sure you upload this file to the Site Assets library in the same site where your form lives.
  • Set the Content Editor Appearance property to hidden and click OK to save the changes.
  • Add a new calculated field column to the Form Library and call it Overall Status (you can call it anything you like).
  • In the formula section add the following: StopLight Formula
  • Save the new column and return to the Form library.
  • Make any additional changes to the form library, for example set the Style to Newsletter to give it a neat professional look.

Download the StopLight.txt file here.

Any questions, let us know in the comments section below.

InfoPath 2013 Moving a Form from an Existing Form Library to a New Form Library

  • Create a document library to store the InfoPath form content type.
  • Publish the form as a content type to the site, save it in the new library created in step 1, then promote any new columns as site columns.
  • Create a new form library and add the new content type as the default.
  • Save a form from the old library by ‘downloading a copy’, then upload it to the new form library.
  • Relink this form in the new library.

It should open and function as normal.

Certified Solutions Australia - SharePoint 2013

Upgrade SharePoint 2010 My Sites to SharePoint 2013 My Sites

Upgrading My Sites from SharePoint 2010 to SharePoint 2013 can be a challenge and some of the information found on the Microsoft site can be a little misleading.

I have put together a few steps that worked for me. The process includes upgrading the Managed Metadata and User Profile Service Applications along with the My Sites content databases.

Disclaimer: This posting is provided “AS IS” with no warranties. Please carry out the tasks below in your Development environment first. I suggest using Hyper V to take a snapshot of your farm first including the SQL Server before carrying out the upgrade.

Microsoft links to refer to

Upgrade My Sites: http://technet.microsoft.com/en-us/library/dn479424.aspx
Upgrade Service Apps: http://technet.microsoft.com/en-us/library/jj839719.aspx

The upgrade process is as follows

Step 1: Copy and restore the following databases from SharePoint 2010 SQL Server to your SharePoint 2013 SQL Server.

– ProfileDB
– SocialDB
– SyncDB
– MetadataDB
– WSS_Content_MySites

The WSS_Content_MySites is the database that holds all the My Sites in my SharePoint 2010 environment. The project I was working on had their My Sites and SharePoint Sites all in the one database so I had to use the Move-SPSite powershell command to move the sites to a dedicated WSS_Content_MySites database for My sites.

Move-SPSite -DestinationDatabase WSS_Content_MySites

Next if you have a setup account you use to run your queries in your farm, make sure this account has DBOwner rights on the database. This account can be the FARM account or a Setup account like the one you used to run the SharePoint installation.

Step 2: Upgrade the Managed Metadata Service Application, but first delete the existing Managed Metadata Service Application and User Profile Service Application in your SharePoint 2013 environment (if it exists), but ensure that both the Managed Metadata Service and the User Profile Service (not synchronization service) are started on the Application Server.

I have a Service Application Pool that I use for most of my Service Applications. If you want to create a separate service application pools for the Managed Metadata Service Application, then please make changes to the commands below to suit your needs.

On your Application Server, log in with your Setup account, open a Powershell command window in Administrator mode and run the following commands:

Get-SPServiceApplicationPool |ft name

$applicationPool = Get-SPServiceApplicationPool -Identity 'Service Application Pool Account'

$mms = New-SPMetadataServiceApplication -Name 'Managed Metadata Service Application' -ApplicationPool $applicationPool -DatabaseName 'MetadataDB'

New-SPMetadataServiceApplicationProxy -Name ‘Managed Metadata Service Application’ -ServiceApplication $mms –DefaultProxyGroup

IISReset /noforce

The above Powershell commands will create a new Managed Metadata Service and upgrade the MetadataDB database.

Now, delete this new Managed Metadata Service Application by selecting it under Service Applicatons in Central Administration and clicking the Delete button at the top of the page. DO NOT check the box to delete the upgraded database. We need this so leave the database as is, only delete the service application.

After you have deleted the service application, re-create it, but this time via Central Administration and in the Database box, give it a database name like MetadataDBRemoveMe for example.

Once the service application is created, we need to change the database and make sure that it uses the upgraded database. So, run the powershell command below to do this:

Set-SPMetadataServiceApplication -Identity "Managed Metadata Service Application" -DatabaseName MetadataDB

Then run IISReset /NoForce

Possible error: “The managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator.”

Possible solution: Give the Service Application Pool Account DBOwner rights to the upgraded Metadata database in SQL Server. Also give the service application pool full control permissions to the Service Application in Central Administration.

Make sure there are no errors when you click the Managed Metadata Service Application under Service Applications in Central Administration. It is important that there are no errors, do not proceed to the next step if there are errors.

Step 3: Create a new My Site Web Application in Classic mode.

New-SPWebApplication -Name "MySite WebApp" -ApplicationPool "MySiteAppPool" -AuthenticationMethod "Kerberos" -ApplicationPoolAccount (Get-SPManagedAccount "Contoso\svc-sp2013DevAppPool") -Port 80 -URL "http://mysitesdevsp2013.contoso.com.au" -HostHeader "mysitesdevsp2013.contoso.com.au" -DatabaseName WSS_Content_MySitesRemoveMe

Do not create the My Site Host site collection after creating the Web Application above.

Create a new My Sites User Policy (See Technet documentation regarding creation My Sites for SharePoint 2013 for details)

Don’t try to configure Self-Service site creation as there is no root site collection.

Step 4: Create a new User Profile Service Application.

Run the following Powershell scripts in Administrator mode as you did above:

Get-SPServiceApplicationPool |ft name

$applicationPool = Get-SPServiceApplicationPool -Identity 'Service Application Pool Account'

$upa = New-SPProfileServiceApplication -Name 'User Profile Service Application' -ApplicationPool $applicationPool -ProfileDBName 'ProfileDB' -SocialDBName 'SocialDB' -ProfileSyncDBName 'SyncDB'

New-SPProfileServiceApplicationProxy -Name ‘User Profile Service Application’ -ServiceApplication $upa -DefaultProxyGroup

IISReset /noforce

Next, delete this newly created User Profile Service Application, but do not check the box to delete the database too. We need these upgraded databases so leave them intact.

Create a new User Profile Service Application but for the database names, enter the name for the upgraded databases instead.

Once the new User Profile Service Application is created, select it under Central Administration > Service Applications > click the Administrators tab and add the FARM account and Service Application Pool account.

Also add the FARM account to the local Administrators group on the Application server that will run the User Profile Synchronization Service.

Start the Synchronization service on the Application Server, it will ask you to enter the FARM account password, enter it and wait. This will take some time, it needs to start the ForeFront Identity Manager Service and ForeFront Identity Synchronization Service. So be patient, minimum 10 minutes.

Step 5: Once the Synchronisation Service starts successfully, you need to upgrade the My Sites web application by testing and mounting the restored database from SharePoint 2010. You then need to convert it to Claims authentication.

Make sure you have copied the My Sites Content database across to your new SQL Server and restored it. Ensure that the Setup account has DBOwner rights on the database.

Remove the default database from the My Sites Web Application via Central Administration first.

Then run the following Powershell command to test the restored database with the My Sites Web Application.

Test-SPContentDatabase -name WSS_Content_MySites -webapplication http://mysitesdevsp2013.contoso.com.au

Make sure there are no errors and that they do not block the upgrade of the database.

Then run a Mount-SPContent Database like below:

Mount-SPContentDatabase "WSS_Content_MySites" -WebApplication “http://mysitesdevsp2013.contoso.com.au”

The upgrade should complete successfully.

Next convert the My Sites Web Application to Claims by running the following command:

Convert-SPWebApplication -Identity "http://mysitesdevsp2013.contoso.com.au" -To Claims -RetainPermissions -Force

You now need to create the My Sites host for the My Sites Web Application. So, in Central Administration, create a new Site Collection for the My Sites Web Application and select the My Sites template under Enterprise. Also, make sure that you have selected the root of the web application – ‘/’.

Step 6:

Configure Staff profile photo by editing the Manage User Properties, select Picture and then edit, add a new mapping and select thumbnail photo

Under Central Administration > Service Applications > User Profile Service Application, click ‘Setup My Sites’ and add the My Site Host Location.

Start full profile sync and make sure it completes with no errors.

Once the user synchronization has finished, open the SharePoint 2013 Management Shell as the Farm account svc-SP2013DevFarm and run the following command

$mySitesUrl=”http://mysitesdevsp2013.contoso.com.au” (Enter)
$mySitesHost=Get-SPSite –Identity $mySitesUrl (Enter)
Update-SPProfilePhotoStore –MySiteHostLocation $mySitesHost –CreateThumbnailsForImportedPhotos $true (Enter)

This completes the upgrade of My Sites from SharePoint 2010 to SharePoint 2013. Go to your SharePoint 2013 site and click the Newsfeed link at the top of the page. This will start the process of provisioning a new My Site for your account. Once done, you should receive an email from your SharePoint Farm notifying you of the set up. You will then find all your old files on your SkyDrive page.

If you have any questions or need help with your upgrade, post a message below and I will be happy to assist.



CoolWriteups SharePoint 2010 Post

SharePoint 2010 – An error occurred during the “Generate Key” process. Please try again or contact your administrator


In SharePoint 2010, when you try to set up the Secure Store Service Application, one of the first steps is to generate a key. You open up the page under Central Administration > Application Management > Manage Service Applications > Secure Store Service to add a passphrase but see the error message “An error occurred during the “Generate Key” process. Please try again or contact your administrator”.

Looking at the ULS logs you may see this:

“7557 Critical The Secure Store Service application Secure Store Service is not accessible. The full exception text is: User does not have permission to perform the operation.”


This could be due to the user account that is logged in to the Central Administration page not having enough permissions to generate the key.

Try using the Farm account.

CoolWriteups SharePoint 2010 Post

SharePoint 2010 Services Stuck at Stopping or Starting

You log into Central Administration for SharePoint 2010 > System Settings > Services on Server and notice some of the services are stuck at ‘Starting’ or ‘Stopped’.

This could be due to the fact that SharePoint 2010 Administration Service (spadminv4) is not running on the Server. But when you try to start the service, it does not start in a timely fashion. To learn how to start the SPAdminV4 service follow this article: SharePoint 2010 Administration Service Not Starting

1. To solve the ‘Starting’ and ‘Stopping’, log into the server running Central Admin with the Farm account. Ensure the Farm account is a member of the Administrator’s group on the server you are logging in to;

2. Open a Powershell command window and Run as Administrator;

3. To get all the services running on a particular server, run the following command ‘Get-SPServiceInstance –Server ‘servername’. This will bring up a list of services running on the server like below.

4. To stop the service, enter the following command ‘Stop-SPServiceInstance’ and the GUID of the services from the screen above.

5. The status will now change from ‘Starting’ to ‘Stopping’. This will however not complete if the SharePoint 2010 Administration service is still not running. To stop it, run ‘Start-SPAdminJob’. Refer to this article for more info: http://technet.microsoft.com/en-us/library/ee513051%28v=office.14%29.aspx

6. Give it 10 seconds and the service should now be either ‘Stopped’.

7. The ‘Stop-SPServiceInstance’ command can be used to stop a Provisioned service too. A provisionsed service will have a status of ‘Starting’ or ‘Started’.

8. If the service status is ‘Unprovisionsed’, it means the service is ‘Stopped’ or ‘Stopping’.

9. To start a service, use ‘Start-SPServiceInstance’

That’s it.

CoolWriteups SharePoint 2010 Post

SharePoint 2010 – How To Install A Cummulative Patch

Installing a SharePoint 2010 cummulative patch can be tricky. To ensure everything goes smoothly, the following steps will help. Make sure you test this out in your DEV environment first.


1. Farm username and password;
2. Server names;
3. Downloaded patch/update for SharePoint Server 2010 or Foundation 2010;

Steps to install the patch/update:

1. Run the downloaded patch on all the servers in the farm individually starting first with the Application Server, then the Web Front End. The patch is usually an exe file;
2. Reboot the servers;
3. Log back into the Application server or the server that hosts Central Admin and open a Powershell window as an Administrator;
4. First check if an upgrade of the server is needed by entering this command ‘(get-spserver $env:computername).NeedsUpgrade‘. If one is required, enter the following command and run ‘PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures‘. Do this on all the servers in the farm that have SharePoint installed. This will ensure that all the servers in the SharePoint 2010 farm are upgraded and that they all have the same patch status
5. Once this is done, reboot all the servers one by one.
6. Open Services and check to make sure all the SharePoint services are running including SharePoint 2010 Administration. Also, ensure the Forefront services are running on the Application Server;
7. You may notice the databases are now running in compatibility range. To solve the issue run this Powershell command ‘Get-SPContentDatabase –Identity DatabaseName | Upgrade-SPContentDatabase‘. For a non-content database run this command ‘Get-SPDatabase –Identity DatabaseName | Upgrade-SPDatabase’.

That’s it.

CoolWriteups SharePoint 2010 Post

SharePoint 2010 Administration Service SPAdminv4 Not Starting

The SPAdminv4 service fails to start on a server running Windows Server 2008 after you have installed a SharePoint 2010 cummulative patch or are in the process of building a new server farm. This could be a problem on the Web Front End or the Application Server.

The fix is to add a new registry setting.

1. Click Run and enter ‘Regedit’;
2. In the Registry Window, navigate to ‘HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control’;
3. Right click and create a new DWORD Value option;
4. Replace ‘New Value #1’ with ‘ServicesPipeTimeout’;
5. Right click the new option and click Modify;
6. Enter 60000 as the value and exit the Registry.
7. Restart the server;

The SharePoint 2010 Administration service should now be running.