9.3.3: Full Text Search Does Not Work After Applying Hotfixes (Doc ID 1952527.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.3.0 version, Searches

ACTUAL BEHAVIOR
-------------------------
FTS not working with 9.3.3 HF 30 AND HF 61

Example Error in CTX_USER_INDEX_ERRORS table: (1 error occurs for every indexable file)
DRG-11602: URL store: access to http://ag933testfm.name.com/Filemgr/DownloadServlet?FSbdg=%7BAES%3A128%7D12B30C8F298384BBF33C4

Error in File Manager Log: (1 error occurs for every indexable file)
An exception occurred while processing one of the input values, please contact the system admin for more details.
134807368 [http-bio-8080-exec-9] WARN IntrusionDetector - [SECURITY FAILURE Anonymous:null@unknown -> /ExampleApplication/IntrusionDetector] Invalid input: context=fileID, type(AgileMetaParameterValue)=^[a-zA-Z0-9.\-\/+=@_&;,(): ]*$, input={AES:128}541D22D95A4DBEC981C67461E10DF143BBA9
org.owasp.esapi.errors.ValidationException: fileID: Invalid input. Please conform to regex ^[a-zA-Z0-9.\-\/+=@_&;,(): ]*$
  at org.owasp.esapi.reference.validation.StringValidationRule.checkWhitelist(StringValidationRule.java:144)
  at org.owasp.esapi.reference.validation.StringValidationRule.checkWhitelist(StringValidationRule.java:160)

EXPECTED BEHAVIOR
---------------------------
Full text search function should be worked after applying HF

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applied HF 2, 3, 15, 30, 61 on PLM 9.3.3 server.
2. Found full text search function does not work


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search file attachment in PLM system

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