UIM Equipment Treeview Search Error (Doc ID 2847057.1)

Last updated on OCTOBER 09, 2022

Applies to:

Symptoms

The error occurred when trying to search from on "Associate Equipment" Search window:

java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [SELECT o FROM Equipment o WHERE AND o.specification.name IN :holderRelsParam AND o.specification = :specParam 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) ORDER BY o.id ASC].
[32, 32] The left expression is missing from the logical expression.
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1616)
at sun.reflect.GeneratedMethodAccessor942.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:97)
at weblogic.persistence.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:164)
at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:86)
at com.sun.proxy.$Proxy1227.createQuery(Unknown Source)
at oracle.communications.platform.persistence.impl.FinderBean.findMatches(FinderBean.java:423)
at oracle.communications.inventory.api.common.BaseInvManager.findMatches(BaseInvManager.java:1567)
at oracle.communications.inventory.api.equipment.impl.EquipmentRetriever.processFindEquipment(EquipmentRetriever.java:550)
at oracle.communications.inventory.api.equipment.impl.EquipmentRetriever.findEquipment(EquipmentRetriever.java:247)
at oracle.communications.inventory.api.equipment.impl.EquipmentManagerImpl.findEquipment(EquipmentManagerImpl.java:132)
... 450 more
Caused by: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.5.v20201109-7e11866): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [SELECT o FROM Equipment o WHERE AND o.specification.name IN :holderRelsParam AND o.specification = :specParam 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) ORDER BY o.id ASC].
[32, 32] The left expression is missing from the logical expression.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.