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

[Jared Campbell]

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
>