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

Lesson tool activity not working in Oracle

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 11.0
    • Fix Version/s: 11.0, 12.0
    • Component/s: Sitestats
    • Labels:
      None
    • Environment:
      Oracle
    • 11 status:
      Resolved
    • Test Plan:
      Hide

      On the nightly oracle server

      • Add site stats and lessons to a site
      • Go to lessons and try to add some content
      • Look at the server logs to see if they're any ERROR (There' shouldn't be)
      • Also verify that there are lesson tool activity on this server (See SAK-29709)
      Show
      On the nightly oracle server Add site stats and lessons to a site Go to lessons and try to add some content Look at the server logs to see if they're any ERROR (There' shouldn't be) Also verify that there are lesson tool activity on this server (See SAK-29709 )

      Description

      SAK-29709 added functionality to sitestats for lessons, but it doesn't work in Oracle and throws database exceptions.

      2016-04-15 08:41:10,040  WARN http-apr-19888-exec-19 org.hibernate.util.JDBCExceptionReporter - SQL Error: 979, SQLState: 42000
      2016-04-15 08:41:10,040 ERROR http-apr-19888-exec-19 org.hibernate.util.JDBCExceptionReporter - ORA-00979: not a GROUP BY expression
      
      2016-04-15 08:41:10,041 ERROR http-apr-19888-exec-19 org.sakaiproject.sitestats.tool.wicket.widget.LessonsWidget - Caught exception while getting the most read page. Setting mostReadPage to "" ...
      org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select lessonbuil0_.PAGE_REF as col_0_0_, lessonbuil0_.PAGE_ID as col_1_0_, sum(lessonbuil0_.PAGE_COUNT) as col_2_0_ from SST_LESSONBUILDER lessonbuil0_ where lessonbuil0_.SITE_ID=? and lessonbuil0_.PAGE_ACTION=? and (lessonbuil0_.PAGE_REF like ?) and lessonbuil0_.USER_ID<>'?' group by lessonbuil0_.PAGE_REF order by col_2_0_ DESC]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
      

      This looks like the line
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getMostReadLessonPage(StatsManagerImpl.java:1041)

      and
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getLessonBuilderStats(StatsManagerImpl.java:2250)

      Try on the nightly to see more details.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  mkelsey Molly Kelsey (Inactive)
                  Reporter:
                  jonespm Matthew Jones
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration