[Archivesspace_Users_Group] Event Outcome Problems

[Tang, Lydia]

Hi all,
James created a Jira ticket for this bug here: https://archivesspace.atlassian.net/browse/ANW-778
Thanks, James!
Here is information on how to report bugs: https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/19202056/How+to+Report+a+Bug
Thanks for helping to make ArchivesSpace better!
Lydia

  *   On behalf of the Development Prioritization subteam

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of "Shaun D. Ellis" <shaune at Princeton.EDU>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Friday, September 28, 2018 at 10:04 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Event Outcome Problems

This sounds like a bug to me. Is there some place other than this list where it should be reported?

It seems to me that the solution is to place a database constraint on that field, so that NULL values can’t be used for foreign keys, but perhaps there is more to the issue?

Shaun Ellis
--
UX Web Developer / Frontend Engineer

Princeton University Library<https://urldefense.proofpoint.com/v2/url?u=https-3A__library.princeton.edu_&d=DwMGaQ&c=nE__W8dFE-shTxStwXtp0A&r=lG1-HSCEGsZJf-_mV6BDLh4PvkC3fOv47rKbM_dbh1g&m=im6M55HYOrU2Y-XFxIlcv0bNrFOlfN40CWtoyMHAYXE&s=gBaXSjESo6uLnCV83ypH4IWDqOrfcOKmC3wLJGiwgHA&e=>

Princeton, NJ 08544


From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Jenn Colt <jrc88 at cornell.edu>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Date: Thursday, September 27, 2018 at 9:54 AM
To: "archivesspace_users_group at lyralists.lyrasis.org" <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Event Outcome Problems


I'm seeing this as well when I make a new event but leave the outcome blank.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of James R Griffin III <jrg5 at princeton.edu>
Sent: Tuesday, September 25, 2018 2:36:25 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Event Outcome Problems


Hello Everyone,



Please forgive any misunderstandings on my part, as I'm relatively new to this software and the project.



I'm currently working with an installation of ArchivesSpace which has been updated to 2.5.0, and I've encountered a problem in which Event "Outcome" values can be persisted into the database with NULL foreign keys:



[archivesspace]> select count(e.id<https://urldefense.proofpoint.com/v2/url?u=http-3A__e.id_&d=DwMGaQ&c=nE__W8dFE-shTxStwXtp0A&r=lG1-HSCEGsZJf-_mV6BDLh4PvkC3fOv47rKbM_dbh1g&m=im6M55HYOrU2Y-XFxIlcv0bNrFOlfN40CWtoyMHAYXE&s=DbThSkY_rNTDuhSK1Y1Xw_65LETITFkw3EenNUwY7gc&e=>) from event as e where e.outcome_id IS NULL;

+-------------+

| count(e.id<https://urldefense.proofpoint.com/v2/url?u=http-3A__e.id_&d=DwMGaQ&c=nE__W8dFE-shTxStwXtp0A&r=lG1-HSCEGsZJf-_mV6BDLh4PvkC3fOv47rKbM_dbh1g&m=im6M55HYOrU2Y-XFxIlcv0bNrFOlfN40CWtoyMHAYXE&s=DbThSkY_rNTDuhSK1Y1Xw_65LETITFkw3EenNUwY7gc&e=>) |

+-------------+

|       14324 |

+-------------+



Is this expected? When these are set as NULL, the corresponding enumeration_value cannot be retrieved for translation in the locale, leading to the following errors:



translation missing: enumerations.event_outcome.

...where the tag following enumerations.event_outcome (normally some value like pass or fail, as found in https://github.com/archivesspace/archivesspace/blob/v2.5.0/common/locales/enums/en.yml#L442<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_archivesspace_blob_v2.5.0_common_locales_enums_en.yml-23L442&d=DwMGaQ&c=nE__W8dFE-shTxStwXtp0A&r=lG1-HSCEGsZJf-_mV6BDLh4PvkC3fOv47rKbM_dbh1g&m=im6M55HYOrU2Y-XFxIlcv0bNrFOlfN40CWtoyMHAYXE&s=7XB5KW1El_YuUY4t2IYidlS3ZkQzgiBmiuFpIRUsA7M&e=>) is simply blank.

Is this something which others have encountered before? Might this be an issue which must be addressed with database record cleaning for these NULL foreign keys? Thank you for your time and support.

Sincerely,
James Griffin



--

Digital Infrastructure Developer

Princeton University Library<https://urldefense.proofpoint.com/v2/url?u=https-3A__library.princeton.edu_&d=DwMGaQ&c=nE__W8dFE-shTxStwXtp0A&r=lG1-HSCEGsZJf-_mV6BDLh4PvkC3fOv47rKbM_dbh1g&m=im6M55HYOrU2Y-XFxIlcv0bNrFOlfN40CWtoyMHAYXE&s=gBaXSjESo6uLnCV83ypH4IWDqOrfcOKmC3wLJGiwgHA&e=>

Princeton, NJ 08544