[Archivesspace_Users_Group] Database Integrity Constraint Error on Agent Save

Joshua D. Shaw Joshua.D.Shaw at dartmouth.edu
Wed Sep 2 13:24:50 EDT 2015


Thanks, Brian. I'll try and reproduce and report back if I can.

Joshua

From: Brian Hoffman
Reply-To: Archivesspace Users Group
Date: Sunday, August 30, 2015 at 8:16 AM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Database Integrity Constraint Error on Agent Save

Yes, I think this is related to the number field of the telephone table. Are you able to create the same agent record out of the context of the resource record? If you are able to reproduce this from a blank agent record, could you record the steps and file a bug?


On Aug 28, 2015, at 4:56 PM, Joshua D. Shaw <Joshua.D.Shaw at dartmouth.edu<mailto:Joshua.D.Shaw at dartmouth.edu>> wrote:

Has anyone seen the following error?

Error: en.validation_errors.database_integrity_constraint_conflict__java__javasql__sqlexception__field__number__doesn_t_have_a_default_value

This occurred when a user attempted to save an agent while creating a resources - i.e. the agent was created in the process of creating the resource.

The error *may* be related to a plugin we had developed for us by Hudson-Molonglo, but the error is so unspecific its *very* difficult to tell exactly what caused the issue and none of the fields in the tables used by that plugin are named "number." I'm leaning toward the telephone table (the subsection of contact details) as the culprit since it does have a field "number" that does not have a default value set. Unfortunately, I haven't been able to replicate this issue, so its just the one data point:-(

We are running at 1.3.0 *without* the latest performance patches.

Thanks!
Joshua


_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150902/f197cfd2/attachment.html>


More information about the Archivesspace_Users_Group mailing list