"com.agile.util.exception.CMClientException: ORA-00904: "C"."CHANGE_ID": invalid identifier" In Agile Product Lifecycle Management (PLM) System (Doc ID 2811345.1)

Last updated on SEPTEMBER 27, 2024

Applies to:

Symptoms

While using the Web Client in Agile PLM, and clicking on the Home button, the following error is seen in the browser:

The following error stack is seen in the stdout.log file on the application server:

<2021-09-27 14:59:16,470> <ActionServlet:ERROR> source exception
com.agile.util.exception.CMClientException: ORA-00904: "C"."CHANGE_ID": invalid identifier

at com.agile.util.exception.CMClientException.convertException(CMClientException.java:69) ~[agileclasses.jar:?]
at com.agile.ipa.pc.CMQuery.getUserWorkflowRoutings(CMQuery.java:1388) ~[agileclasses.jar:?]
at com.agile.ui.pcm.query.WorkflowRoutingDataModel.loadData(WorkflowRoutingDataModel.java:84) ~[agileclasses.jar:?]
at com.agile.ui.pcm.query.WorkflowRoutingDataModel.init(WorkflowRoutingDataModel.java:69) ~[agileclasses.jar:?]
at com.agile.ui.pcm.common.ObjectViewHandler.createDataModel(ObjectViewHandler.java:3531) ~[agileclasses.jar:?]
at com.agile.ui.pcm.query.InboxSearchHandler.showWorkflowRouting(InboxSearchHandler.java:786) ~[agileclasses.jar:?]
at com.agile.ui.pcm.query.InboxSearchHandler.showPreferredInbox(InboxSearchHandler.java:204) ~[agileclasses.jar:?]
at com.agile.ui.pcm.query.InboxSearchHandler.displayInboxView(InboxSearchHandler.java:170) ~[agileclasses.jar:?]
at sun.reflect.GeneratedMethodAccessor805.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
at com.agile.ui.web.action.ActionServlet.invokeMethod(ActionServlet.java:1198) ~[agileclasses.jar:?]
at com.agile.ui.web.action.ActionServlet.handleRequest(ActionServlet.java:802) [agileclasses.jar:?]
at com.agile.ui.web.action.ActionServlet.doPost(ActionServlet.java:433) [agileclasses.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet.javax.servlet-api.jar:3.1.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet.javax.servlet-api.jar:3.1.0]
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at com.agile.ui.pcm.common.filter.RemoteFSRequestFilter.doFilter(RemoteFSRequestFilter.java:139) [agileclasses.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at com.agile.ui.web.filter.LoggingFilter.doFilter(LoggingFilter.java:110) [agileclasses.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at com.agile.ui.pcm.common.filter.WebClientLog.doFilter(WebClientLog.java:78) [agileclasses.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at com.agile.ui.pcm.common.filter.SSOTicketFilter.doFilter(SSOTicketFilter.java:89) [agileclasses.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at com.agile.ui.pcm.common.filter.WebSecurityFilter.doFilter(WebSecurityFilter.java:214) [agileclasses.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141) [jps-ee.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_121]
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315) [jps-api.jar:?]
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650) [jps-ee.jar:?]
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124) [jps-ee.jar:?]
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232) [jps-ee.jar:?]
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94) [jps-ee.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248) [dms.jar:?]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326) [com.oracle.weblogic.security.subject.jar:12.2.1.1]
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) [com.oracle.weblogic.security.subject.jar:12.2.1.1]
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1686) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1646) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270) [com.oracle.weblogic.servlet.jar:12.2.1.1]
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348) [com.bea.core.utils.full.jar:12.2.1.1]
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333) [com.bea.core.utils.full.jar:12.2.1.1]
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54) [com.oracle.weblogic.work.jar:12.2.1.1]
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:12.2.1.1]
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640) [com.bea.core.weblogic.workmanager.jar:12.2.1.1]
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406) [com.bea.core.weblogic.workmanager.jar:12.2.1.1]
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346) [com.bea.core.weblogic.workmanager.jar:12.2.1.1]

Changes

User created new search criteria to be used in the Workflow Routings folder.

Cause

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