My Oracle Support Banner

Search Business Interaction With Custom Char of the Business Interaction and a Custom Char of the Activity at the Same Time Receives Error: “An error occurred while searching for business interactions” (Doc ID 2846943.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle Communications Unified Inventory Management - Version 7.4.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Problem when try to search a Business Interaction from a custom char of the Business Interaction and a custom char of the Activity at the same time.

 

The following error found in the UIM log:

2022-02-03 09:49:03,259 ERROR [uimuser] [[ACTIVE] ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'] [BusinessInteractionManager] [INV-270006] An error occurred while searching for business interactions.
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Problem compiling [SELECT o FROM BusinessInteraction o JOIN o.characteristics chars0var JOIN o.activities act JOIN act.characteristics chars0var WHERE (chars0var.name = :pCharName0Param AND    UPPER(chars0var.value) LIKE :pCharValue0Param  escape '\' ) AND ( (chars0var.name = :pCharName0Param2 AND    UPPER(chars0var.value) LIKE :pCharValue0Param2  escape '\' ) ) AND o.entityClass = 'BusinessInteractionDAO' AND Type(o) = BusinessInteraction ].
[59, 68] The identification variable 'chars0var' cannot be declared more than once.
[116, 125] The identification variable 'chars0var' cannot be declared more than once.
    at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1616) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at sun.reflect.GeneratedMethodAccessor761.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_241]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_241]
    at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:97) ~[com.oracle.weblogic.persistence.jar:12.2.1.4]
    at weblogic.persistence.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:164) ~[com.oracle.weblogic.persistence.jar:12.2.1.4]
    at weblogic.persistence.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:86) ~[com.oracle.weblogic.persistence.jar:12.2.1.4]
    at com.sun.proxy.$Proxy341.createQuery(Unknown Source) ~[?:?]
    at oracle.communications.inventory.api.framework.persistence.impl.InventoryFinderImpl.findTotalCounts(InventoryFinderImpl.java:339) ~[uim-api-framework.jar:?]
    at oracle.communications.inventory.api.common.BaseInvManager.findMatches(BaseInvManager.java:1518) ~[uim-managers.jar:?]
    at oracle.communications.inventory.api.businessinteraction.impl.BusinessInteractionManagerImpl.findBusinessInteraction(BusinessInteractionManagerImpl.java:1202) [uim-managers.jar:?]
    .
    .
    .
Caused by: org.eclipse.persistence.exceptions.JPQLException:
Exception Description: Problem compiling [SELECT o FROM BusinessInteraction o JOIN o.characteristics chars0var JOIN o.activities act JOIN act.characteristics chars0var WHERE (chars0var.name = :pCharName0Param AND    UPPER(chars0var.value) LIKE :pCharValue0Param  escape '\' ) AND ( (chars0var.name = :pCharName0Param2 AND    UPPER(chars0var.value) LIKE :pCharValue0Param2  escape '\' ) ) AND o.entityClass = 'BusinessInteractionDAO' AND Type(o) = BusinessInteraction ].
[59, 68] The identification variable 'chars0var' cannot be declared more than once.
[116, 125] The identification variable 'chars0var' cannot be declared more than once.
    at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildException(HermesParser.java:155) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.jpql.HermesParser.validate(HermesParser.java:347) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQueryImp(HermesParser.java:278) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuery(HermesParser.java:163) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:142) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:116) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:102) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:86) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1614) ~[eclipselink.jar:2.6.7.v20190604-418f1a1c56]
    ... 133 more

 

 

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


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