Uploaded image for project: 'OptaPlanner'
  1. OptaPlanner
  2. PLANNER-2047

Using Task Assigning with DDL prevents users from completing tasks

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.39.0.Final
    • 7.39.0.Final
    • None
    • None
    • 2020 Week 25-27 (from Jun 15)
    • 1
    • 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
    • NEW
    • NEW

    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
              wmedvede@redhat.com Walter Medvedeo
              Anna Dupliak Anna Dupliak
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: