[
https://issues.apache.org/jira/browse/OPENMEETINGS-1004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Solodovnik resolved OPENMEETINGS-1004.
--------------------------------------------
Resolution: Fixed
Fix Version/s: 3.1.0
3.0.2
Assignee: Maxim Solodovnik
Committed revision 1595906.
> Internal error is thrown when you search a user on the Search Users Tab
> -----------------------------------------------------------------------
>
> Key: OPENMEETINGS-1004
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1004
> Project: Openmeetings
> Issue Type: Bug
> Components: HTML5
> Affects Versions: 3.0.2
> Environment: Red Hat Enterprise Linux Server release 6.5, kernel
> 2.6.32-431.5.1.el6.x86_64, jdk 1.7.0_51, firefox 29.0
> Reporter: Roberto E.L.
> Assignee: Maxim Solodovnik
> Priority: Critical
> Fix For: 3.0.2, 3.1.0
>
>
> When you try to search user on the Search users tab the following error is
> thrown:
> DEBUG 05-19 08:23:42.866 AbstractUserDao.java 1238443 473
> org.apache.openmeetings.db.dao.user.AbstractUserDao
> [http-nio-0.0.0.0-8080-exec-3] - hql :: SELECT COUNT(u) FROM User u WHERE
> u.deleted = false AND nullAND (LOWER(u.userSearchs) LIKE :userSearchs)
> ERROR 05-19 08:23:42.890 DefaultExceptionMapper.java 1238467 129
> org.apache.wicket.DefaultExceptionMapper [http-nio-0.0.0.0-8080-exec-3] -
> Unexpected error occurred
> org.apache.wicket.WicketRuntimeException: Error attaching this container for
> rendering: [WebMarkupContainer [Component id = container]]
> at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1694)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.onBeforeRender(Component.java:3853)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.internalBeforeRender(Component.java:923)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.beforeRender(Component.java:991)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.Component.internalPrepareForRender(Component.java:2216)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.prepareForRender(Component.java:2255)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.ajax.XmlAjaxResponse.writeComponent(XmlAjaxResponse.java:107)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.ajax.AbstractAjaxResponse.writeComponents(AbstractAjaxResponse.java:218)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.ajax.AbstractAjaxResponse.writeTo(AbstractAjaxResponse.java:150)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.ajax.AjaxRequestHandler.respond(AjaxRequestHandler.java:359)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:862)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64)
> ~[wicket-request-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:97)
> ~[wicket-request-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:261)
> [wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:218)
> [wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:289)
> [wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:59)
> [wicket-native-websocket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:201)
> [wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:282)
> [wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:77)
> [red5.jar:na]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1721)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1679)
> [tomcat-embed-core-jar-7.0.50.jar:7.0.50]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_51]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_51]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51]
> Caused by: org.apache.openjpa.persistence.ArgumentException: "Encountered
> "nullAND (" at character 57, but expected: ["(", "*", "+", "-", ".", "/",
> ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS",
> "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE",
> "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY",
> "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INDEX",
> "INNER", "IS", "JOIN", "KEY", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE",
> "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF",
> "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING",
> "SUM", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "VALUE", "WHERE",
> <BOOLEAN_LITERAL>, <DATE_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>,
> <INTEGER_LITERAL>, <STRING_LITERAL2>, <STRING_LITERAL>, <TIMESTAMP_LITERAL>,
> <TIME_LITERAL>]." while parsing JPQL "SELECT COUNT(u) FROM User u WHERE
> u.deleted = false AND nullAND (LOWER(u.userSearchs) LIKE :userSearchs)". See
> nested stack trace for original parse error.
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:51)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)
> ~[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.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.7.0_51]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[na:1.7.0_51]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_51]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51]
> at
> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
> ~[spring-orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
> at com.sun.proxy.$Proxy15.createQuery(Unknown Source) ~[na:na]
> at
> org.apache.openmeetings.db.dao.user.AbstractUserDao.searchCountUserProfile(AbstractUserDao.java:474)
> ~[openmeetings-db-3.0.2-SNAPSHOT.jar:na]
> at
> org.apache.openmeetings.db.dao.user.AbstractUserDao$$FastClassByCGLIB$$8b5514d8.invoke(<generated>)
> ~[com.springsource.net.sf.cglib-2.2.0.jar:na]
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
> ~[com.springsource.net.sf.cglib-2.2.0.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.db.dao.user.AbstractUserDao$$EnhancerByCGLIB$$3494eaeb.searchCountUserProfile(<generated>)
> ~[com.springsource.net.sf.cglib-2.2.0.jar:na]
> at
> org.apache.openmeetings.db.dao.user.UserDao.searchCountUserProfile(UserDao.java:84)
> ~[openmeetings-db-3.0.2-SNAPSHOT.jar:na]
> at
> org.apache.openmeetings.web.user.profile.UserSearchPanel$3.size(UserSearchPanel.java:116)
> ~[openmeetings-web-3.0.2-SNAPSHOT.jar:na]
> at
> org.apache.wicket.markup.repeater.data.DataViewBase.internalGetItemCount(DataViewBase.java:142)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractPageableView.getItemCount(AbstractPageableView.java:235)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractPageableView.getRowCount(AbstractPageableView.java:216)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractPageableView.getViewSize(AbstractPageableView.java:314)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractPageableView.getItemModels(AbstractPageableView.java:99)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.RefreshingView.onPopulate(RefreshingView.java:93)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:116)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.markup.repeater.AbstractPageableView.onBeforeRender(AbstractPageableView.java:115)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.internalBeforeRender(Component.java:923)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at org.apache.wicket.Component.beforeRender(Component.java:991)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> at
> org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1682)
> ~[wicket-core-jar-6.14.0.jar:6.14.0]
> ... 38 common frames omitted
> Caused by: org.apache.openjpa.persistence.ArgumentException: Encountered
> "nullAND (" at character 57, but expected: ["(", "*", "+", "-", ".", "/",
> ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS",
> "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE",
> "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY",
> "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INDEX",
> "INNER", "IS", "JOIN", "KEY", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE",
> "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF",
> "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING",
> "SUM", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "VALUE", "WHERE",
> <BOOLEAN_LITERAL>, <DATE_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>,
> <INTEGER_LITERAL>, <STRING_LITERAL2>, <STRING_LITERAL>, <TIMESTAMP_LITERAL>,
> <TIME_LITERAL>].
> at
> org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:13162)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:13036)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1980)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1958)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1807)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1820)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1769)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1587)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:2401)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:2388)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:49)
> ~[openjpa-bundle-2.2.2.jar:2.2.2]
> ... 75 common frames omitted
--
This message was sent by Atlassian JIRA
(v6.2#6252)
