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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.4-milestone-1
    • 5.2
    • Statistics
    • None
    • Xwiki 5.2, Tomcat 7, Oracle 11g
    • Medium
    • N/A
    • N/A

    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. Evidence4.PNG
          Evidence4.PNG
          158 kB
        2. evidence3.PNG
          evidence3.PNG
          142 kB
        3. evidence2.PNG
          evidence2.PNG
          124 kB
        4. Evidence1.PNG
          Evidence1.PNG
          81 kB

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: