sort error on attributes

XMLWordPrintable

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Minor
    • 2.5.37
    • Affects Version/s: None
    • Component/s: None
    • None

      2020-10-23 14:48:16,864: [ajp-nio-0.0.0.0-8009-exec-3] ERROR GrouperUiRestServlet.doGet(369) -  - Problem calling reflection from URL: edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2AttributeDefName.viewAttributeDefNameAssignedOwners
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (21e24589): new, readonly, READONLY_NEW, notActiveTransaction, session (6f1d2152),
      Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select ad, adn, theAttributeDef, aa  from AttributeDef theAttributeDef, AttributeAssign aa, AttributeDefName adn, AttributeDef ad  where  aa.attributeDefNameId = adn.id and theAttributeDef.id = aa.ownerAttributeDefId and ad.id = adn.attributeDefId  and aa.attributeAssignTypeDb = 'attr_def'  and aa.enabledDb = 'T'  and adn.id in (:UQLYQIKF0) ', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3AttributeAssignDAO.FindAttributeAssignmentsFromDef, tx type: null, options: QueryOptions: querySort: displayExtension asc, retrieveResults: true, retrieveCount: false, , tx type: nullBind var[0]: 'Param (class java.lang.String): 'UQLYQIKF0'->'b28b828c2a3c47c0ae459c540897f5d1', ,
      Problem calling method viewAttributeDefNameAssignedOwners on edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2AttributeDefName
              at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:407)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:458)
              at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3AttributeAssignDAO.findAttributeDefAttributeAssignmentsByAttribute(Hib3AttributeAssignDAO.java:6649)
              at edu.internet2.middleware.grouper.attr.finder.AttributeAssignFinder.findAttributeAssignFinderResultsHelper(AttributeAssignFinder.java:644)
              at edu.internet2.middleware.grouper.attr.finder.AttributeAssignFinder.findAttributeAssignFinderResults(AttributeAssignFinder.java:603)
              at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2AttributeDefName$1.callback(UiV2AttributeDefName.java:799)
              at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)
              at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1024)
              at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2AttributeDefName.viewAttributeDefNameAssignedOwnersHelper(UiV2AttributeDefName.java:783)
              at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2AttributeDefName.viewAttributeDefNameAssignedOwners(UiV2AttributeDefName.java:762)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at edu.internet2.middleware.grouper.util.GrouperUtil.invokeMethod(GrouperUtil.java:4268)
              at edu.internet2.middleware.grouper.util.GrouperUtil.callMethod(GrouperUtil.java:4219)
              at edu.internet2.middleware.grouper.j2ee.GrouperUiRestServlet.doGet(GrouperUiRestServlet.java:336)
              at edu.internet2.middleware.grouper.j2ee.GrouperUiRestServlet.doPost(GrouperUiRestServlet.java:203)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiFilter.java:1163)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
              at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:44)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
              at org.apache.tomee.catalina.OpenEJBSecurityListener$RequestCapturer.invoke(OpenEJBSecurityListener.java:97)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
              at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:525)
              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
              at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)
              at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
              at org.hibernate.loader.Loader.doQuery(Loader.java:919)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
              at org.hibernate.loader.Loader.doList(Loader.java:2617)
              at org.hibernate.loader.Loader.doList(Loader.java:2600)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
              at org.hibernate.loader.Loader.list(Loader.java:2424)
              at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
              at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
              at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
              at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
              at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
              at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:381)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:417)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              ... 49 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'displayExtension' in 'order clause'
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
              at com.mysql.jdbc.Util.getInstance(Util.java:408)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)
              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
              ... 66 more 

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: