UIM: Error When Conducting Entity Search Based on a Numeric Characteristic in UI (Doc ID 1639935.1)

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