My Oracle Support Banner

Receive an ORA-01407 Error when Performing an Index Rebuild After Upgrading WebCenter Content (Doc ID 1510738.1)

Last updated on DECEMBER 18, 2023

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


After performing an upgrade of WebCenter Content 11g, the system alerts you that "Index Collection needs to be synchronized, a full collection rebuild is required. Please rebuild the index collection."

On performing a rebuild, it runs for a period of time, and then stops, reporting one or more of the following errors in the log:

An error occurred during indexing.

general exception[[ !csDbUnableToExecuteSql,UPDATE IdcText1 SET dDocCreator = (SELECT dDocCreator FROM RevClasses WHERE IdcText
1.dDocName = RevClasses.dDocName)\,dDocAuthor = (SELECT dDocAuthor FROM Revisions WHERE IdcText1.dID = Revisions.dID)\,dDocName = (SELEC
T dDocName FROM Revisions WHERE IdcText1.dID = Revisions.dID)\,dDocOwner = (SELECT dDocOwner FROM RevClasses WHERE IdcText1.dDocName = R
evClasses.dDocName)\,xRelatedContentList = (SELECT xRelatedContentList FROM DocMeta WHERE IdcText1.dID = DocMeta.dID)\,dDocLastModifier
= (SELECT dDocLastModifier FROM RevClasses WHERE IdcText1.dDocName = RevClasses.dDocName)!$ORA-01407: cannot update ("UCMP_OCS"."IDCTEXT

Caused by: java.sql.SQLException: ORA-01407: cannot update ("UCMP_OCS"."IDCTEXT1"."DDOCNAME") to NULL


System may have just been upgraded between 11g versions.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.