Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-357

Oracle Support : Issue with searching for users

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 8.1.4
    • Fix Version/s: 8.2
    • Component/s: Home, Pwd, Portal
    • Labels:
    • Environment:

      Oracle 11gR2, Tomcat 7, Java 6

      Description

      Home | Other Users | Last Name -> anything
      Search

      Error code: N1-E3
      Date and time: 9/14/12 10:43 AM
      Additional information: -
      Last business path: http://hedrickbt-w510:20041/olat/url/HomeSite/589824/portal/0
      Business path: http://hedrickbt-w510:20041/olat/url/HomeSite/589824/GMCMenuTree/1045922779

      10:43:53,533 ERROR PARSER:56 - line 1:173: unexpected token: escape
      10:43:53,543 WARN ExceptionWindowController:175 - OLAT::WARN % N1-W13 % org.olat.core.gui.exception % student % 192.168.146.1 % http://hedrickbt-w510.rainhail.com:8080/olat/auth/1%3A1%3A0%3A0%3A0/ % Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1 % ExceptionWindowController<init>: Throwable occurred, logging the full stacktrace: % >>>stack of 1.cause::org.olat.core.logging.DBRuntimeException: Error while creating DBQueryImpl: -> at org.olat.core.commons.persistence.DBManager.createQuery(DBManager.java:277) at org.olat.core.commons.persistence.DBImpl.createQuery(DBImpl.java:434) at org.olat.basesecurity.BaseSecurityManager.createIdentitiesByPowerQuery(BaseSecurityManager.java:1407) at org.olat.basesecurity.BaseSecurityManager.getIdentitiesByPowerSearch(BaseSecurityManager.java:1179) at org.olat.basesecurity.BaseSecurityManager.getVisibleIdentitiesByPowerSearch(BaseSecurityManager.java:1163) at org.olat.admin.user.UserSearchController.searchUsers(UserSearchController.java:369) at org.olat.admin.user.UserSearchController.event(UserSearchController.java:327) at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:228) at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:225) at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:173)>>>stack of 2.cause::org.hibernate.hql.ast.QuerySyntaxException: unexpected token: escape near line 1, column 173 [select distinct ident from org.olat.basesecurity.IdentityImpl as ident join ident.user as user where lower(user.properties['lastName']) like :lastName_value escape '\' escape '\' and ident.status < :status ] -> at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
      10:43:53,544 ERROR DBRuntimeException:175 - OLAT::ERROR % N1-E3 % org.olat.core.logging % student % 192.168.146.1 % http://hedrickbt-w510.rainhail.com:8080/olat/auth/1%3A1%3A0%3A0%3A0/ % Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1 % *RedScreen* Error while creating DBQueryImpl: ::_::<dispatchinfo> <componentinfo> <compname>ffo_main_null</compname> <compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass> <extendedinfo></extendedinfo> <event> <class>org.olat.core.gui.control.Event</class> <command>validation ok</command> <tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring> </event> </componentinfo> <controllerinfo> <controllername>org.olat.admin.user.UserSearchForm</controllername> <controllername>org.olat.home.HomeMainController</controllername> <controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername> <controllername>org.olat.core.commons.chiefcontrollers.controller.simple.SimpleBaseController</controllername> <controllername>org.olat.core.commons.chiefcontrollers.BaseChiefController</controllername> </controllerinfo></dispatchinfo> ::_:: % >>>stack of 1.cause::org.olat.core.logging.DBRuntimeException: Error while creating DBQueryImpl: -> at org.olat.core.commons.persistence.DBManager.createQuery(DBManager.java:277) at org.olat.core.commons.persistence.DBImpl.createQuery(DBImpl.java:434) at org.olat.basesecurity.BaseSecurityManager.createIdentitiesByPowerQuery(BaseSecurityManager.java:1407) at org.olat.basesecurity.BaseSecurityManager.getIdentitiesByPowerSearch(BaseSecurityManager.java:1179) at org.olat.basesecurity.BaseSecurityManager.getVisibleIdentitiesByPowerSearch(BaseSecurityManager.java:1163) at org.olat.admin.user.UserSearchController.searchUsers(UserSearchController.java:369) at org.olat.admin.user.UserSearchController.event(UserSearchController.java:327) at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:228) at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:225) at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:173)>>>stack of 2.cause::org.hibernate.hql.ast.QuerySyntaxException: unexpected token: escape near line 1, column 173 [select distinct ident from org.olat.basesecurity.IdentityImpl as ident join ident.user as user where lower(user.properties['lastName']) like :lastName_value escape '\' escape '\' and ident.status < :status ] -> at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gnaegi Florian Gnägi
              Reporter:
              bhedrick Brooke Hedrick
              Tester:
              Brooke Hedrick
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h