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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved (View Workflow)
    • Major
    • Resolution: Done
    • 7.52.0.Final
    • 7.52.0.Final
    • KieServer
    • None
    • 2021 Week 10-12 (from Mar 8)
    • 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`.
    • NEW
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: