<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi there,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I've been working on upgrading our test ArchivesSpace instance from v2.8.1 to v3.1.1. The database migrations all appear to have run correctly, and the site starts fine, but when I triggered a reindex the indexer logs are filled with stack traces of the following
sort (abbreviated for brevity):</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
E, [2022-02-01T17:25:28.067043 #9213] ERROR -- : Thread-2024: Failed fetching resource id=1: {"error":"Couldn't find enum in begin_date_standardized_type for StructuredDateRange with id 3194:
<div>/opt/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/dynamic_enums.rb:51:in `block in uses_enums'</div>
<div>/opt/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/dynamic_enums.rb:66:in `block in uses_enums'</div>
<div>org/jruby/RubyArray.java:1809:in `each'</div>
<div>/opt/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/dynamic_enums.rb:64:in `block in uses_enums'</div>
/opt/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/nested_record_resolver.rb:39:in `block in do_resolve'</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I've checked the enumeration_value table, and there are no values with id = 3194, if that's relevant. All of the entries in our structured_date_range table have this value (3194), for both begin_ and end_date_standardized_type_id:<br>
<br>
<span style="font-family: Consolas, Courier, monospace;">> select distinct begin_date_standardized_type_id, end_date_standardized_type_id from structured_date_range;</span>
<div><span style="font-family: Consolas, Courier, monospace;">+---------------------------------+-------------------------------+</span></div>
<div><span style="font-family: Consolas, Courier, monospace;">| begin_date_standardized_type_id | end_date_standardized_type_id |</span></div>
<div><span style="font-family: Consolas, Courier, monospace;">+---------------------------------+-------------------------------+</span></div>
<div><span style="font-family: Consolas, Courier, monospace;">| 3194 | 3194 |</span></div>
<div><span style="font-family: Consolas, Courier, monospace;">+---------------------------------+-------------------------------+</span></div>
<span>1 row in set (0.043 sec)</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I'm not sure where to begin troubleshooting this - any advice is greatly appreciated!</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Many thanks,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Nick<br>
</div>
</body>
</html>