Uploaded image for project: 'AuditMessage'
  1. AuditMessage
  2. AUDITVAL-83

Edition of unsaved constraint duplicates the entries in the list

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.0.4
    • Labels:
      None
    • Sprint:
      2016 - S12
    • Account:
      Maintenance 2016 (MAINTENANCE2016)
    • Story Points:
      3

      Description

      When you edit an Audit Message validator, you can add constraints; the latter are not saved when you add them but when you click on "Save" button.
      I got a "Transaction failed" error message when trying to save my validator. Here are the step to reproduce:

      1. Create a new constraint (DO NOT SAVE)
      2. Edit the newly created constraint
      => A new entry is added, the two versions of the constraint have exactly the same content (see screenshot)
      3. Save
      => Boum: Transaction Failed and the Jboss logs indicate that there is a duplicate key in DB

      Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "am_audit_message_specificatio_extraconstraintspecifications_key"
        Détail : Key (extraconstraintspecifications_id)=(544) already exists.

      Work around: Remove one of the duplicated constraints before saving

        BigPicture - Work Breakdown Structure

          Attachments

            Activity

              People

              Assignee:
              ceoche Cédric EOCHE-DUVAL
              Reporter:
              aberge Anne-Gaelle Berge
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                BigPicture - Skills

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - 4 hours
                    4h
                    Remaining:
                    Time Spent - 1 hour, 15 minutes Remaining Estimate - 2 hours, 45 minutes
                    2h 45m
                    Logged:
                    Time Spent - 1 hour, 15 minutes Remaining Estimate - 2 hours, 45 minutes
                    1h 15m

                      Potential Duplicates