Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-9571

The $xwiki.statsService.getActionStatistics (ActivityData Page) is not returning any value on Oracle

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.2
    • Fix Version/s: 5.4-milestone-1
    • Component/s: Statistics
    • Labels:
      None
    • Environment:
      Xwiki 5.2, Tomcat 7, Oracle 11g
    • Difficulty:
      Medium
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      The statistics component is not working in my XWiki 5.2 installation.

      The method
      "$xwiki.statsService.getActionStatistics('view', $scope, $period, $step)"
      is returning 0 values, but the stats are enable, so much so that, other stats are working.

      Furthermore, all the views/edit stats graphs are not working due this problem. How the activity data is not returning data then the graphs is not showing any value.

      Evidence 1 - Graph is not showing any value
      Evidence 2 - getActionStatistics is not returning any value
      Evidence 3- Stats are working well.

      Additional Infomartion:
      In my first installation of XWiki, when I migrated to Oracle neither the statistics of "Daily connections" or "Active users" or "Recent sessions" were working well. They were returning the error “ORA-01843: not a valid month error”.
      So I changed and configured a trigger in my oracle altering my NLS_DATE_FORMAT to "YYYY-MM-DD HH24:MI:SS"' and NLS_TIMESTAMP_FORMAT to "YYYY-MM-DD HH24:MI:SS.FF"' and they started to work well, see evidence 4. I don’t know if this kind of variables are related with this issue!

        Attachments

        1. Evidence1.PNG
          Evidence1.PNG
          81 kB
        2. evidence2.PNG
          evidence2.PNG
          124 kB
        3. evidence3.PNG
          evidence3.PNG
          142 kB
        4. Evidence4.PNG
          Evidence4.PNG
          158 kB

          Activity

            People

            • Assignee:
              vmassol Vincent Massol
              Reporter:
              danilo Danilo Amaral de Oliveira
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Date of First Response: