[Archivesspace_Users_Group] Database Integrity Constraint Error on Agent Save

[Brian Hoffman]

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> 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
> 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/20150830/0bc999a9/attachment.html>