UIM: Error When Conducting Entity Search Based on a Numeric Characteristic in UI
(Doc ID 1639935.1)
Last updated on SEPTEMBER 10, 2019
Applies to:
Oracle Communications Unified Inventory Management - Version 7.2.2 to 7.2.2 [Release 7.2]Information in this document applies to any platform.
Symptoms
Following error is thrown when a search is conducted based on the numeric characteristic in UI
An exception occurred while creating a query in EntityManager: Exception Description: Syntax error parsing the query [SELECT o FROM CustomNetworkAddress o JOIN o.characteristics chars0var WHERE o.specification = :specParam AND (chars0var.name = :pCharName0Param AND (chars0var.objectState = :pActiveStateParam0Param OR chars0var.objectState = :pQueuedStateParam0Param ) ANDFUNC('TO_NUMBER',FUNC('DECODE',FUNC('REGEXP_INSTR',chars0var.value,'^[-+]?[0-9]*[.]?[0-9]*$'),1,chars0var.value,NULL))= :pCharValue0Param) AND (o.objectState = oracle.communications.inventory.api.ObjectState.ACTIVE OR o.objectState = oracle.communications.inventory.api.ObjectState.INACTIVE)], line 1, column 252: syntax error at [ANDFUNC]. Internal Exception: MismatchedTokenException(80!=84)
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 |