Unable to Check-in Documents due to Unique Constraint Error (Doc ID 1458046.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Content - Version 6.2.0 to 10.1.4.5.0 [Release Stellent to 10gR3]
Information in this document applies to any platform.

Symptoms

Issue
---------
Users cannot check-in documents. This includes uploading new documents, or uploading revisions of existing documents. The error both in the browser and occurs in the logs/system audit is 'Violation of PRIMARY KEY constraint 'PK___3__10'. Cannot insert duplicate key in object 'dbo.Documents'.'


Steps to Reproduce
-------------------------
1. Check-in document from Content Server web interface


Workaround
---------------
None


Impact on Business
--------------------------
Policy Managers cannot upload new policy nor upload revisions for statewide public and internal use.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms