My Oracle Support Banner

In UCM 10g, with CS10gr35CoreUpdate Build 115, and MS SQL Database: Underscores In "matches" Search Criteria Fail with an Exra Space in the Search Query (Doc ID 1563637.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 to 10.1.3.7.0 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

On : 10.1.3.5.0 version, Content Server

ACTUAL BEHAVIOR
---------------
When performing a 'matches' search in a non-indexed custom metadata field, items with an underscore character (_) do not return after having installed CS10gr3CoreUpdate Bundle build 115, even though the items can be found in repository manager.

EXPECTED BEHAVIOR
-----------------------
It is expected that the matches search pulls back matching content items in fields whether or not they have an underscore character in them or not.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Point your browser at a vanilla 10g content server running Build-115 with database full-text indexing.
* Check in a document with the value "with_some_underscores" in its xComments non-indexed field.
* Check in a document with the value "hasNoUnderscores" in its xComments non-indexed field.
* Point a browser at this content server's "standard search" form.
* Run a "matches" search in xComments for "hasNoUnderscores". This item is found in the content server.
* Run a "matches" search in xComments for "with_some_underscores". This item is not found in the content server.
* Open up the RepositoryMananager applet and filter xComments for "with_some_underscores". RepoMan on the content server can find this item.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search as they have in the past

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


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.