Vasiliy Degtyarev created OPENMEETINGS-628:
----------------------------------------------
Summary: Exception is thrown when search user on the
Profile->Search users tab
Key: OPENMEETINGS-628
URL: https://issues.apache.org/jira/browse/OPENMEETINGS-628
Project: Openmeetings
Issue Type: Bug
Components: UI
Affects Versions: 3.0.0 Apache Release
Reporter: Vasiliy Degtyarev
Assignee: SebastianWagner
Go to the Profile->Search users tab and enter text to any search field. Click
on the "Search" button.
The followng exception is thrown:
org.apache.openjpa.persistence.ArgumentException: An error occurred while
parsing the query filter "SELECT u FROM User u WHERE u.deleted = false AND
(LOWER(u.login) LIKE :search OR LOWER(u.firstname) LIKE :search OR
LOWER(u.lastname) LIKE :search OR LOWER(u.adresses.email) LIKE :search OR
LOWER(u.adresses.town) LIKE :search ) ORDER BY c.lastname ASC". Error message:
Attempt to query field "c.lastname" from non-entity variable "c". Perhaps you
forgot to prefix the path in question with an identification variable from your
FROM clause?
at
org.apache.openjpa.kernel.exps.AbstractExpressionBuilder.parseException(AbstractExpressionBuilder.java:119)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getPath(JPQLExpressionBuilder.java:1958)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getPathOrConstant(JPQLExpressionBuilder.java:1891)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.eval(JPQLExpressionBuilder.java:1189)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getValue(JPQLExpressionBuilder.java:2084)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getValue(JPQLExpressionBuilder.java:2070)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.evalOrderingClauses(JPQLExpressionBuilder.java:532)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getQueryExpressions(JPQLExpressionBuilder.java:306)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.kernel.jpql.JPQLParser.eval(JPQLParser.java:67)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.<init>(ExpressionStoreQuery.java:763)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.ExpressionStoreQuery.newDataStoreExecutor(ExpressionStoreQuery.java:179)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.QueryImpl.createExecutor(QueryImpl.java:749)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.QueryImpl.compileForDataStore(QueryImpl.java:707)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:689)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:997)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:979)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:975)
~[openjpa-bundle-2.2.2.jar:2.2.2]
at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) ~[na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_10]
at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_10]
at
org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at $Proxy14.createQuery(Unknown Source) ~[na:na]
at
org.apache.openmeetings.data.user.UserManager.searchUserProfile(UserManager.java:1641)
~[openmeetings-3.0.0-SNAPSHOT.jar:na]
at
org.apache.openmeetings.data.user.UserManager$$FastClassByCGLIB$$c43b186d.invoke(<generated>)
~[cglib-jar-2.2.2.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
~[cglib-jar-2.2.2.jar:na]
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
~[spring-tx-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
~[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at
org.apache.openmeetings.data.user.UserManager$$EnhancerByCGLIB$$427b190.searchUserProfile(<generated>)
~[cglib-jar-2.2.2.jar:na]
at
org.apache.openmeetings.remote.UserService.searchUserProfile(UserService.java:629)
~[openmeetings-3.0.0-SNAPSHOT.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.7.0_10]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[na:1.7.0_10]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_10]
at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_10]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)
[red5-server.jar:na]
at
org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)
[red5-server.jar:na]
at
org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:164)
[red5-server.jar:na]
at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:409)
[red5-server.jar:na]
at
org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:132)
[red5-server.jar:na]
at
org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:170)
[red5-server.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:690)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:407)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:236)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
[mina-core-2.0.7.jar:na]
at
org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:130)
[red5-server.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:109)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:410)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:710)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:664)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:653)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:67)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1124)
[mina-core-2.0.7.jar:na]
at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[mina-core-2.0.7.jar:na]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[na:1.7.0_10]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[na:1.7.0_10]
at java.lang.Thread.run(Thread.java:722) [na:1.7.0_10]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
