One instance of this occurs when there are two of the same rendering states for a Derivative Id in dbo.Derivatives of a Customer DB. You have to find the duplicate in dbo.derivatives and then Engineering has to delete duplicate. Below query example replace Customer and x's:
DELETE TOP (1)
FROM [PPCustomer].[dbo].[DerivativeRenderingStates]
WHERE AssetId = xxxx AND DerivativeDefinitionId = xx AND RenderingStateId = x