Agile SDK IQuery Execution for Attributes Containing Dot Ends in "Attribute "XXXX.XXX.XXX" Not found." Error (Doc ID 2289912.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.3.0 to 9.3.4.0 [Release 9.3]
Information in this document applies to any platform.

Symptoms

Actual Behavior
Agile SDK IQuery execution for attributes containing dot ends in below error.

Error

com.agile.util.exception.CMAppException: Attribute "Manufacturers.Mfr.Name" not found.
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:464)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:272)
at com.agile.apibean.APISessionBean_id91a6_EOImpl_1211_WLStub.setCriteria(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.agile.api.pc.EJBRemoteProxy$1.invoke(EJBRemoteProxy.java:40)
at com.sun.proxy.$Proxy2.setCriteria(Unknown Source)
at com.agile.api.pc.query.Query$SetCriteriaAction.doSdkAction(Query.java:1276)
at com.agile.api.common.SDKAction.run(SDKAction.java:23)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.security.Security.runAs(Security.java:61)
at com.agile.api.common.WebLogicAuthenticator.doAs(WebLogicAuthenticator.java:111)
at com.agile.api.common.Security.doAs(Security.java:54)
at com.agile.api.common.Security.doAs(Security.java:109)
at com.agile.api.pc.query.Query.setCriteria(Query.java:335)
at com.agile.api.pc.query.Query.setCriteria(Query.java:318)
at com.agile.events.Decl.main(Decl.java:24)
com.agile.util.exception.CMAppException: Attribute "Manufacturers.Mfr.Name" not found.
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:464)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:272)
at com.agile.apibean.APISessionBean_id91a6_EOImpl_1211_WLStub.setCriteria(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.agile.api.pc.EJBRemoteProxy$1.invoke(EJBRemoteProxy.java:40)
at com.sun.proxy.$Proxy2.setCriteria(Unknown Source)
at com.agile.api.pc.query.Query$SetCriteriaAction.doSdkAction(Query.java:1276)
at com.agile.api.common.SDKAction.run(SDKAction.java:23)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.security.Security.runAs(Security.java:61)
at com.agile.api.common.WebLogicAuthenticator.doAs(WebLogicAuthenticator.java:111)
at com.agile.api.common.Security.doAs(Security.java:54)
at com.agile.api.common.Security.doAs(Security.java:109)
at com.agile.api.pc.query.Query.setCriteria(Query.java:335)
at com.agile.api.pc.query.Query.setCriteria(Query.java:318)
at com.agile.events.Decl.main(Decl.java:24)
Error code : 60029
Error message : Attribute "Manufacturers.Mfr.Name" not found.
Root Cause exception : com.agile.util.exception.CMAppException: Attribute "Manufacturers.Mfr.Name" not found.

at com.agile.api.pc.APIObject.createError(APIObject.java:131)
at com.agile.api.pc.query.Query.access$4300(Query.java:70)
at com.agile.api.pc.query.Query$SetCriteriaAction.doSdkAction(Query.java:1287)
at com.agile.api.common.SDKAction.run(SDKAction.java:23)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.security.Security.runAs(Security.java:61)
at com.agile.api.common.WebLogicAuthenticator.doAs(WebLogicAuthenticator.java:111)
at com.agile.api.common.Security.doAs(Security.java:54)
at com.agile.api.common.Security.doAs(Security.java:109)
at com.agile.api.pc.query.Query.setCriteria(Query.java:335)
at com.agile.api.pc.query.Query.setCriteria(Query.java:318)
at com.agile.events.Decl.main(Decl.java:24)


Steps
The issue can be reproduced at will with the following steps:
1. Execute Agile SDK code including below IQuery execution for attributes containing dot.

 

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