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

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

XMLWordPrintable

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

      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.

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

                Created:
                Updated:
                Resolved: