<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Tahoma, sans-serif;">
<div>
<div>
<div>Thanks, Brian. I'll try and reproduce and report back if I can.</div>
<div><br>
</div>
<div>Joshua</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:12pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Brian Hoffman<br>
<span style="font-weight:bold">Reply-To: </span>Archivesspace Users Group<br>
<span style="font-weight:bold">Date: </span>Sunday, August 30, 2015 at 8:16 AM<br>
<span style="font-weight:bold">To: </span>Archivesspace Users Group<br>
<span style="font-weight:bold">Subject: </span>Re: [Archivesspace_Users_Group] Database Integrity Constraint Error on Agent Save<br>
</div>
<div><br>
</div>
<div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
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?
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Aug 28, 2015, at 4:56 PM, Joshua D. Shaw <<a href="mailto:Joshua.D.Shaw@dartmouth.edu" class="">Joshua.D.Shaw@dartmouth.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class=""><font face="Tahoma,sans-serif" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class="">Has anyone seen the following error? </span></font></div>
<div class=""><font face="Tahoma,sans-serif" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class=""><br class="">
</span></font></div>
<div class=""><font face="Helvetica Neue,Helvetica,Arial,sans-serif" style="font-size: 14px;" class=""><span style="line-height: 20px;" class="">Error: </span></font><span style="font-size: 14px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 20px;" class="">en.validation_errors.database_integrity_constraint_conflict__java__javasql__sqlexception__field__number__doesn_t_have_a_default_value</span></div>
<div class=""><font face="Tahoma,sans-serif" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class=""><br class="">
</span></font></div>
<div class=""><font face="Tahoma,sans-serif" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class="">This occurred when a user attempted to save an agent while creating a resources - </span></font><span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 20px;" class="">i.e.</span><font face="Helvetica Neue,Helvetica,Arial,sans-serif" style="font-family: Tahoma, sans-serif;" class=""><span style="line-height: 20px;" class=""> the
agent was created in the process of creating the resource.</span></font></div>
<div class=""><span style="font-family: Tahoma, sans-serif; line-height: 20px;" class=""><br class="">
</span></div>
<div class=""><span style="font-family: Tahoma, sans-serif; line-height: 20px;" class="">The</span><font face="Tahoma,sans-serif" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class=""> error
*may* be </span></font><span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 20px;" class="">related</span><font face="Helvetica Neue,Helvetica,Arial,sans-serif" style="font-family: Tahoma, sans-serif;" class=""><span style="line-height: 20px;" class=""> 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." </span></font><span style="font-family: Tahoma, sans-serif; line-height: 20px;" class="">I</span><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><font face="Tahoma,sans-serif" class=""><span style="line-height: 20px;" class="">'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.
</span></font></font><font style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="line-height: 20px;" class="">Unfortunately, </span></font><span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 20px;" class="">I</span><font face="Helvetica Neue,Helvetica,Arial,sans-serif" style="font-family: Tahoma, sans-serif;" class=""><span style="line-height: 20px;" class=""> haven't
been able to </span></font><span style="font-family: Tahoma, sans-serif; line-height: 20px;" class="">replicate</span><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><font face="Tahoma,sans-serif" class=""><span style="line-height: 20px;" class=""> this
issue, so its just </span></font><span style="line-height: 20px;" class="">the</span><font face="Tahoma,sans-serif" class=""><span style="line-height: 20px;" class=""> one data point:-(</span></font></font></div>
<div class=""><br class="">
</div>
<div class=""><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><font face="Tahoma,sans-serif" class=""><span style="line-height: 20px;" class="">We are running at 1.3.0 *without* the latest performance patches.</span></font></font></div>
<div class=""><br class="">
</div>
<div style="font-family: Tahoma, sans-serif; font-size: 14px;" class=""><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><span style="line-height: 20px;" class="">Thanks!</span></font></div>
<div style="font-family: Tahoma, sans-serif; font-size: 14px;" class=""><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><span style="line-height: 20px;" class="">Joshua</span></font></div>
<div style="font-family: Tahoma, sans-serif; font-size: 14px;" class=""><font face="Helvetica Neue,Helvetica,Arial,sans-serif" class=""><span style="line-height: 20px;" class=""><br class="">
</span></font></div>
<div style="font-family: Tahoma, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div style="font-family: Tahoma, sans-serif; font-size: 14px;" class="">
<div id="" class=""></div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</span>
</body>
</html>