<div dir="ltr"><div>We are experiencing something similar with 1.0.7.1.</div><div><br></div><div>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:</div>
<div><br></div><div><span style="color:rgb(185,74,72);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:13px;line-height:20px;background-color:rgb(242,222,222)">translation missing: <a href="http://en.no">en.no</a> key -</span><br>
</div><div><br></div><div>This log output includes the SQL constraint error. </div><div><br></div><div>We'd be happy to help narrow this down if that would be useful.</div><div><br></div><div>in", :login_time=>2014-03-31 11:25:08 -0400, :expirable=>true}, @id="dd1c8c2d4f851d57fe3cdc754ee54a9d0bddddd31f1df8f34ea2f885d7dd91b6">]</div>
<div>D, [2014-03-31T11:31:37.078000 #29151] DEBUG -- : Thread-379022: Post-processed params: {}</div><div>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</div>
<div>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">]</div>
<div>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}</div>
<div>E, [2014-03-31T11:31:38.143000 #29151] ERROR -- :</div><div>Java::JavaSql::SQLIntegrityConstraintViolationException: DELETE on table 'INSTANCE' caused a violation of foreign key constraint 'SQL140307155144480' for key (9). The statement has been rolled back.</div>
<div>org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)</div><div>org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)</div><div>org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)</div>
<div>org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)</div><div>org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)</div><div>org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)</div>
<div>org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)</div><div>org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)</div><div>org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)</div>
<div>sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)</div><div>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div>java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)</div><div>org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316)</div><div>org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:61)</div>
<div>org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168)</div><div>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)</div>
<div>rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__.call(rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__)</div>
<div>org.jruby.runtime.CompiledBlock19.yieldSpecificInternal(CompiledBlock19.java:117)</div><div>org.jruby.runtime.CompiledBlock19.yieldSpecific(CompiledBlock19.java:92)</div><div>org.jruby.runtime.Block.yieldSpecific(Block.java:111)</div>
<div>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)</div><div>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)</div>
<div>org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:42)</div><div>:</div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Mar 26, 2014 at 11:47 AM, Jacob, Diane B. <span dir="ltr"><<a href="mailto:JacobDB@vmi.edu" target="_blank">JacobDB@vmi.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Helvetica,sans-serif;color:rgb(185,74,72);background-color:rgb(242,222,222)">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><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks, Diane<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Diane B. Jacob<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Head, Archives & Records Management<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Virginia Military Institute<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Preston Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Lexington, VA 24450<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="tel:540-464-7566" value="+15404647566" target="_blank">540-464-7566</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="http://www.vmi.edu/archives" target="_blank"><span style="color:blue">www.vmi.edu/archives</span></a><u></u><u></u></span></p>
</div>
</div>
</div>
<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><br>
<br></blockquote></div><br></div></div>