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

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

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[[
intradoc.data.DataException: !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
1"."DDOCNAME") to NULL

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

Changes

System may have just been upgraded between 11g versions.

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