Receive an ORA-01407 Error when Performing an Index Rebuild After Upgrading WebCenter Content
Last updated on NOVEMBER 03, 2016
Applies to:Oracle WebCenter Content - Version 18.104.22.168.0 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:
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
System may have just been upgraded between 11g versions.
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