My Oracle Support Banner

Applying Public Patch Set Update (PSU) 10.3.1.0.2 Causes OR Operation in Universal Content Management (UCM) Search Query to Fail with com.bea.content.RepositoryException (Doc ID 1061091.1)

Last updated on JUNE 08, 2020

Applies to:

Oracle WebLogic Portal - Version 10.3.1.0.2 to 10.3.1.0.2 [Release AS10gR3]
Information in this document applies to any platform.

Symptoms

After installing the public Patch Set Update (PSU) patch ZKHC on top of WLP 10.3.1.0.1 the OR operator ( || ) in the Universal Content Management (UCM) search query may cause the RepositoryException given below.  The same search query with the OR operator worked fine before applying the patch.

Error message:

[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR util.CMSUtil - Error occured while retrieving the data from UCM for searchQuery [dDocType='Document Type' && xTP_SMType in ('<VALUE1>','<VALUE2>','<VALUE3>','<VALUE4>','<VALUE5>') && (xTP_CIDN like'<NUMBER1>' || xTP_CIDN like'<NUMBER2>' || xTP_CIDN like'<NUMBER3>' || xTP_CIDN like'<NUMBER4>' || xTP_CIDN like'<NUMBER5>' || xTP_CIDN like'<NUMBER6>' || xTP_CIDN like'<NUMBER7.')]
03 Feb 2010 18:56:00,708 [ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR exception.TPSystemException - CmsError
com.bea.content.RepositoryException: Only the AND operator can be used with the cm_objectClass parameter
at com.oracle.content.spi.ucm.search.FolderExpressionTranslator.validateBranchOperator(FolderExpressionTranslator.java:92)
at com.oracle.content.spi.ucm.search.BaseExpressionTranslator.translateLeaf(BaseExpressionTranslator.java:293)
at com.oracle.content.spi.ucm.search.BaseExpressionTranslator.translateBranch(BaseExpressionTranslator.java:164)
at com.oracle.content.spi.ucm.search.BaseExpressionTranslator.translateBranch(BaseExpressionTranslator.java:213)
at com.oracle.content.spi.ucm.search.BaseExpressionTranslator.translateExpression(BaseExpressionTranslator.java:270)
at com.oracle.content.spi.ucm.search.FolderSearchExecutor.buildSearchCommand(FolderSearchExecutor.java:54)
at com.oracle.content.spi.ucm.search.MixedTypeExecutor.buildSearchCommand(MixedTypeExecutor.java:81)
at com.oracle.content.spi.ucm.search.SearchTranslator.expressionSearch(SearchTranslator.java:206)
at com.oracle.content.spi.ucm.search.SearchTranslator.search(SearchTranslator.java:169)
at com.oracle.content.spi.ucm.search.SearchOps.nodeSearch(SearchOps.java:108)
at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
.....
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Below is a sample search query using the OR operator:

dDocType='Document Type' && xTP_SMType in ('<VALUE1>','<VALUE2>','<VALUE3>','<VALUE4>','<VALUE5>') && (xTP_CIDN like'<NUMBER1>' || xTP_CIDN like'<NUMBER2>' || xTP_CIDN like'<NUMBER3>' || xTP_CIDN like'<NUMBER4>' || xTP_CIDN like'<NUMBER5>' || xTP_CIDN like'<NUMBER6>' || xTP_CIDN like'<NUMBER7>')

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
References


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