SharePoint 2013: Get-SPProduct: Cannot insert duplicate key row

Problem

You are patching a SharePoint Server 2013 farm.  After installing the updates, you then execute Get-SPProduct -local on all machines. On one machine, executing this commandlet returns the error,

Get-SPProduct : Cannot insert duplicate key row in object 'dbo.ServerVersionInformation' with unique index 'IX_ServerVersionInformation_ServerID_product_PatchableUnit_PatchName'. The duplicate key value is...

Solution

• Re-execute the commandlet
  

  

References

• Get-SPProduct
• Software updates overview for SharePoint 2013
• The Magic of Get-SPProduct -Local: excellent background article on this commandlet.

Notes

• I have experienced this error a couple of times, both when executing Get-SPProduct concurrently on multiple SharePoint servers (a multi-server farm) and on just a single SharePoint server.  Each time, I was able to re-execute the commandlet without issue.