Last updated on APRIL 09, 2014
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
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