[
https://issues.apache.org/jira/browse/OPENMEETINGS-628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Solodovnik resolved OPENMEETINGS-628.
-------------------------------------------
Resolution: Fixed
Fix Version/s: 3.0.0 Apache Release
Assignee: Maxim Solodovnik (was: SebastianWagner)
Committed revision 1483196.
> 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: Maxim Solodovnik
> Fix For: 3.0.0 Apache Release
>
>
> 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
