[Archivesspace_Users_Group] Database Integrity Constraint Error on Agent Save

Joshua D. Shaw Joshua.D.Shaw at dartmouth.edu
Fri Aug 28 16:56:40 EDT 2015

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.


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

More information about the Archivesspace_Users_Group mailing list