[Archivesspace_Users_Group] Error message in saving record

Mon Mar 31 15:07:15 EDT 2014

Brad and all, thanks.

I'll start perusing the Pivotal issues more closely from now on.

On Mon, Mar 31, 2014 at 2:54 PM, Brad Westbrook
<brad.westbrook at lyrasis.org>wrote:

>  Hi, Michael.
>
>
>
> 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
> https://www.pivotaltracker.com/story/show/68437254.
>
>
>
> Brad W.
>
>
>
>
>
> Bradley D. Westbrook
>
> Program Manager
>
> brad.westbrook at lyrasis.org <brad at archivesspace.org>
>
> 800.999.8558 x2910
>
> 678.235.2910
>
> bradley_d_westbrook (Skype)
>
> [image: cid:image003.png at 01CE734E.FD759D30]
>
>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Levy,
> Michael
> *Sent:* Monday, March 31, 2014 11:43 AM
> *To:* Archivesspace Users Group
> *Subject:* Re: [Archivesspace_Users_Group] Error message in saving record
>
>
>
> We are experiencing something similar with 1.0.7.1.
>
>
>
> 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:
>
>
>
> translation missing: en.no key -
>
>
>
> This log output includes the SQL constraint error.
>
>
>
> We'd be happy to help narrow this down if that would be useful.
>
>
>
> in", :login_time=>2014-03-31 11:25:08 -0400, :expirable=>true},
> @id="dd1c8c2d4f851d57fe3cdc754ee54a9d0bddddd31f1df8f34ea2f885d7dd91b6">]
>
> D, [2014-03-31T11:31:37.078000 #29151] DEBUG -- : Thread-379022:
> Post-processed params: {}
>
> 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
>
> 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">]
>
> 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}
>
> E, [2014-03-31T11:31:38.143000 #29151] ERROR -- :
>
> Java::JavaSql::SQLIntegrityConstraintViolationException: DELETE on table
> 'INSTANCE' caused a violation of foreign key constraint
> 'SQL140307155144480' for key (9).  The statement has been rolled back.
>
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
>
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
>
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
>
> org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
>
> sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
>
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:597)
>
>
> org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)
>
> org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316)
>
>
> org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:61)
>
> org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168)
>
>
> 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)
>
>
> rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__.call(rubyjit$Sequel::JDBC::Database$$execute_BA39EE6C9DF8254AA4544BFB9356606B35D67A19$block_6$RUBY$__file__)
>
>
> org.jruby.runtime.CompiledBlock19.yieldSpecificInternal(CompiledBlock19.java:117)
>
> org.jruby.runtime.CompiledBlock19.yieldSpecific(CompiledBlock19.java:92)
>
> org.jruby.runtime.Block.yieldSpecific(Block.java:111)
>
>
> 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)
>
>
> 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)
>
> org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:42)
>
> :
>
>
>
>
>
> On Wed, Mar 26, 2014 at 11:47 AM, Jacob, Diane B. <JacobDB at vmi.edu> wrote:
>
> 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?
>
>
>
> translation missing: en.no 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`))
>
>
>
> Thanks, Diane
>
>
>
> Diane B. Jacob
>
> Head, Archives & Records Management
>
> Virginia Military Institute
>
> Preston Library
>
> Lexington, VA 24450
>
> 540-464-7566
>
> www.vmi.edu/archives
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>
>
> _______________________________________________
> 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/20140331/cf101ab0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 7645 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20140331/cf101ab0/attachment.png>