Re: [Archivesspace_Users_Group] Container instance types

2023-03-28 Thread Hand, Sarit 
Hi Miriam,

We have been using "mixed materials" until recently for just about everything 
regardless of the content. However, I just completed a move which included 
getting container level control for barcoding. I had a few collections of 
homogeneous content, i.e. audiovisual, and artifacts. In those cases, I added 
audiovisual to the value list and assigned that to the containers and for 
artifacts I used physical object. All the while, I have been asking myself why 
the heck instance type was a requirement for creating or linking a container 
when it does not describe the container at all, the description is more 
relevant to the archival object record and not the instance. It would make more 
sense to relegate that data in a descriptive field not tied to the container.

I cannot say for certain, but it looks to me that the Instance type is not 
stored as part of the container record as that data only appears in the record 
for the resource/component. If you look at the Container record, you only see 
"container type" not instance type. If you were to unlink the container record, 
you lose the instance type data even if you do not delete the container record 
itself.

The short answer, the instance type really isn't about the container but about 
the "thing(s)" the record is describing and are being put into the container. 
So, even if the container is shared, one record might indicate it is 
audiovisual, and another record linked to the same container might be text.

Hope this helps.

Cheers,

[cid:image001.png@01D961C5.E0A76A60]

Sarit Hand
Digital Archivist
AP Corporate Archives
200 Liberty Street
New York, NY 10281
T 212.621.7035

sh...@ap.org
ap.org
[cid:image002.png@01D961C5.E0A76A60]


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Mariam 
Yamin
Sent: Tuesday, March 28, 2023 11:24 AM
To: Archivesspace Users Group 
Subject: [Archivesspace_Users_Group] Container instance types


[EXTERNAL]
Hi all,

I wondered if anyone could share how they use container instance types in their 
organisation?

We are just starting to add container instances, and are a bit unsure about the 
purpose of instance types, as the format of the material being assigned to a 
top container would be included in the description of the archival object?

I can see from other organisations' PUIs that many seem to use 'Mixed 
Materials' for all records. We may end up doing this, but I'd be interested to 
know if anyone uses different instance types for different types of materials, 
eg text, graphic materials, audio-visual etc, and if they see any benefit in 
doing this?

Any advice would be much appreciated.

best wishes,

Mariam

--
Mariam Yamin
Archivist
Special Collections, Heritage, and Archives
University of Sheffield | Western Bank Library | Sheffield | S10 2TN
0114 222 7236
m.ya...@sheffield.ac.uk

https://www.sheffield.ac.uk/library/special-collections-heritage-and-archives

My usual days of work are Tuesdays, Wednesdays and Thursdays.
The information contained in this communication is intended for the use of the 
designated recipients named above. If the reader of this communication is not 
the intended recipient, you are hereby notified that you have received this 
communication in error, and that any review, dissemination, distribution or 
copying of this communication is strictly prohibited. If you have received this 
communication in error, please notify The Associated Press immediately by 
telephone at +1-212-621-1500 and delete this email. Thank you.
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

[Archivesspace_Users_Group] Container instance types

2023-03-28 Thread Mariam Yamin 
Hi all,

I wondered if anyone could share how they use container instance types in
their organisation?

We are just starting to add container instances, and are a bit unsure about
the purpose of instance types, as the format of the material being assigned
to a top container would be included in the description of the archival
object?

I can see from other organisations' PUIs that many seem to use 'Mixed
Materials' for all records. We may end up doing this, but I'd be
interested to know if anyone uses different instance types for different
types of materials, eg text, graphic materials, audio-visual etc, and if
they see any benefit in doing this?

Any advice would be much appreciated.

best wishes,

Mariam

-- 
Mariam Yamin
Archivist
Special Collections, Heritage, and Archives
University of Sheffield | Western Bank Library | Sheffield | S10 2TN
0114 222 7236
m.ya...@sheffield.ac.uk

https://www.sheffield.ac.uk/library/special-collections-heritage-and-archives

My usual days of work are Tuesdays, Wednesdays and Thursdays.
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2

2023-03-28 Thread Blake Carver 
It looks like there's a bad date hiding somewhere else. It's ALMOST always in 
the user table, but not always always.

Try something like:

https://gist.github.com/Blake-/d493da28be5554a49a3a3835bbd98f05

https://gist.github.com/Blake-/3c133ec7e42d039d85afbad5b3089eb4

You can update that year-month-day on those and see if you can find something.

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 on behalf of Philip 
Webster 
Sent: Tuesday, March 28, 2023 7:07 AM
To: 'Archivesspace Users Group' 

Subject: Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2


Hi,

Ran into this yesterday, and I ran the SQL UPDATE query – I got a report of 4 
rows affected, but now our AS instance won’t start up due to initialisation 
errors. We are getting the same error as before.



Here is the console interaction for SQL:

mysql> UPDATE user set user_mtime = NOW(), system_mtime=NOW();

Query OK, 4 rows affected (0.01 sec)

Rows matched: 4  Changed: 4  Warnings: 0



Here is the stack trace (first few lines):

Mar 28, 2023 12:00:08 PM 
org.eclipse.jetty.server.handler.ContextHandler$Context log

WARNING: ERROR: initialization failed

org.jruby.rack.RackInitializationException: Java::JavaSql::SQLException: 
HOUR_OF_DAY: 1 -> 2

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:129)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:97)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:89)

   from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:63)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:73)

from 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(com/mysql/cj/jdbc/exceptions/SQLExceptionsMapping.java:85)

from 
com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(com/mysql/cj/jdbc/result/ResultSetImpl.java:947)

from java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)

from 
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:456)

from 
org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:317)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther0:getTimestamp(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.timestamp_convert(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)

from org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:123)

from 
org.jruby.RubyMethod$INVOKER$i$call.call(org/jruby/RubyMethod$INVOKER$i$call.gen)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther9:call(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.process_result_set(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)

from org.jruby.RubyArray.each(org/jruby/RubyArray.java:1809)



This is affecting a production service, so I may have to raise a technical 
support request if there isn’t a community solution.



Regards,



Philip Webster

The University of Sheffield





From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Andrew 
Morrison
Sent: 27 March 2023 09:07
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2



A reminder to anyone in Europe, whose clocks changed this weekend, to check 
your ArchivesSpace system. If everything but the home page isn't working, try 
the fix below...



Andrew.





On 12/03/2023 19:57, Blake Carver wrote:



It's that time of year again! If ArchivesSpace isn't working for you today, 
check the logs... If you see

DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2



Try this and restart, that'll probably do the trick.



UPDATE user set user_mtime = NOW(), system_mtime=NOW();






___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2

2023-03-28 Thread Philip Webster 
Hi,

Ran into this yesterday, and I ran the SQL UPDATE query – I got a report of 4 
rows affected, but now our AS instance won’t start up due to initialisation 
errors. We are getting the same error as before.

 

Here is the console interaction for SQL:

mysql> UPDATE user set user_mtime = NOW(), system_mtime=NOW();

Query OK, 4 rows affected (0.01 sec)

Rows matched: 4  Changed: 4  Warnings: 0

 

Here is the stack trace (first few lines):

Mar 28, 2023 12:00:08 PM 
org.eclipse.jetty.server.handler.ContextHandler$Context log

WARNING: ERROR: initialization failed

org.jruby.rack.RackInitializationException: Java::JavaSql::SQLException: 
HOUR_OF_DAY: 1 -> 2

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:129)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:97)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:89)

   from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:63)

from 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:73)

from 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(com/mysql/cj/jdbc/exceptions/SQLExceptionsMapping.java:85)

from 
com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(com/mysql/cj/jdbc/result/ResultSetImpl.java:947)

from java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)

from 
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:456)

from 
org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:317)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther0:getTimestamp(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.timestamp_convert(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)

from org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:123)

from 
org.jruby.RubyMethod$INVOKER$i$call.call(org/jruby/RubyMethod$INVOKER$i$call.gen)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther9:call(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)

from 
home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.process_result_set(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)

from org.jruby.RubyArray.each(org/jruby/RubyArray.java:1809)

 

This is affecting a production service, so I may have to raise a technical 
support request if there isn’t a community solution.

 

Regards,

 

Philip Webster

The University of Sheffield

 

 

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Andrew 
Morrison
Sent: 27 March 2023 09:07
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2

 

A reminder to anyone in Europe, whose clocks changed this weekend, to check 
your ArchivesSpace system. If everything but the home page isn't working, try 
the fix below...

 

Andrew.

 

 

On 12/03/2023 19:57, Blake Carver wrote:

 

It's that time of year again! If ArchivesSpace isn't working for you today, 
check the logs... If you see

DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2

 

Try this and restart, that'll probably do the trick. 

 

UPDATE user set user_mtime = NOW(), system_mtime=NOW();

 

 

 

___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] ArchivesSpace weird behavior

2023-03-28 Thread Andrew Morrison 
Do any staff users share a login and password? And are there any error 
messages in the logs from the time of the most recent incident?


Andrew.


On 27/03/2023 21:08, Galligan, Patrick wrote:


Hi all,

We've run across a new (to me) issue in ArchivesSpace that I wanted to 
see if anyone else had encountered before: very sporadically AS will 
redirect an archivist to a different archival object after saving work 
in a finding aid in the Staff Interface. The changes will be saved and 
reflected, but the user will be taken to a different object instead of 
staying on the same one as intended. This is apparently happening at 
random, and not consistently happening on every finding aid or for 
every user, which makes it hard to troubleshoot.


Anyone run into this before? Have any solutions or thoughts? It seems 
to happen most often with large finding aids.


Thanks,

Patrick Galligan

Rockefeller Archive Center


___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group