[Archivesspace_Users_Group] ASpace fails when when Importing both MARCXML or EAD (SQL/Database Problem?)

[Brian Hoffman]

Hi Jared,

When you upgrade, you also need to upgrade the database (make sure you backup first). Instructions are here:

https://github.com/archivesspace/archivesspace/blob/master/UPGRADING.md#run-the-database-migrations

Brian


On Jun 24, 2015, at 7:51 PM, Jared Campbell <jlecampbell at ucdavis.edu> wrote:

> Hi Brian,
> 
> Just got done talking with my SysAdmin. 
> 
> The version field in the schema_info table is set to "36".
> 
> Neither table, job_created_record nor job_modified_record exist
> (this is what we suspected). Could the upgrade have failed to create them?
> 
> Jared
> 
> 
> Date: Wed, 24 Jun 2015 13:40:16 -0400
> From: Brian Hoffman <brianjhoffman at gmail.com>
> To: Archivesspace Users Group
>        <archivesspace_users_group at lyralists.lyrasis.org>
> Subject: Re: [Archivesspace_Users_Group] ASpace fails when when
>        Importing       both MARCXML or EAD (SQL/Database Problem?)
> Message-ID: <5DC51D53-556E-42B8-AD1B-63ED7AFF14EE at gmail.com>
> Content-Type: text/plain; charset="windows-1252"
> 
> Hi Jared,
> 
> Can you take a look at the ?schema_info? table and let me know the value in the ?version? column?
> 
> Also, there should be two tables in your database called ?job_created_record? and ?job_modified_record?. Both should have a column called ?record_uri?. Do those tables exist and have that column?
> 
> Brian
> 
> On Jun 23, 2015, at 6:11 PM, Jared Campbell <jlecampbell at ucdavis.edu> wrote:
> 
>> Hello Fellow ASpacers,
>> 
>> I am hoping that someone has seen this issue and can provide some insight.  We are currently running version 1.2 and every time that I try to import an EAD or MARCXML file I get the following error message:
>> 
>> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>> IMPORT ERROR
>> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>> 
>> 
>> Error: #<Sequel::Error: method record_uri= doesn't exist>
>> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>> 
>> When attempting to import an EAD file AS seems to successfully process the agents, subjects, series objects, and item/file objects records (see attached import error log and EAD file).
>> 
>> I get the same error message when I try to import a MARCXML file.
>> 
>> I am guessing that the script is looking--and not finding--"record_uri" in the database.  If this is correct, in what table would I find "record_uri"?
>> 
>> Thanks,
>> 
>> --JC
>> 
>> Jared L. Campbell
>> Metadata Librarian
>> Collection Support Services
>> Shields Library, UC Davis
>> jlecampbell at ucdavis.edu
>> (530) 754-7976
>> 
>