talk@lists.collectionspace.org
Targeted discussion among implementers and between implementers and the CollectionSpace development team
View all threadsmigrate and upgrade 4.1 to 5.2 Groups
Hi,
I've tried restarting and it doesn't change anything.
The REST call returns the one collecitonobject, same as the UI.
Thanks, Willi
<ns2:abstract-common-list xmlns:ns2="http://collectionspace.org/services/jaxb">
<pageNum>0</pageNum>
<pageSize>40</pageSize>
<itemsInPage>1</itemsInPage>
<totalItems>1</totalItems>
<fieldsReturned>csid|uri|refName|updatedAt|workflowState|objectNumber|objectName|title|responsibleDepartment</fieldsReturned>
<list-item>
<csid>9fda3ca2-1404-4f38-b28f</csid>
<uri>/collectionobjects/9fda3ca2-1404-4f38-b28f</uri>
<refName>urn:cspace:alexandernowik.org:collectionobjects:id(9fda3ca2-1404-4f38-b28f)'AHN.2020.TEST'</refName>
<updatedAt>2020-02-05T15:30:12.396Z</updatedAt>
<workflowState>project</workflowState>
<objectNumber>AHN.2020.TEST</objectNumber>
</list-item>
</ns2:abstract-common-list>
-----Original Message-----
From: Ray Lee ray.lee@lyrasis.org
Sent: Sunday, February 23, 2020 23:39
To: William Wolf ww@williwolf.net; talk@lists.collectionspace.org
Subject: Re: migrate and upgrade 4.1 to 5.2 Groups
Hi Willi,
You said you tried setting the active column to true in relations_common. Did you restart cspace after that? If not, try that first.
What does this request to the REST API show?
/cspace-services/collectionobjects?rtSbj=50d11c8e-97d9-4474-82ea&rtPredicate=affects
Ray
═
Ray Lee
CollectionSpace Senior Developer
LYRASIS
ray.lee@lyrasis.org
From: William Wolf ww@williwolf.net
Sent: Saturday, February 22, 2020 6:59 AM
To: Ray Lee; talk@lists.collectionspace.org
Subject: RE: migrate and upgrade 4.1 to 5.2 Groups
Update:
Adding the value 't' to the Active field in relations_common did nothing ☹ I have done some more experimenting and notice this:
The UI problem is only with the migrated Object records.
New Object record
An Object record newly created in v5.2 can be related to any Group record (migrated or new) and this relationship shows in the browser correctly, both from the Group record and from the Object record perspective.
Migrated Object record
In the Group record perspective the related migrated Object records are not shown. But from the Object record perspective the related Group records are shown. New relationships created between Group and any migrated Object record appear to be saved and exist in Postgres table relations_common, but are not shown in the UI Group record as related Object records. (However the UI does correctly work for the 'Relate existing' Objects feature. It shows checkboxes for unrelated Object records and no checkboxes for related Object records that migrated.)
Any ideas?
Thanks,
Willi
-----Original Message-----
From: William Wolf
Sent: Wednesday, February 19, 2020 14:34
To: Ray Lee ray.lee@lyrasis.org; talk@lists.collectionspace.org
Subject: RE: migrate and upgrade 4.1 to 5.2 Groups
Hi,
I've got all the records expected in table relations_common, but I see that all the values for the field 'Active' are missing. I will add the value 't' in that field and that should fix my problem.
Thank you,
Willi
-----Original Message-----
From: Ray Lee ray.lee@lyrasis.org
Sent: Tuesday, February 18, 2020 0:14
To: William Wolf ww@williwolf.net; talk@lists.collectionspace.org
Subject: Re: migrate and upgrade 4.1 to 5.2 Groups
Hi Willi,
What version of the UI is displayed in the footer?
When a relation is created between an object and a group, there should be two rows in relations_common: one where the subject is the collectionobject and the object is the group, and one where the subject is the group, and the object is the collectionobject. But it sounds like only one of the rows exists. Is that right?
Thanks,
Ray
═
Ray Lee
CollectionSpace Senior Developer
LYRASIS
ray.lee@lyrasis.org
From: Talk talk-bounces@lists.collectionspace.org on behalf of William Wolf ww@williwolf.net
Sent: Tuesday, February 11, 2020 12:24 PM
To: talk@lists.collectionspace.org
Subject: [Talk] migrate and upgrade 4.1 to 5.2 Groups
Hi,
I’m really trying to nail down the repeatable process to migrate and upgrade from v4.1 to v5.2, and while I’ve drafted a document in Confluence I will need to basically rewrite it due to continued testing and findings.
There is a mystery I can’t solve which is that after migrated to v5.2 the Group records don’t show their related Object records in the UI. I can see the relationships exist in the Postgres table relations_common. I can see the Group records themselves in the UI. But there are not related Object records showing in the UI for them. However from the Object records I can see related Group records in the UI.
In v5.2 I can create a new Group record and successfully relate it to a newly created Object record and see this correctly in the UI.
That same new Group record will allow me to create a new relationship record to a migrated Object record but won’t subsequently display the Object record. I confirm the row is added to relations_common in Postgres. Interestingly the Object record will however show the related Group record ! Further, when trying to relate Group records to Object records there is no available checkbox beside any existing related Object records, so the UI knows that the relationship already exists and can’t be added to related Objects.
Any ideas on how I should troubleshoot this?
Thank you,
Willi Wolf
Willi,
I may not be quite understanding the issue, but it seems you have only
shown us one side of the Relations between the Group and two different
CollectionObjects.
There should be two Relations record between each Group-Object pair.
What happen when you try the following?
select * from relations_common where objectcsid = '50d11c8e-97d9-4474-82ea';
I've snipped and edited the relevant bits from this thread, hope I have not
made too much of a hash of things!
John
On Sun, Feb 23, 2020 at 8:45 PM William Wolf ww@williwolf.net wrote:
Here are the two records in relations_common. The first of the two was
migrated and fails to show as a related object to the group. The second of
the two was created in v5.2 and does show as a related object to the group.
select * from relations_common where subjectcsid =
'50d11c8e-97d9-4474-82ea';
id | subjectcsid | relationshi... |
subj...enttype | objectrefname | subjectrefname |
objectcsid | objectdocumenttype | active
--------------------------------------+-------------------------+------------------+---------------------+---------------------------------+-----------------------------------------------------------
b0b26888-2a9f-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2016.A030 | 6821b517-... |
CollectionObject | t
1c4e1468-bb14-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2020.TEST | 9fda3ca2-... | CollectionObject
| t
(2 rows)
From: William Wolf
I've got all the records expected in table relations_common, but I see
that all the values for the field 'Active' are missing. I will add the
value 't' in that field and that should fix my problem.
[snip]
When a relation is created between an object and a group, there should be
two rows in relations_common: one where the subject is the collectionobject
and the object is the group, and one where the subject is the group, and
the object is the collectionobject. But it sounds like only one of the rows
exists. Is that right?
Thanks,
Ray
Hi John,
You’re right, I didn’t show the other side. But they are there, when I run the code I get them as expected:
id | subjectcsid | relationshiptype | subjectdocumenttype | subjecturi | objectrefname | relationshipmetatype | predicatedisplayname | predicate | subjectrefname | objectcsid | objecturi | objectdocumenttype | active
--------------------------------------+-------------------------+------------------+---------------------+--------------------------------------------+------------------------------------------------------------------+----------------------+----------------------+-----------+--------------------------------------------------------------------------------------------+-------------------------+---------------------------------+--------------------+--------
3462f2ca-768a-4965-a08a-1995f1610e1e | 6821b517-4b13-4401-879b | affects | CollectionObject | /collectionobjects/6821b517-4b13-4401-879b | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea) | | | | urn:cspace:alexandernowik.org:collectionobjects:id(6821b517-4b13-4401-879b)'AHN.2016.A030' | 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea | Group | t
e2f8e009-19e9-4b95-9459-38c88f575dd7 | 9fda3ca2-1404-4f38-b28f | affects | CollectionObject | /collectionobjects/9fda3ca2-1404-4f38-b28f | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea) | | | | urn:cspace:alexandernowik.org:collectionobjects:id(9fda3ca2-1404-4f38-b28f)'AHN.2020.TEST' | 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea | Group | t
(2 rows)
Thanks for your help.
Willi
From: John Brandon Lowe MLIS PhD jblowe@berkeley.edu
Sent: Monday, February 24, 2020 8:39
To: William Wolf ww@williwolf.net
Cc: Ray Lee ray.lee@lyrasis.org; talk@lists.collectionspace.org
Subject: Re: [Talk] migrate and upgrade 4.1 to 5.2 Groups
Willi,
I may not be quite understanding the issue, but it seems you have only shown us one side of the Relations between the Group and two different CollectionObjects.
There should be two Relations record between each Group-Object pair.
What happen when you try the following?
select * from relations_common where objectcsid = '50d11c8e-97d9-4474-82ea';
I've snipped and edited the relevant bits from this thread, hope I have not made too much of a hash of things!
John
On Sun, Feb 23, 2020 at 8:45 PM William Wolf <ww@williwolf.netmailto:ww@williwolf.net> wrote:
Here are the two records in relations_common. The first of the two was migrated and fails to show as a related object to the group. The second of the two was created in v5.2 and does show as a related object to the group.
select * from relations_common where subjectcsid = '50d11c8e-97d9-4474-82ea';
id | subjectcsid | relationshi... | subj...enttype | objectrefname | subjectrefname | objectcsid | objectdocumenttype | active
--------------------------------------+-------------------------+------------------+---------------------+---------------------------------+-----------------------------------------------------------
b0b26888-2a9f-... | 50d11c8e-... | affects | Group | /groups/50d11c8e-... | AHN.2016.A030 | 6821b517-... | CollectionObject | t
1c4e1468-bb14-... | 50d11c8e-... | affects | Group | /groups/50d11c8e-... | AHN.2020.TEST | 9fda3ca2-... | CollectionObject | t
(2 rows)
From: William Wolf
I've got all the records expected in table relations_common, but I see that all the values for the field 'Active' are missing. I will add the value 't' in that field and that should fix my problem.
[snip]
When a relation is created between an object and a group, there should be two rows in relations_common: one where the subject is the collectionobject and the object is the group, and one where the subject is the group, and the object is the collectionobject. But it sounds like only one of the rows exists. Is that right?
Thanks,
Ray
All,
Willi and I may have found the cause of this problem. We're working on a
solution and will send an update once we've resolved it.
Thanks,
Richard
On Tue, Feb 25, 2020 at 5:24 AM William Wolf ww@williwolf.net wrote:
Hi John,
You’re right, I didn’t show the other side. But they are there, when I run
the code I get them as expected:
id | subjectcsid |
relationshiptype | subjectdocumenttype |
subjecturi |
objectrefname | relationshipmetatype |
predicatedisplayname | predicate |
subjectrefname |
objectcsid | objecturi | objectdocumenttype |
active
--------------------------------------+-------------------------+------------------+---------------------+--------------------------------------------+------------------------------------------------------------------+----------------------+----------------------+-----------+--------------------------------------------------------------------------------------------+-------------------------+---------------------------------+--------------------+--------
3462f2ca-768a-4965-a08a-1995f1610e1e | 6821b517-4b13-4401-879b |
affects | CollectionObject |
/collectionobjects/6821b517-4b13-4401-879b | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea)
| | | |
urn:cspace:alexandernowik.org:collectionobjects:id(6821b517-4b13-4401-879b)'AHN.2016.A030'
| 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea |
Group | t
e2f8e009-19e9-4b95-9459-38c88f575dd7 | 9fda3ca2-1404-4f38-b28f |
affects | CollectionObject |
/collectionobjects/9fda3ca2-1404-4f38-b28f | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea)
| | | |
urn:cspace:alexandernowik.org:collectionobjects:id(9fda3ca2-1404-4f38-b28f)'AHN.2020.TEST'
| 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea |
Group | t
(2 rows)
Thanks for your help.
Willi
From: John Brandon Lowe MLIS PhD jblowe@berkeley.edu
Sent: Monday, February 24, 2020 8:39
To: William Wolf ww@williwolf.net
Cc: Ray Lee ray.lee@lyrasis.org; talk@lists.collectionspace.org
Subject: Re: [Talk] migrate and upgrade 4.1 to 5.2 Groups
Willi,
I may not be quite understanding the issue, but it seems you have only
shown us one side of the Relations between the Group and two different
CollectionObjects.
There should be two Relations record between each Group-Object pair.
What happen when you try the following?
select * from relations_common where objectcsid =
'50d11c8e-97d9-4474-82ea';
I've snipped and edited the relevant bits from this thread, hope I have
not made too much of a hash of things!
John
On Sun, Feb 23, 2020 at 8:45 PM William Wolf ww@williwolf.net wrote:
Here are the two records in relations_common. The first of the two was
migrated and fails to show as a related object to the group. The second of
the two was created in v5.2 and does show as a related object to the group.
select * from relations_common where subjectcsid =
'50d11c8e-97d9-4474-82ea';
id | subjectcsid | relationshi... |
subj...enttype | objectrefname | subjectrefname |
objectcsid | objectdocumenttype | active
--------------------------------------+-------------------------+------------------+---------------------+---------------------------------+-----------------------------------------------------------
b0b26888-2a9f-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2016.A030 | 6821b517-... | CollectionObject
| t
1c4e1468-bb14-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2020.TEST | 9fda3ca2-... | CollectionObject
| t
(2 rows)
From: William Wolf
I've got all the records expected in table relations_common, but I see
that all the values for the field 'Active' are missing. I will add the
value 't' in that field and that should fix my problem.
[snip]
When a relation is created between an object and a group, there should be
two rows in relations_common: one where the subject is the collectionobject
and the object is the group, and one where the subject is the group, and
the object is the collectionobject. But it sounds like only one of the rows
exists. Is that right?
Thanks,
Ray
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org
Sounds like Willi has resolved this issue. You can read about his solution
in the document he'll be posting shorting to the CollectionSpace wiki. In
the document, he will describe his experience upgrading CollectionSpace
from v4.1 to v5.2.
On Tue, Feb 25, 2020 at 3:38 PM Richard Millet richard.millet@berkeley.edu
wrote:
All,
Willi and I may have found the cause of this problem. We're working on a
solution and will send an update once we've resolved it.
Thanks,
Richard
On Tue, Feb 25, 2020 at 5:24 AM William Wolf ww@williwolf.net wrote:
Hi John,
You’re right, I didn’t show the other side. But they are there, when I
run the code I get them as expected:
id | subjectcsid |
relationshiptype | subjectdocumenttype |
subjecturi |
objectrefname | relationshipmetatype |
predicatedisplayname | predicate |
subjectrefname |
objectcsid | objecturi | objectdocumenttype |
active
--------------------------------------+-------------------------+------------------+---------------------+--------------------------------------------+------------------------------------------------------------------+----------------------+----------------------+-----------+--------------------------------------------------------------------------------------------+-------------------------+---------------------------------+--------------------+--------
3462f2ca-768a-4965-a08a-1995f1610e1e | 6821b517-4b13-4401-879b |
affects | CollectionObject |
/collectionobjects/6821b517-4b13-4401-879b | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea)
| | | |
urn:cspace:alexandernowik.org:collectionobjects:id(6821b517-4b13-4401-879b)'AHN.2016.A030'
| 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea |
Group | t
e2f8e009-19e9-4b95-9459-38c88f575dd7 | 9fda3ca2-1404-4f38-b28f |
affects | CollectionObject |
/collectionobjects/9fda3ca2-1404-4f38-b28f | urn:cspace:alexandernowik.org:groups:id(50d11c8e-97d9-4474-82ea)
| | | |
urn:cspace:alexandernowik.org:collectionobjects:id(9fda3ca2-1404-4f38-b28f)'AHN.2020.TEST'
| 50d11c8e-97d9-4474-82ea | /groups/50d11c8e-97d9-4474-82ea |
Group | t
(2 rows)
Thanks for your help.
Willi
From: John Brandon Lowe MLIS PhD jblowe@berkeley.edu
Sent: Monday, February 24, 2020 8:39
To: William Wolf ww@williwolf.net
Cc: Ray Lee ray.lee@lyrasis.org; talk@lists.collectionspace.org
Subject: Re: [Talk] migrate and upgrade 4.1 to 5.2 Groups
Willi,
I may not be quite understanding the issue, but it seems you have only
shown us one side of the Relations between the Group and two different
CollectionObjects.
There should be two Relations record between each Group-Object pair.
What happen when you try the following?
select * from relations_common where objectcsid =
'50d11c8e-97d9-4474-82ea';
I've snipped and edited the relevant bits from this thread, hope I have
not made too much of a hash of things!
John
On Sun, Feb 23, 2020 at 8:45 PM William Wolf ww@williwolf.net wrote:
Here are the two records in relations_common. The first of the two was
migrated and fails to show as a related object to the group. The second of
the two was created in v5.2 and does show as a related object to the group.
select * from relations_common where subjectcsid =
'50d11c8e-97d9-4474-82ea';
id | subjectcsid | relationshi... |
subj...enttype | objectrefname | subjectrefname |
objectcsid | objectdocumenttype | active
--------------------------------------+-------------------------+------------------+---------------------+---------------------------------+-----------------------------------------------------------
b0b26888-2a9f-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2016.A030 | 6821b517-... |
CollectionObject | t
1c4e1468-bb14-... | 50d11c8e-... | affects | Group
| /groups/50d11c8e-... | AHN.2020.TEST | 9fda3ca2-... | CollectionObject
| t
(2 rows)
From: William Wolf
I've got all the records expected in table relations_common, but I see
that all the values for the field 'Active' are missing. I will add the
value 't' in that field and that should fix my problem.
[snip]
When a relation is created between an object and a group, there should be
two rows in relations_common: one where the subject is the collectionobject
and the object is the group, and one where the subject is the group, and
the object is the collectionobject. But it sounds like only one of the rows
exists. Is that right?
Thanks,
Ray
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org