Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-28525

Activity charts not rendered for Oracle installations

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.0
    • Fix Version/s: 2.5.0
    • Component/s: Sitestats
    • Labels:
      None
    • Environment:
      Oracle
    • Previous Issue Keys:
      STAT-32

      Description

      From Jim Doherty email (2007-08-17):
      When we click on one of the three view links (daily, weekly, monthly) we get this error generated in catalina.out and the graphic does not appear.

      I hope you can do something with this – see error text below.
      For your info, we are running on Oracle.. ORA-00979 is the Oracle database error that seems to be the proximate cause.
      I had heard that there are some Oracle and MySQL differences, maybe that is the case her

      thanks and best regards,
      Jim Doherty

      WARN: SQL Error: 979, SQLState: 42000 (2007-08-17 14:25:01,050 http-80-Processor22_org.hibernate.util.JDBCExceptionReporter)
      ERROR: ORA-00979: Geen GROUP BY-uitdrukking.
      (2007-08-17 14:25:01,051 http-80-Processor22_org.hibernate.util.JDBCExceptionReporter)
      ERROR: Servlet.service() for servlet Faces Servlet threw exception (2007-08-17 14:25:01,052 http-80-Processor22_org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/sakai-sitestats-tool].[Faces Servlet])
      javax.faces.el.EvaluationException: Exception while invoking expression #

      {OverviewBean.generateActivityChart}

      at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:156)
      at org.ajax4jsf.framework.resource.UserResource.send (UserResource.java:110)
      at org.ajax4jsf.framework.resource.ResourceLifecycle.send(ResourceLifecycle.java:86)
      at org.ajax4jsf.framework.resource.InternetResourceService.sendResource(InternetResourceService.java :256)
      at org.ajax4jsf.framework.resource.InternetResourceService.serviceResource(InternetResourceService.java:240)
      at org.ajax4jsf.framework.resource.InternetResourceService.serviceResource(InternetResourceService.java :141)
      at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:261)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java :81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select s.SITE_ID as actSiteId, sum(s.ACTIVITY_COUNT) as actCount, s.EVENT_ID as actEventId from SST_SITEACTIVITY s where s.SITE_ID = ? and s.EVENT_ID in (?, ?, ?, ?) and s.ACTIVITY_DATE >= ? and s.ACTIVITY_DATE < ? group by s.SITE_ID, s.SITE_ID]; nested exception is java.sql.SQLException: ORA-00979: Geen GROUP BY-uitdrukking.

      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java :89)
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258)
      at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException (HibernateAccessor.java:424)
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute (HibernateTemplate.java:371)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getSiteActivityByTool(StatsManagerImpl.java :2345)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getSummaryActivityChartData(StatsManagerImpl.java:1106)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getSummaryActivityChartData(StatsManagerImpl.java :1057)
      at org.sakaiproject.sitestats.tool.bean.OverviewBean.getActivityWeekPieDataSet(OverviewBean.java:433)
      at org.sakaiproject.sitestats.tool.bean.OverviewBean.generateActivityChart(OverviewBean.java:197)
      at sun.reflect.GeneratedMethodAccessor1529.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
      ... 20 more
      Caused by: java.sql.SQLException: ORA-00979: Geen GROUP BY-uitdrukking.

      at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java :743)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe (OracleStatement.java:1039)
      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      at org.hibernate.loader.Loader.doQuery (Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2145)
      at org.hibernate.loader.Loader.listIgnoreQueryCache (Loader.java:2029)
      at org.hibernate.loader.Loader.list(Loader.java:2024)
      at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
      at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java :1655)
      at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
      at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl$15.doInHibernate (StatsManagerImpl.java:2309)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
      ... 30 more

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                nfernandes Nuno Fernandes (Inactive)
                Reporter:
                nfernandes Nuno Fernandes (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code