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