Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3027

Using Task Assigning with DDL prevents users from completing tasks

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.8.0.GA
    • 7.8.0.GA
    • Kie-Server
    • None
    • any supported production DB (Oracle, MSSQL, DB2, SYBASE, PostgreSQL,...)

    • 1
    • CR1
    • Hide
      1. Use DDL to create a DB schema
      2. Run the integration test
      Show
      Use DDL to create a DB schema Run the integration test
    • 2020 Week 25-27 (from Jun 15)

    Description

      When a user is completing a task, the task is supposed to be deleted from the "task" DB table. Due to a FK constraint from the "PlanningTask" table, the transaction fails (see the attached stack trace).

       

      Root cause:

      Caused by: Error : 2292, Position : 0, Sql = delete from Task where id=:1 and OPTLOCK=:2 , OriginalSql = delete from Task where id=? and OPTLOCK=?, Error Msg = ORA-02292: integrity constraint (DBALLO04.FK_PLANNINGTASK_TASK) violated - child record found

      Attachments

        Issue Links

          Activity

            People

              wmedvede@redhat.com Walter Medvedeo
              rsynek@redhat.com Radovan Synek
              Anna Dupliak Anna Dupliak
              Anna Dupliak Anna Dupliak
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: