"Cannot insert duplicate key in object 'Revisions'" Error When Attempting to Check In a Content Item (Doc ID 449430.1)

Last updated on MAY 19, 2017

Applies to:

Oracle WebCenter Content - Version: 6.0 and later   [Release: Stellent and later ]
Information in this document applies to any platform.
Product: Content Server
Version: 6.0

Symptoms

When attempting to check in a content item into the Content Server, the check-in fails with the following error:

Content Server Request Failed
Unable to execute service CHECKIN_NEW and function Irevision.
(System Error: Unable to execute query 'Irevision(INSERT INTO Revisions (dID, dDocName, dDocType, dDocTitle, dDocAuthor,
dRevClassID, dRevisionID, dRevLabel, dIsCheckedOut, dDocAccount, dSecurityGroup,
dCreateDate, dInDate, dOutDate, dStatus, dReleaseState,
dPublishType, dPublishState, dWorkflowState)
values(433953, '386743', 'JFS-Construction', 'test', 'sysadmin', 386743, 1, '1', 0, '', 'FL_Group1', {ts '2006-11-08 16:07:49.967'}, {ts '2006-11-08 16:07:00.000'}, null, 'GENWWW', 'N', '', '', ''))'. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'PK___7__10'. Cannot insert duplicate key in object 'Revisions'.)

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