You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "Roberto E.L. (JIRA)" <ji...@apache.org> on 2014/05/19 10:30:38 UTC
[jira] [Created] (OPENMEETINGS-1004) Internal error is thrown when
you search a user on the Search Users Tab
Roberto E.L. created OPENMEETINGS-1004:
------------------------------------------
Summary: 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.
Priority: Critical
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)