Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9650

Potential owners of tasks retrieved by query don't match expected owners

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.52.0.Final
    • Fix Version/s: 7.52.0.Final
    • Component/s: KieServer
    • Labels:
      None
    • Sprint:
      2021 Week 10-12 (from Mar 8)
    • Steps to Reproduce:
      Hide

      Start database PostgreSQL11.5 locally.
      Execute QueryDataServiceIntegrationTest.testGetTasksWithPotentialOwnerDoubleGroup() against the started PostgreSQL database.
      You can use maven command in kie-server-integ-tests-jbpm module:

       mvn clean install -Pwildfly,postgresql -Dit.test=QueryDataServiceIntegrationTest -Dorg.kie.server.datasource.connection.url=jdbc:postgresql://localhost:5432/mydb
      

      Username and password should be set to `sa`, database name to `mydb`.

      Show
      Start database PostgreSQL11.5 locally. Execute QueryDataServiceIntegrationTest.testGetTasksWithPotentialOwnerDoubleGroup() against the started PostgreSQL database. You can use maven command in kie-server-integ-tests-jbpm module: mvn clean install -Pwildfly,postgresql -Dit.test=QueryDataServiceIntegrationTest -Dorg.kie.server.datasource.connection.url=jdbc:postgresql://localhost:5432/mydb Username and password should be set to `sa`, database name to `mydb`.
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      Potential owners of tasks retrieved by custom query:

      "select ti.taskId, ti.activationTime, ti.actualOwner, ti.createdBy, ti.createdOn, ti.deploymentId, ti.description, ti.dueDate, ti.name, ti.parentId, ti.priority, ti.processId, ti.processInstanceId, ti.processSessionId, ti.status, ti.workItemId, oe.id, eo.entity_id from AuditTaskImpl ti left join PeopleAssignments_PotOwners po on ti.taskId = po.task_id left join OrganizationalEntity oe on po.entity_id = oe.id left join PeopleAssignments_ExclOwners eo on ti.taskId = eo.task_id"
      

      returns duplicate entries.

      This issue seems to be related to https://github.com/kiegroup/jbpm/pull/1870
      When I reverted the commit the query returns correct owners.

      The issue affects just databases MSSQL 2017, MySQL8, PostgreSQL11.5 and Sybase 16.
      Databases H2, DB2 11.1 and Oracle 19 works properly.

        Attachments

          Activity

            People

            Assignee:
            ftirados Francisco Javier Tirado Sarti
            Reporter:
            ksuta Karel Suta
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: