Jdeveloper: 11.1.1.5.0
==============
I have a master detail in my application ....
I'm getting this error message on executing a query (ExecutewithParams) (which also has a View Criteria) , when I join two tables together. I have to join two tables to show extra columns,I need ... but get the error msg --> JBO-36002: The method call specification is invalid. "," or ")" is expected ...on a commandbutton press.
<af:commandButton actionListener="#{bindings.ExecuteWithParams2.execute}"
text="Search"
disabled="#{!bindings.ExecuteWithParams2.enabled}"
id="cb2"/>
**When I remove my join ..i.e don't join the tables, then I get no more error.
Need help.
Thanks,
Error Stack
========
<Utils> <buildFacesMessage> ADF: Adding the following JSF error message: The method call specification is invalid. "," or ")" is expected.
Token begin line=0 pos=53, end line=0 pos=61, string=QRSLTSQ1
oracle.jbo.expr.JISyntaxError: JBO-36002: The method call specification is invalid. "," or ")" is expected.
at oracle.jbo.expr.JIExpr.getTerm(JIExpr.java:427)
at oracle.jbo.expr.JIExprSQL.getTerm(JIExprSQL.java:207)
at oracle.jbo.expr.JIExpr.getIdentTerm(JIExpr.java:537)
at oracle.jbo.expr.JIExpr.getMultiplyExpr(JIExpr.java:571)
at oracle.jbo.expr.JIExpr.getAddExpr(JIExpr.java:627)
at oracle.jbo.expr.JIExpr.getCompareExpr(JIExpr.java:688)
at oracle.jbo.expr.JIExpr.getAndExpr(JIExpr.java:911)
at oracle.jbo.expr.JIExpr.getOrExpr(JIExpr.java:872)
at oracle.jbo.expr.JIExpr.getBooleanExpr(JIExpr.java:861)
at oracle.jbo.expr.JIExpr.getAssignExpr(JIExpr.java:950)
at oracle.jbo.expr.JIExpr.getVarDeclExpr(JIExpr.java:1013)
at oracle.jbo.expr.JIExpr.getStmtExpr(JIExpr.java:1059)
at oracle.jbo.expr.JIExprSQL.getStmtExpr(JIExprSQL.java:804)
at oracle.jbo.expr.JIExpr.getTerm(JIExpr.java:324)
at oracle.jbo.expr.JIExprSQL.getTerm(JIExprSQL.java:207)
at oracle.jbo.expr.JIExpr.getIdentTerm(JIExpr.java:537)
at oracle.jbo.expr.JIExpr.getMultiplyExpr(JIExpr.java:571)
at oracle.jbo.expr.JIExpr.getAddExpr(JIExpr.java:627)
at oracle.jbo.expr.JIExpr.getCompareExpr(JIExpr.java:688)
at oracle.jbo.expr.JIExpr.getAndExpr(JIExpr.java:911)
at oracle.jbo.expr.JIExpr.getOrExpr(JIExpr.java:872)
at oracle.jbo.expr.JIExpr.getBooleanExpr(JIExpr.java:861)
at oracle.jbo.expr.JIExpr.getAssignExpr(JIExpr.java:950)
at oracle.jbo.expr.JIExpr.getVarDeclExpr(JIExpr.java:1004)
at oracle.jbo.expr.JIExpr.getStmtExpr(JIExpr.java:1059)
at oracle.jbo.expr.JIExprSQL.getStmtExpr(JIExprSQL.java:804)
at oracle.jbo.expr.JIExpr.getTerm(JIExpr.java:324)
at oracle.jbo.expr.JIExprSQL.getTerm(JIExprSQL.java:207)
at oracle.jbo.expr.JIExpr.getIdentTerm(JIExpr.java:537)
at oracle.jbo.expr.JIExpr.getMultiplyExpr(JIExpr.java:571)
at oracle.jbo.expr.JIExpr.getAddExpr(JIExpr.java:627)
at oracle.jbo.expr.JIExpr.getCompareExpr(JIExpr.java:688)
at oracle.jbo.expr.JIExpr.getAndExpr(JIExpr.java:911)
at oracle.jbo.expr.JIExpr.getOrExpr(JIExpr.java:872)at oracle.jbo.expr.JIExpr.getBooleanExpr(JIExpr.java:861)
at oracle.jbo.expr.JIExpr.getAssignExpr(JIExpr.java:950)
at oracle.jbo.expr.JIExpr.getVarDeclExpr(JIExpr.java:1004)
at oracle.jbo.expr.JIExpr.getStmtExpr(JIExpr.java:1059)
at oracle.jbo.expr.JIExprSQL.getStmtExpr(JIExprSQL.java:804)
at oracle.jbo.expr.JIExpr.getParseExpr(JIExpr.java:1070)
at oracle.jbo.expr.JIExpr.getExpr(JIExpr.java:1080)
at oracle.jbo.ExprEval.getParsedExpr(ExprEval.java:841)
at oracle.jbo.RowMatch.rowQualifies(RowMatch.java:182)
at oracle.jbo.server.ViewObjectImpl.rowQualifies(ViewObjectImpl.java:2849)
at oracle.jbo.server.QueryCollection.rowQualifies(QueryCollection.java:3773)
at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3658)
at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3455)
at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2205)
at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5041)
at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2935)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2791)
at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3032)
at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1225)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1363)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1269)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1254)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:6897)
at oracle.adf.model.bc4j.DCJboDataControl.executeIteratorBindingWithParams(DCJboDataControl.java:2932)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1541)
at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2149)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:740)
at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:402)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:185)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(Unknown Source)
at com.sun.el.MethodExpressionImpl.invoke(Unknown Source)
at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1256)
at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:148)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:902)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:313)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:186)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Token begin line=0 pos=63, end line=0 pos=68, string=WHERE
oracle.jbo.expr.JISyntaxError: JBO-36000: An unexpected expression token is found.
JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-36000
ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #1
<LifecycleImpl> <_handleException> ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase RENDER_RESPONSE 6
Token begin line=0 pos=63, end line=0 pos=68, string=WHERE
oracle.jbo.expr.JISyntaxError: JBO-36000: An unexpected expression token is found.
<RegistrationConfigurator> <handleError> ADF_FACES-60096:Server Exception during PPR, #1
Token begin line=0 pos=63, end line=0 pos=68, string=WHERE
oracle.jbo.expr.JISyntaxError: JBO-36000: An unexpected expression token is found.