Epic to link all support issues located in Dev projects (SUP-12)

[SUP-19] Unable to delete duplicate agreement with supplementary document Created: 29/Aug/20  Updated: 28/Sep/20  Resolved: 28/Sep/20

Status: Closed
Project: Support
Components: Agreements
Affects versions: None
Fix versions: None
Parent: Epic to link all support issues located in Dev projects

Type: Bug Priority: P2
Reporter: Carole Godfrey Assignee: Owen Stephens
Resolution: Duplicate Votes: 0
Labels: agreements, erm, support
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: GIF File 2020-08-29 19.07.45.gif     PNG File Screen Shot 2020-08-29 at 6.50.43 PM.png     PNG File Screen Shot 2020-08-29 at 6.51.43 PM.png     PNG File Screen Shot 2020-09-11 at 10.34.36.png    
Issue links:
Relates
relates to ERM-1114 Duplicating an Agreement with Supplem... Closed
Sprint:
Development Team: Bienenvolk
Affected Institution:
5 Colleges
Epic Link: Epic to link all support issues located in Dev projects

 Description   

Overview:
Steps to Reproduce:

  1. Log into https://folio-snapshot.dev.folio.org/ environment as diku_admin
  2. Create a new agreement with a supplemental document (supplemental document has name, file and url populated only)
  3. From Actions menu, Duplicate newly created agreement (select all)
  4. Save and Close (observe error - page unstable)
  5. Duplicate agreement does get created
  6. Attempt to delete duplicate agreement
  7. Observe error regarding foreign key constraint
  8. ERROR: update or delete on table ""document_attachment"" violates foreign key constraint ""sasd_to_da_fk"" on table ""subscription_agreement_supp_doc
  9. Further attempts to edit duplicate agreement or original agreement (observe error - page unstable)

Expected Results:
Duplicate Agreement can be deleted

Actual Results:
Agreement cannot be deleted

Additional Information:
this is observed in Goldenrod
see attached animated gif

URL:
Interested parties: Aaron Neslin



 Comments   
Comment by Owen Stephens [ 11/Sep/20 ]

Carole Godfrey Aaron Neslin please note that I think the bug is more than simply not being able to delete the duplicate agreement. The issue (I believe at this time - but please use ERM-1114 Closed to track our work on this, in case my initial analysis is incorrect) is that the duplicated Agreement and the original agreement are both using the same Supplementary Document record. This means not only will deletion not work (you can't delete the agreement because it tries to delete the supplementary document which is being used by another agreement) but that edits to the supplementary document in one agreement are affecting the supplementary document on both agreements (because there is only one supplementary document - you are editing the same doc from two places).

Until this issue is resolved I'd recommend that when duplicating Agreements users should ensure they do not check the "Supplementary Information" option in the the Duplicate Agreement dialogue

Comment by Kelly Drake [ 28/Sep/20 ]

Actually - ERM-1114 Closed

Generated at Thu Feb 08 22:21:11 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.