Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-9910

Agenda editing fails when agenda items already exist

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 2.3.1
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-11926Cannot select items in the agenda tree
      KULRICE-12469Cannot submit an edited Agenda
      KULRICE-8622Fix locking of Agenda Editor View
      KULRICE-10654NPE on Editing Agenda
      KULRICE-7679KRMS: failed loading resources on Agenda
      KULRICE-6951Editing an agenda with branching causes foreign key violations on delete
      KULRICE-13321KRMS agenda editor, field labels not rendered for propositions in edit mode
      KULRICE-6396Loading lightbox for edit Agenda link (on Agenda Lookup)
      KULRICE-7122KRMS Agenda Items recursive save
      KULRICE-12200Agenda Rule - When choosing a rule type the Type field disappears
    • Rice Module:
      KRMS
    • Application Requirement:
      KPME
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required

      Description

      Trying to add a proposition to an existing rule on an agenda fails with foreign key error.

      OJB operation; SQL []; Cannot delete or update a parent row: a foreign key constraint fails (`krtt`.`krms_agenda_itm_t`, CONSTRAINT `KRMS_AGENDA_ITM_FK1` FOREIGN KEY (`RULE_ID`) REFERENCES `krms_rule_t` (`RULE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`krtt`.`krms_agenda_itm_t`, CONSTRAINT `KRMS_AGENDA_ITM_FK1` FOREIGN KEY (`RULE_ID`) REFERENCES `krms_rule_t` (`RULE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION)

        Issue Links

          Activity

          Hide
          Claus Niesen added a comment -

          Jeremy was able to reproduce this issue in KPME. The rules in KPME are shared between agendas. KRMS doesn't support the sharing of rules. If rules are shared then this error will occur.

          Show
          Claus Niesen added a comment - Jeremy was able to reproduce this issue in KPME. The rules in KPME are shared between agendas. KRMS doesn't support the sharing of rules. If rules are shared then this error will occur.

            People

            • Assignee:
              Claus Niesen
              Reporter:
              Jeremy Hanson
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel