ERROR When ENTITYSEARCH with char - ' in Values with Char Extension Framework
(Doc ID 2654478.1)
Last updated on APRIL 27, 2021
Applies to:
Oracle Communications Unified Inventory Management - Version 7.4.0.0.0 and laterInformation 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 |