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

DB2 repo - Query with sorting of vertex fields failed

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      1
    • Sprint:
      2019.14 - IDM

      Description

      As you can see in this db2 job queries with `_sortKeys=<vertex-field>` are failing with 500 status code and message: DB reported failure executing query.
      Steps to reproduce:

      1. Either run those tests in DB2 machine or just setup environment for db2 repo with openidm-sample sync-with-csv and run this query:
        curl -X GET \
          'http://idm.example.com:8080/openidm/internal/role/openidm-authorized/authzMembers?_queryFilter=_refResourceCollection%20eq%20%22managed/user%22&_sortKeys=userName' \
          -H 'Content-Type: application/json' \
          -H 'X-OpenIDM-Password: openidm-admin' \
          -H 'X-OpenIDM-Username: openidm-admin' 
        

      Tested with the OpenIDM: 7.0.0-SNAPSHOT 5d70b5a

        Attachments

          Activity

            People

            • Assignee:
              jason.vincent jason vincent
              Reporter:
              alexander.dracka Alexander Dracka
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: