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: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: 2.0.4
    • Labels:
      None
    • Account:
      Maintenance 2016 (MAINTENANCE2016)

      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

        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

              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