My Oracle Support Banner

Unable to Search After Upgrade from 10g to 11.1.1.8, error with column XDONTSHOWINLISTSFORWEBSITES (Doc ID 2042541.1)

Last updated on JUNE 07, 2018

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 to 11.1.1.8.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.0 version, Content Server

After upgrading from UCM 10g to 11.1.1.8 the search is not working with the search engine: DATABASE.METADATA
The following error occurs.

ERROR
-----------------------

services/3 08.06 15:16:06.224 IdcServer-1153 Caused by: intradoc.data.DataException: !csDbUnableToExecuteQuery,UdsDocMetaDataDocMeta(UPDATE/*+ INDEX (DocMeta PK_DocMeta)*/ DocMeta SET dID = 1234567\,xComments = 'Test metadata update'\,xCollectionID = 0\,xHidden = 'FALSE'\,xReadOnly = 'FALSE'\,xInhibitUpdate = 'FALSE'\,xTrashDeleter = ''\,xTrashDeleteName = ''\,xTrashDeleteLoc = 0\,xTrashDeleteDate = null\,xTemplateType = ''\,xWebsiteObjectType = 'Data File'\,xUseCD = ''\,xWebsites = '12'\,xDontShowInListsForWebsites = ''\,xWebsiteSection = '12:1234'\,xComplianceReview = 'No'\,xJLComplianceReview = ''\,xProfileTrigger = ''\,xSystem = ''\,xContentCategory = ''\,xCountry = 'US'\,xEmailFrom = ''\,xEmailTo = ''\,xEmailCC = ''\,xEmailSubject = ''\,xPublicationDate = null\,xReceivedDate = null\,xLinkLabel = ''\,xDeletionDate = null\,xPublishDate = null\,xNextReviewDate = null\,xLanguage = 'English'\,xSearchable = 'Yes'\,xPrintable = 'Yes'\,xContentOwner = ''\,xCacheable = ''\,xTeamsiteURL = ''\,xWorkflowID = ''\,xNewsCatCD = ''\,xNewsGICSCD = ''\,xNewsSymListTxt = ''\,xRegionDefinition = ''\,xExternalDataSet = ''\,xIdcProfile = ''\,xPartitionId = ''\,xWebFlag = ''\,xStorageRule = 'default' WHERE dID = 1234567)!$ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
services/3 08.06 15:16:06.224 IdcServer-3278 ORA-20000: Oracle Text error:
services/3 08.06 15:16:06.224 IdcServer-3278 DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
services/3 08.06 15:16:06.224 IdcServer-3278 ORA-20000: Oracle Text error:
services/3 08.06 15:16:06.224 IdcServer-3278 DRG-10602: failed to queue DML change to column XDONTSHOWINLISTSFORWEBSITES for primary key AAAWaAABCAAAAU7AAc
services/3 08.06 15:16:06.224 IdcServer-3278 DRG-50857: oracle error in drekqkd(execute k_stmt)
services/3 08.06 15:16:06.224 IdcServer-3278 ORA-00942: table or view does not exist
services/3 08.06 15:16:06.224 IdcServer-3278
services/3 08.06 15:16:06.224 IdcServer-3278 ORA-06512: at "CTXSYS.DRUE"\, line 160
services/3 08.06 15:16:06.224 IdcServer-3278 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS"\, line 793
services/3 08.06 15:16:06.224 IdcServer-3278
services/3 08.06 15:16:06.224 IdcServer-3278 at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Have the Components enabled: Site Studio, DBSearchContainsOpSupport
2. Upgrade a system from 10g to 11.1.1.8

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot search for content or update documents that are metadata only.

Cause

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.