<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi, Michael.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">This is a known bug and will be fixed in the next release, which we are closing in on finishing. You can see the user story at
<a href="https://www.pivotaltracker.com/story/show/68437254">https://www.pivotaltracker.com/story/show/68437254</a>.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Brad W.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D">Bradley D. Westbrook<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D">Program Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D"><a href="mailto:brad@archivesspace.org"><span style="color:#1F497D">brad.westbrook@lyrasis.org</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D">800.999.8558 x2910<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D">678.235.2910<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D">bradley_d_westbrook (Skype) </span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:black"><img border="0" width="199" height="55" id="Picture_x0020_1" src="cid:image001.png@01CF4CF1.03943E70" alt="cid:image003.png@01CE734E.FD759D30"></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Levy, Michael<br>
<b>Sent:</b> Monday, March 31, 2014 11:43 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Error message in saving record<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">We are experiencing something similar with 1.0.7.1.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">We created an item, added an instance and a digital object, saved it with no problems. Then we tried to remove the digital object and got this error message:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif";color:#B94A48;background:#F2DEDE">translation missing:
<a href="http://en.no">en.no</a> key -</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">This log output includes the SQL constraint error. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">We'd be happy to help narrow this down if that would be useful.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">in", :login_time=>2014-03-31 11:25:08 -0400, :expirable=>true}, @id="dd1c8c2d4f851d57fe3cdc754ee54a9d0bddddd31f1df8f34ea2f885d7dd91b6">]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">D, [2014-03-31T11:31:37.078000 #29151] DEBUG -- : Thread-379022: Post-processed params: {}<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">D, [2014-03-31T11:31:37.578000 #29151] DEBUG -- : Thread-379022: Responded with [200, {"Content-Type"=>"application/json", "Cache-Control"=>"private, must-revalidate, max-age=0", "Content-Length"=>"25577"}, ["[{\"lock_version\":0,\"name\":\"linked_agent_archival_record_relators\",\"editable\":true,\"create_time\":\"2014-03-07T20:52:11Z\",\"system_mtime\":\"2014-03-07T20:52:11Z\",\"user_mtime\":\"2014-03-07T20:52:11Z\",\"jsonmodel_type\":\"enumeration\",\"values\":[\"acp\",\"act\",\"adp\",\"aft\",\"anl\",\"anm\",\"ann\",\"ant\",\"app\",\"aqt\",\"arc\",\"ard\",\"arr\",\"art\",\"asg\",\"as...
in 518.0ms<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">D, [2014-03-31T11:31:37.663000 #29151] DEBUG -- : Thread-378916: POST /repositories/2/archival_objects/2 [session: #<Session:0x4775fe3b @store={:user=>"admin", :login_time=>2014-03-31 11:25:08 -0400, :expirable=>true}, @id="dd1c8c2d4f851d57fe3cdc754ee54a9d0bddddd31f1df8f34ea2f885d7dd91b6">]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">D, [2014-03-31T11:31:37.697000 #29151] DEBUG -- : Thread-378916: Post-processed params: {:id=>2, :archival_object=>#<JSONModel(:archival_object) {"lock_version"=>"1", "resource"=>{"ref"=>"/repositories/2/resources/1"}, "position"=>0, "title"=>"one
page letter from Josef Broniatowski to the Perloff family about the problem with the affidavit in his immigration application", "ref_id"=>"67c485e3e79e1d23ac23207a18c4615e", "level"=>"item", "publish"=>true, "dates"=>[{"lock_version"=>"0", "label"=>"other",
"expression"=>"July 14, 1938", "date_type"=>"single"}], "instances"=>[{"lock_version"=>"0", "instance_type"=>"text", "container"=>{"lock_version"=>"0", "type_1"=>"folder", "indicator_1"=>"1", "container_locations"=>[]}}, {"lock_version"=>"0", "instance_type"=>"digital_object",
"digital_object"=>{"ref"=>"/repositories/2/digital_objects/1"}}], "restrictions_apply"=>false, "jsonmodel_type"=>"archival_object", "external_ids"=>[], "subjects"=>[], "extents"=>[], "external_documents"=>[], "rights_statements"=>[], "linked_agents"=>[], "notes"=>[],
"linked_events"=>[], "component_id"=>""}>, :repo_id=>2}<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">E, [2014-03-31T11:31:38.143000 #29151] ERROR -- :<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Java::JavaSql::SQLIntegrityConstraintViolationException: DELETE on table 'INSTANCE' caused a violation of foreign key constraint 'SQL140307155144480' for key (9). The statement has been rolled back.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">java.lang.reflect.Method.invoke(Method.java:597)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:61)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">rubyjit.Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19.block_6$RUBY$__file__(/data/sites/apps/public/archivesspace-v1.0.7.1/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:266)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__.call(rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.runtime.CompiledBlock19.yieldSpecificInternal(CompiledBlock19.java:117)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.runtime.CompiledBlock19.yieldSpecific(CompiledBlock19.java:92)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.runtime.Block.yieldSpecific(Block.java:111)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">rubyjit.Sequel::Database$$log_yield_639CF3E5DAF05FE8E8A5DE26EB5A99A37DE0E0B6.__file__(/data/sites/apps/public/archivesspace-v1.0.7.1/gems/gems/sequel-3.41.0/lib/sequel/database/logging.rb:33)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">rubyjit.Sequel::Database$$log_yield_639CF3E5DAF05FE8E8A5DE26EB5A99A37DE0E0B6.__file__(/data/sites/apps/public/archivesspace-v1.0.7.1/gems/gems/sequel-3.41.0/lib/sequel/database/logging.rb)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:42)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Mar 26, 2014 at 11:47 AM, Jacob, Diane B. <<a href="mailto:JacobDB@vmi.edu" target="_blank">JacobDB@vmi.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’m having trouble saving a record. This occurred after I was adding two instances – one physical,
and one digital object. I added the digital object first, saved the record, and all was well. After I added the second instance, I received the error. I have deleted the record and created it again, but the same pattern occurs. Can someone help explain
what’s happening here?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Helvetica","sans-serif";color:#B94A48;background:#F2DEDE">translation missing:
<a href="http://en.no" target="_blank">en.no</a> key - translation missing: en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__cannot_delete_or_update_a_parent_row__a_foreign_key_constraint_fails_(`archivesspaceram`.`instance_do_link_rlshp`__constraint_`instance_do_link_rlshp_ibfk_2`_foreign_key_(`instance_id`)_references_`instance`_(`id`))</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thanks, Diane</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Diane B. Jacob</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Head, Archives & Records Management</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Virginia Military Institute</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Preston Library</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Lexington, VA 24450</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="tel:540-464-7566" target="_blank">540-464-7566</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://www.vmi.edu/archives" target="_blank">www.vmi.edu/archives</a></span><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>