My Oracle Support Banner

ERROR When ENTITYSEARCH with char - ' in Values with Char Extension Framework (Doc ID 2654478.1)

Last updated on JUNE 28, 2020

Applies to:

Oracle Communications Unified Inventory Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On UIM with Characteristic Extension Framework enabled, on Entity Search screen search with Character value containing "'" (special character - ') is causing the Syntax Parsing Exception.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Enable Characteristic Extension framework by setting
UIMdomain/UIM/config/system-config.properties

inv.extendedCharSearchEnabledForAll=true
2) I searched Place Entity (Location) with custom char (text field) with some value with special character (') like
value "male'_u" error is thrown:


An exception occurred while creating a query in EntityManager: Exception Description: Syntax error parsing [SELECT o FROM DeviceInterface o ,TABLE('DEVICEINTERFACE_CHAR_EXT') DEVICEINTERFACE_CHAR_EXT WHERE o.entityId =
DEVICEINTERFACE_CHAR_EXT.charowner AND UPPER(DEVICEINTERFACE_CHAR_EXT."ParentDevice") LIKE 'MALE'\_U'@\_RS3%' escape '\' AND o.specification.entityClass = :specEntityClassParam
AND (o.objectState = oracle.communications.inventory.api.ObjectState.ACTIVE OR o.objectState = oracle.communications.inventory.api.ObjectState.INACTIVE OR o.objectState = oracle.communications.inventory.api.ObjectState.QUEUED)].
[99, 530] The expression is not a valid conditional expression.

 

Changes

 

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
Changes
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.