Violation of Primary Key Constraint Error

Author: Joyce Zhou

Symptom

When a user posts in Apps, an error message pops up stating: "Violation of PRIMARY KEY constraint."

Resolution

This issue is related to a bug with SQL Server. You'll need to manually reset the identity column for the table with the issue.

1. Open SQL Server Management Studio (SSMS).

2. Use the following query to check the current identity value of the fact table stated in the message.

DBCC CHECKIDENT('TableName')

3. Set the identity value to a number that is greater than the current value.

DBCC CHECKIDENT('TableName', RESEED, NewValue)

In order to mitigate this issue going forward, apply the latest Cumulative Update to your SQL server.