Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13920

Reporting aggregateFields=TIMESTAMP is returning a 500 error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.5.0.1
    • Fix Version/s: 7.0.0, 6.5.0.4
    • Component/s: None
    • Labels:

      Description

      Based on PyForge test: 

      PyBot/OpenIDM/testcases/functional/services/reporting/reporting_on_managed_users.robot/reporting_on_managed_users_lastchanged_date_by_hour

      Trying to get an report using `aggregateFields=TIMESTAMP` is returning a 500 error with the following message: 

      "message": "Text '2019-10-10T17:30:30.502992Z' could not be parsed at index 23" 

      Using a different field such as VALUE does not return an error, even if returning the timestamp.

      Steps to Reproduce:

      1. Start IDM and create 1 managed user named "user01"
      2. Send the following curl statement:
        1. curl -X GET -H 'Accept-API-Version: resource=1.0' -H 'X-OpenIDM-Password: openidm-admin' -H 'X-OpenIDM-Username: openidm-admin' 'http://localhost:8080/openidm/report/managed/user?_queryFilter=userName+eq+%27user01%27&_fields=%2A,/_meta/%2A&aggregateFields=VALUE=/_meta/lastChanged'
      3. Verify 200 status code and correct results
      4. Send the following curl statement with uses TIMESTAMP
        1. curl -X GET -H 'Accept-API-Version: resource=1.0' -H 'X-OpenIDM-Password: openidm-admin' -H 'X-OpenIDM-Username: openidm-admin' 'http://localhost:8080/openidm/report/managed/user?_queryFilter=userName+eq+%27user01%27&_fields=%2A,/_meta/%2A&aggregateFields=TIMESTAMP=/_meta/lastChanged/date;scale:day;utcOffset:-0700'

      Expected results:

      • 200 status code and 1 account returned

      Actual results

      • 500 status code with error saying the timestamp text cannot be parsed

      See also: https://backstage.forgerock.com/docs/idm/6.5/integrators-guide/#generating-managed-reports

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                travis.haagen Travis Haagen
                Reporter:
                scott.mccollough Scott McCollough
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: