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

Sorting on retries on Workflow deadletter jobs causes 500 error.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 7.0.0
    • Fix Version/s: None
    • Component/s: Module - Workflow
    • Labels:
      None

      Description

      Sorting on retries field in the workflow deadletter job api causes 500 error.

      curl --header "X-OpenIDM-Username: openidm-admin" --header "X-OpenIDM-Password: openidm-admin" --request  GET http://localhost:8080/openidm/workflow/job/deadletter?_queryId=filtered-query&_sortKeys=retries 

      Response Content:

      {"code":500,"reason":"Internal Server Error","message":"\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 'RES.RETRIES_' in 'order clause'\n### The error may exist in org/flowable/job/service/db/mapping/entity/DeadLetterJob.xml\n### The error may involve org.flowable.job.service.impl.persistence.entity.DeadLetterJobEntityImpl.selectDeadLetterJobByQueryCriteria-Inline\n### The error occurred while setting parameters\n### SQL: select RES.*                      from ACT_RU_DEADLETTER_JOB RES                          order by RES.RETRIES_ asc          LIMIT ? OFFSET ?\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'RES.RETRIES_' in 'order clause'"}

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jason.vincent jason vincent
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: