You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "Vasiliy Degtyarev (JIRA)" <ji...@apache.org> on 2013/05/16 06:55:16 UTC
[jira] [Created] (OPENMEETINGS-628) Exception is thrown when search
user on the Profile->Search users tab
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