talk@lists.collectionspace.org

WE HAVE SUNSET THIS LISTSERV - Join us at collectionspace@lyrasislists.org

View all threads

Re: [Talk] Missing Term Lists

EG
Elayne Glantzberg
Thu, Apr 27, 2017 12:55 AM

So while we wait for developers to track down and squash this bug, is there anybody else here that has successfully cloned the core tenant in the current (v4.4) version of CollectionSpace? If so, can you tell me exactly how you did it? I'd really like to get my group up and running, whether it's by changing operating systems or tenant names or whatever it takes.

Thanks,

Elayne Glantzberg

Database Administrator

Aquarian Tabernacle Church

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Fri, April 21, 2017 7:23 pm
To: Elayne Glantzberg <solinox@solinoxenterprises.com>
Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org>

Was able to replicate what you're seeing, Elayne.

In the new 'atcmuseum' tenant (cloned from 'core') via the 'easy way' method, on an Ubuntu 14.04.05 VM on which an installation of CollectionSpace 4.4 was performed via the automated installer:

  1. Dynamic term lists are missing (in the left-hand list under Administration->Term List Management)

  2. Visiting the 'initialize' URL for this tenant yields multiple errors of the type:

*** ERROR *** CollectionSpace attempted to create a new<br></br>term list or term list item which had a non-unique short identifier.<br></br>

And also:

  1. Attempts to save authority records (like this Person record) also failed, as shown here:

Inline image 1

Will now look into the cause and how we can get this working ...

Thanks,

Aron

--

Initialise vocab/auth entries<br></br>testing authority person<br></br>need to create instance person-person<br></br><br></br>Summary:<br></br>*** ERROR *** CollectionSpace attempted to<br></br>create a new term list or term list item which<br></br>had a non-unique short identifier. New term<br></br>lists and/or term list items must have unique<br></br>short identifiers across all term lists:<br></br>The CollectionSpace administrator needs to change<br></br>the non-unique short identifier and restart CollectionSpace.<br></br><br></br><br></br>Detailed error code:<br></br>409<br></br>Request target:<br></br><a href="http://localhost:8180/cspace-services//personauthorities/" target="_blank">http://localhost:8180/cspace-services//personauthorities/</a><br></br>Detailed error message:<br></br>Connection exceptionorg.nuxeo.ecm.core.api.ConcurrentUpdateException:<br></br>Failed to save session: org.nuxeo.ecm.core.api.ConcurrentUpdateDocumentException:<br></br>org.nuxeo.ecm.core.storage.ConcurrentUpdateStorageException:<br></br>java.sql.BatchUpdateException: Batch entry 0 INSERT INTO<br></br>"personauthorities_common" ("id", "displayname", "sas", "shortidentifier",<br></br>"vocabtype", "source", "refname", "remoteclientconfigname", "description",<br></br>"rev") VALUES ('3bace7b0-451e-4511-8c6f-9cf1ac8bd798', 'Local Persons',<br></br>NULL, 'person', NULL, NULL,<br></br>'urn:cspace:<a href="http://museum.atcwicca.org">museum.atcwicca.org</a>:personauthorities:name(person)''Local Persons'''<br></br>, NULL, NULL, '0') was aborted.<br></br>Call getNextException to see the cause.

On Thu, Apr 20, 2017 at 8:28 PM, Aron Roberts <aron@socrates.berkeley.edu> wrote:

Cool - thanks, Elayne! Will try one or both methods tomorrow and we can then share experiences.

If I run into the same issue and can't resolve it for you, will work with others here at UC Berkeley or at LYRASIS to investigate ...

On Thu, Apr 20, 2017 at 8:07 PM, Elayne Glantzberg <solinox@solinoxenterprises.com> wrote:

The first time, I did it the long way. The second time, I did it the easy way. Both times cloning the core tenant.

On Apr 20, 2017 8:38 PM, Aron Roberts <aron@socrates.berkeley.edu> wrote:

I just got an installation of CSpace 4.4 completed on a VM, and plan to try to re-create your setup.

When you created your new tenant, did you use the 'easy' method? And if so, when tenant did you clone?

On Thu, Apr 20, 2017 at 5:12 PM, Elayne Glantzberg <solinox@solinoxenterprises.com> wrote:

Any luck yet? Is there a way I can manually enter new term lists, or import them from the Core, or something to get us up and running?

Thanks,

Elayne Glantzberg

Database Administrator

Aquarian Tabernacle Church

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Sun, April 16, 2017 1:18 pm
To: Elayne Glantzberg <solinox@solinoxenterprises.com>

Thanks, Elayne! I'll update you when I start working on this, and when making progress - or when running into the same issue(s) you have.

Aron

On Sat, Apr 15, 2017 at 9:30 AM, Elayne Glantzberg <solinox@solinoxenterprises.com> wrote:

Thank you so much, that would be wonderful! I can't wait to get it operational and start customizing it.

Elayne

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Fri, April 14, 2017 8:23 pm
To: Elayne Glantzberg <solinox@solinoxenterprises.com>
Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org>

Thanks, Elayne!

If I - or another member of this list who happens to look at this - can't spot something obvious in this, I'll do my best to set aside some time next week for an installation. I understand that might not coincide with your availability as a volunteer, but we'll see if we can help you get this operational fairly soon.

Thanks again,

Aron

On Fri, Apr 14, 2017 at 3:05 PM, Elayne Glantzberg <solinox@solinoxenterprises.com> wrote:

I don't mind sharing. Until I make this work, there is nothing proprietary in there!

Thanks,

Elayne

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Fri, April 14, 2017 5:46 pm
To: Elayne Glantzberg <solinox@solinoxenterprises.com>
Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org>

Thanks, Elayne.

Could you package up and send a copy of the folder/directory in the "application" part of your CollectionSpace source code - the part containing the configuration for your various tenants?

That might be something like this (under Ubuntu):

tar -zvcf resources.tar.gz /home/cspace/cspace_source/application/tomcat-main/src/main

This will create a file named 'resource.tar.gz'. If you can mail this file directly from your Linux host, or can transfer it onto a PC or Mac elsewhere for mailing, please feel free to attach it to this thread, or if you prefer, email me directly with it. Thanks!

Aron

LL
Luke Lim
Thu, Apr 27, 2017 6:52 PM

Hi Elayne,

I also experienced your issue and got your errors in the Initialize
Authorities and Term Lists step of creating a new tenant (I happened to be
doing my first CollectionSpace install, and just joined the talk list to
find your thread).

I'm brand new to CollectionSpace, so I don't know the implications of doing
this, but I've managed to clone the core tenant (and see the Term List data
in the new clone) by using the "Storing your museum's data in its own
database" option. I found the information on doing this in the "The
less-easy way" on
https://wiki.collectionspace.org/display/DOC/Creating+your+new+tenant

What I did was use the "The easy way" procedure, but after the first 'ant
clone-tenant' operation in the ~/cspace_source/application directory, I
added a step to edit a generated settings.xml file. The change to
settings.xml was to add a <name> child element to <repository> to specify a
new database name (prefix). Mine looked like this:

...
<repository>
<domain>demo2-domain</domain>
<name>demo2</name>
<client>nuxeo-java</client>
...

(i was cloning tenant core to demo2)
The rest of my procedures were the same (including editing the
[tenant]-tenant.xml file to include <tenantid>).

Let me know if you'd like more details of my steps.

Luke Lim

(this is also my first response/post, so anyone let me know about comm
protocols I should follow! :) )

On Wed, Apr 26, 2017 at 5:55 PM, Elayne Glantzberg <
solinox@solinoxenterprises.com> wrote:

So while we wait for developers to track down and squash this bug, is
there anybody else here that has successfully cloned the core tenant in the
current (v4.4) version of CollectionSpace?  If so, can you tell me exactly
how you did it?  I'd really like to get my group up and running, whether
it's by changing operating systems or tenant names or whatever it takes.

Thanks,

Elayne Glantzberg
Database Administrator
Aquarian Tabernacle Church

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts aron@socrates.berkeley.edu
Date: Fri, April 21, 2017 7:23 pm
To: Elayne Glantzberg solinox@solinoxenterprises.com
Cc: "talk@lists.collectionspace.org" talk@lists.collectionspace.org

Was able to replicate what you're seeing, Elayne.

In the new 'atcmuseum' tenant (cloned from 'core') via the 'easy way'
method, on an Ubuntu 14.04.05 VM on which an installation of
CollectionSpace 4.4 was performed via the automated installer:

  1. Dynamic term lists are missing (in the left-hand list under
    Administration->Term List Management)

  2. Visiting the 'initialize' URL for this tenant yields multiple errors of
    the type:

*** ERROR *** CollectionSpace attempted to create a new
term list or term list item which had a non-unique short identifier.

And also:

  1. Attempts to save authority records (like this Person record) also
    failed, as shown here:

[image: Inline image 1]

Will now look into the cause and how we can get this working ...

Thanks,
Aron

--

Initialise vocab/auth entries
testing authority person
need to create instance person-person

Summary:
*** ERROR *** CollectionSpace attempted to
create a new term list or term list item which
had a non-unique short identifier. New term
lists and/or term list items must have unique
short identifiers across all term lists:
The CollectionSpace administrator needs to change
the non-unique short identifier and restart CollectionSpace.

Detailed error code:
409
Request target:
http://localhost:8180/cspace-services//personauthorities/
Detailed error message:
Connection exceptionorg.nuxeo.ecm.core.api.ConcurrentUpdateException:
Failed to save session: org.nuxeo.ecm.core.api.ConcurrentUpdateDocumentException:
org.nuxeo.ecm.core.storage.ConcurrentUpdateStorageException:
java.sql.BatchUpdateException: Batch entry 0 INSERT INTO
"personauthorities_common" ("id", "displayname", "sas", "shortidentifier",
"vocabtype", "source", "refname", "remoteclientconfigname", "description",
"rev") VALUES ('3bace7b0-451e-4511-8c6f-9cf1ac8bd798', 'Local Persons',
NULL, 'person', NULL, NULL,
'urn:cspace:museum.atcwicca.org:personauthorities:name(person)''Local Persons'''
, NULL, NULL, '0') was aborted.
Call getNextException to see the cause.

On Thu, Apr 20, 2017 at 8:28 PM, Aron Roberts aron@socrates.berkeley.edu
wrote:

Cool - thanks, Elayne! Will try one or both methods tomorrow and we can
then share experiences.

If I run into the same issue and can't resolve it for you, will work with
others here at UC Berkeley or at LYRASIS to investigate ...

On Thu, Apr 20, 2017 at 8:07 PM, Elayne Glantzberg <
solinox@solinoxenterprises.com> wrote:

The first time, I did it the long way. The second time, I did it the
easy way. Both times cloning the core tenant.

On Apr 20, 2017 8:38 PM, Aron Roberts aron@socrates.berkeley.edu
wrote:

I just got an installation of CSpace 4.4 completed on a VM, and plan to
try to re-create your setup.

When you created your new tenant, did you use the 'easy' method? And if
so, when tenant did you clone?

On Thu, Apr 20, 2017 at 5:12 PM, Elayne Glantzberg <
solinox@solinoxenterprises.com> wrote:

Any luck yet?  Is there a way I can manually enter new term lists, or
import them from the Core, or something to get us up and running?

Thanks,

Elayne Glantzberg
Database Administrator
Aquarian Tabernacle Church

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts aron@socrates.berkeley.edu
Date: Sun, April 16, 2017 1:18 pm
To: Elayne Glantzberg solinox@solinoxenterprises.com

Thanks, Elayne! I'll update you when I start working on this, and when
making progress - or when running into the same issue(s) you have.

Aron

On Sat, Apr 15, 2017 at 9:30 AM, Elayne Glantzberg <
solinox@solinoxenterprises.com> wrote:

Thank you so much, that would be wonderful!  I can't wait to get it
operational and start customizing it.

Elayne

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts aron@socrates.berkeley.edu
Date: Fri, April 14, 2017 8:23 pm
To: Elayne Glantzberg solinox@solinoxenterprises.com
Cc: "talk@lists.collectionspace.org" talk@lists.collectionspace.org

Thanks, Elayne!

If I - or another member of this list who happens to look at this -
can't spot something obvious in this, I'll do my best to set aside some
time next week for an installation. I understand that might not coincide
with your availability as a volunteer, but we'll see if we can help you get
this operational fairly soon.

Thanks again,
Aron

On Fri, Apr 14, 2017 at 3:05 PM, Elayne Glantzberg <
solinox@solinoxenterprises.com> wrote:

I don't mind sharing.  Until I make this work, there is nothing
proprietary in there!

Thanks,

Elayne

-------- Original Message --------
Subject: Re: [Talk] Missing Term Lists
From: Aron Roberts aron@socrates.berkeley.edu
Date: Fri, April 14, 2017 5:46 pm
To: Elayne Glantzberg solinox@solinoxenterprises.com
Cc: "talk@lists.collectionspace.org" talk@lists.collectionspace.org

Thanks, Elayne.

Could you package up and send a copy of the folder/directory in the
"application" part of your CollectionSpace source code - the part
containing the configuration for your various tenants?

That might be something like this (under Ubuntu):

tar -zvcf resources.tar.gz /home/cspace/cspace_source/app
lication/tomcat-main/src/main

This will create a file named 'resource.tar.gz'. If you can mail this
file directly from your Linux host, or can transfer it onto a PC or Mac
elsewhere for mailing, please feel free to attach it to this thread, or if
you prefer, email me directly with it. Thanks!

Aron

Hi Elayne, I also experienced your issue and got your errors in the Initialize Authorities and Term Lists step of creating a new tenant (I happened to be doing my first CollectionSpace install, and just joined the talk list to find your thread). I'm brand new to CollectionSpace, so I don't know the implications of doing this, but I've managed to clone the core tenant (and see the Term List data in the new clone) by using the "Storing your museum's data in its own database" option. I found the information on doing this in the "The less-easy way" on https://wiki.collectionspace.org/display/DOC/Creating+your+new+tenant What I did was use the "The easy way" procedure, but after the first 'ant clone-tenant' operation in the ~/cspace_source/application directory, I added a step to edit a generated settings.xml file. The change to settings.xml was to add a <name> child element to <repository> to specify a new database name (prefix). Mine looked like this: ... <repository> <domain>demo2-domain</domain> <name>demo2</name> <client>nuxeo-java</client> ... (i was cloning tenant core to demo2) The rest of my procedures were the same (including editing the [tenant]-tenant.xml file to include <tenantid>). Let me know if you'd like more details of my steps. Luke Lim (this is also my first response/post, so anyone let me know about comm protocols I should follow! :) ) On Wed, Apr 26, 2017 at 5:55 PM, Elayne Glantzberg < solinox@solinoxenterprises.com> wrote: > So while we wait for developers to track down and squash this bug, is > there anybody else here that has successfully cloned the core tenant in the > current (v4.4) version of CollectionSpace? If so, can you tell me exactly > how you did it? I'd really like to get my group up and running, whether > it's by changing operating systems or tenant names or whatever it takes. > > Thanks, > > Elayne Glantzberg > Database Administrator > Aquarian Tabernacle Church > > -------- Original Message -------- > Subject: Re: [Talk] Missing Term Lists > From: Aron Roberts <aron@socrates.berkeley.edu> > Date: Fri, April 21, 2017 7:23 pm > To: Elayne Glantzberg <solinox@solinoxenterprises.com> > Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org> > > Was able to replicate what you're seeing, Elayne. > > In the new 'atcmuseum' tenant (cloned from 'core') via the 'easy way' > method, on an Ubuntu 14.04.05 VM on which an installation of > CollectionSpace 4.4 was performed via the automated installer: > > 1. Dynamic term lists are missing (in the left-hand list under > Administration->Term List Management) > > 2. Visiting the 'initialize' URL for this tenant yields multiple errors of > the type: > > *** ERROR *** CollectionSpace attempted to create a new > term list or term list item which had a non-unique short identifier. > > And also: > > 3. Attempts to save authority records (like this Person record) also > failed, as shown here: > > [image: Inline image 1] > > Will now look into the cause and how we can get this working ... > > Thanks, > Aron > > -- > > Initialise vocab/auth entries > testing authority person > need to create instance person-person > > Summary: > *** ERROR *** CollectionSpace attempted to > create a new term list or term list item which > had a non-unique short identifier. New term > lists and/or term list items must have unique > short identifiers across all term lists: > The CollectionSpace administrator needs to change > the non-unique short identifier and restart CollectionSpace. > > > Detailed error code: > 409 > Request target: > http://localhost:8180/cspace-services//personauthorities/ > Detailed error message: > Connection exceptionorg.nuxeo.ecm.core.api.ConcurrentUpdateException: > Failed to save session: org.nuxeo.ecm.core.api.ConcurrentUpdateDocumentException: > org.nuxeo.ecm.core.storage.ConcurrentUpdateStorageException: > java.sql.BatchUpdateException: Batch entry 0 INSERT INTO > "personauthorities_common" ("id", "displayname", "sas", "shortidentifier", > "vocabtype", "source", "refname", "remoteclientconfigname", "description", > "rev") VALUES ('3bace7b0-451e-4511-8c6f-9cf1ac8bd798', 'Local Persons', > NULL, 'person', NULL, NULL, > 'urn:cspace:museum.atcwicca.org:personauthorities:name(person)''Local Persons''' > , NULL, NULL, '0') was aborted. > Call getNextException to see the cause. > > > > On Thu, Apr 20, 2017 at 8:28 PM, Aron Roberts <aron@socrates.berkeley.edu> > wrote: > >> Cool - thanks, Elayne! Will try one or both methods tomorrow and we can >> then share experiences. >> >> If I run into the same issue and can't resolve it for you, will work with >> others here at UC Berkeley or at LYRASIS to investigate ... >> >> On Thu, Apr 20, 2017 at 8:07 PM, Elayne Glantzberg < >> solinox@solinoxenterprises.com> wrote: >> >>> The first time, I did it the long way. The second time, I did it the >>> easy way. Both times cloning the core tenant. >>> >>> On Apr 20, 2017 8:38 PM, Aron Roberts <aron@socrates.berkeley.edu> >>> wrote: >>> >>> I just got an installation of CSpace 4.4 completed on a VM, and plan to >>> try to re-create your setup. >>> >>> When you created your new tenant, did you use the 'easy' method? And if >>> so, when tenant did you clone? >>> >>> On Thu, Apr 20, 2017 at 5:12 PM, Elayne Glantzberg < >>> solinox@solinoxenterprises.com> wrote: >>> >>> Any luck yet? Is there a way I can manually enter new term lists, or >>> import them from the Core, or something to get us up and running? >>> >>> Thanks, >>> >>> Elayne Glantzberg >>> Database Administrator >>> Aquarian Tabernacle Church >>> >>> >>> -------- Original Message -------- >>> Subject: Re: [Talk] Missing Term Lists >>> From: Aron Roberts <aron@socrates.berkeley.edu> >>> Date: Sun, April 16, 2017 1:18 pm >>> To: Elayne Glantzberg <solinox@solinoxenterprises.com> >>> >>> Thanks, Elayne! I'll update you when I start working on this, and when >>> making progress - or when running into the same issue(s) you have. >>> >>> Aron >>> >>> On Sat, Apr 15, 2017 at 9:30 AM, Elayne Glantzberg < >>> solinox@solinoxenterprises.com> wrote: >>> >>> Thank you so much, that would be wonderful! I can't wait to get it >>> operational and start customizing it. >>> >>> Elayne >>> >>> -------- Original Message -------- >>> Subject: Re: [Talk] Missing Term Lists >>> From: Aron Roberts <aron@socrates.berkeley.edu> >>> Date: Fri, April 14, 2017 8:23 pm >>> To: Elayne Glantzberg <solinox@solinoxenterprises.com> >>> Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org> >>> >>> Thanks, Elayne! >>> >>> If I - or another member of this list who happens to look at this - >>> can't spot something obvious in this, I'll do my best to set aside some >>> time next week for an installation. I understand that might not coincide >>> with your availability as a volunteer, but we'll see if we can help you get >>> this operational fairly soon. >>> >>> Thanks again, >>> Aron >>> >>> On Fri, Apr 14, 2017 at 3:05 PM, Elayne Glantzberg < >>> solinox@solinoxenterprises.com> wrote: >>> >>> I don't mind sharing. Until I make this work, there is nothing >>> proprietary in there! >>> >>> Thanks, >>> >>> Elayne >>> >>> >>> -------- Original Message -------- >>> Subject: Re: [Talk] Missing Term Lists >>> From: Aron Roberts <aron@socrates.berkeley.edu> >>> Date: Fri, April 14, 2017 5:46 pm >>> To: Elayne Glantzberg <solinox@solinoxenterprises.com> >>> Cc: "talk@lists.collectionspace.org" <talk@lists.collectionspace.org> >>> >>> Thanks, Elayne. >>> >>> Could you package up and send a copy of the folder/directory in the >>> "application" part of your CollectionSpace source code - the part >>> containing the configuration for your various tenants? >>> >>> That *might* be something like this (under Ubuntu): >>> >>> tar -zvcf resources.tar.gz /home/cspace/cspace_source/app >>> lication/tomcat-main/src/main >>> >>> This will create a file named 'resource.tar.gz'. If you can mail this >>> file directly from your Linux host, or can transfer it onto a PC or Mac >>> elsewhere for mailing, please feel free to attach it to this thread, or if >>> you prefer, email me directly with it. Thanks! >>> >>> Aron >>> >>> >>> >>> >>> >>> >> > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_ > lists.collectionspace.org > >