Project

General

Profile

Actions
Copy link

bug #4707

open

LSID Authority service cannot find CoL LSIDs

Added by Andreas Kohlbecker about 9 years ago. Updated about 5 years ago.

Status:
In Progress
Priority:
Highest
Assignee:
Andreas Müller
Category:
data
Target version:
Reviewed Next Major Release
Start date:
Due date:
% Done:

10%

Estimated time:
Severity:
major
Found in Version:
Tags:
col

Description

The following request fails

https://test.e-taxonomy.eu/cdmserver/col/authority/data.do?lsid=urn%3Alsid%3Acatalogueoflife.org%3Ataxon%3Aedce3354-29c1-102b-9a4a-00304854f820%3Acol20140122

Caused by: 

com.ibm.lsid.server.LSIDServerException: 201 : Unknown LSID
    at eu.etaxonomy.cdm.api.service.lsid.impl.LsidDataServiceImpl.getData(LsidDataServiceImpl.java:46)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

====

NOTE (AM): Please be aware that not all accepted taxa have a valid LSID. There are currently 4614 taxa without LSID. Reasons might be that they are not well formed or do not exist.

SELECT *
FROM TaxonBase tb
WHERE tb.DTYPE = 'Taxon' AND tb.lsid_lsid IS NULL

Files

Download all files
picture665-1.png (7.37 KB) picture665-1.png Andreas Müller, 08/12/2017 12:16 PM
picture769-1.png (7.48 KB) picture769-1.png Andreas Müller, 08/12/2017 12:19 PM
Actions
Copy link
 #1

Updated by Andreas Kohlbecker about 9 years ago

The problem is the missing data on the LSIDAuthority and on the namespaces.

The following SQL statements are fixing the bug by adding the missing entries:

LSIDAuthority

The cdm_col database in edit-test has already been modified this way!

  1. This must be added at least to the CoL import, therefore reassigning this ticket to a.mueller

  2. Should we implement a validation rule for this?

  3. Should the LSIDAuthority and namespace be added automatically a when setting the LSID for an identifiable entity?

Actions
Copy link
 #2

Updated by Andreas Kohlbecker about 9 years ago

  • Target version changed from cdmlib RELEASE 3.5.0 to cdmlib RELEASE 3.5.1

moving tickets to next milestone

Actions
Copy link
 #3

Updated by Andreas Kohlbecker about 9 years ago

  • Keywords set to catalogueoflife
  • Category changed from cdmlib to data
Actions
Copy link
 #4

Updated by Andreas Müller about 9 years ago

  • Priority changed from Priority08 to Highest
Actions
Copy link
 #5

Updated by Andreas Müller almost 9 years ago

  • Target version changed from cdmlib RELEASE 3.5.1 to cdmlib RELEASE 3.5.2

move open 3.5.1 tickets to next milestone after release

Actions
Copy link
 #6

Updated by Andreas Müller over 8 years ago

  • Target version changed from cdmlib RELEASE 3.5.2 to Unassigned CDM tickets
Actions
Copy link
 #7

Updated by Andreas Kohlbecker about 8 years ago

it seems as if this is biting me gain!

see #5624

Actions
Copy link
 #8

Updated by Andreas Kohlbecker about 8 years ago

Andreas Müller: can you care for this?

Actions
Copy link
 #9

Updated by Andreas Müller almost 8 years ago

  • Target version changed from Unassigned CDM tickets to Release 4.1
Actions
Copy link
 #10

Updated by Andreas Müller almost 8 years ago

  • Keywords changed from catalogueoflife to CoL
Actions
Copy link
 #11

Updated by Andreas Müller almost 8 years ago

  • Target version changed from Release 4.1 to Release 4.2
Actions
Copy link
 #12

Updated by Andreas Müller almost 8 years ago

  • Target version changed from Release 4.2 to Release 4.3
Actions
Copy link
 #13

Updated by Andreas Müller over 7 years ago

  • Target version changed from Release 4.3 to Release 4.4
Actions
Copy link
 #14

Updated by Andreas Müller over 7 years ago

  • Target version changed from Release 4.4 to Release 4.5
Actions
Copy link
 #15

Updated by Andreas Müller over 7 years ago

  • Target version changed from Release 4.5 to Release 4.6
Actions
Copy link
 #16

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
  • Private changed from Yes to No
Actions
Copy link
 #17

Updated by Andreas Müller about 7 years ago

  • Target version changed from Release 4.6 to Release 4.7
Actions
Copy link
 #18

Updated by Andreas Müller almost 7 years ago

  • Target version changed from Release 4.7 to Release 4.8
Actions
Copy link
 #19

Updated by Andreas Müller almost 7 years ago

  • Target version changed from Release 4.8 to Release 4.9
Actions
Copy link
 #20

Updated by Andreas Müller almost 7 years ago

  • Target version changed from Release 4.9 to Release 4.10
Actions
Copy link
 #22

Updated by Andreas Müller over 6 years ago

  • Status changed from New to Resolved
  • Assignee changed from Andreas Müller to Andreas Kohlbecker

This seems to be fixed. I just run the import and all LSID fields seem to be filled for accepted taxa. Please check after the next import is online (or check on test, but imports may run there).

Note: taxon uuids may have changed

Please remove target version after review (data tickets must not have target versions)

Actions
Copy link
 #23

Updated by Andreas Müller over 6 years ago

  • % Done changed from 0 to 80
Actions
Copy link
 #24

Updated by Andreas Müller over 6 years ago

  • Description updated (diff)
Actions
Copy link
 #25

Updated by Andreas Müller over 6 years ago

  • Description updated (diff)
Actions
Copy link
 #26

Updated by Andreas Müller over 6 years ago

AK, now I understand the problem. There are missing entries in tables "LSIDAuthority" and "lsidauthority_namespaces". They should look like

and

Actions
Copy link
 #28

Updated by Andreas Müller over 6 years ago 

INSERT INTO `col_test`.`LSIDAuthority` (`id`, `uuid`, `authority`, `port`) VALUES ('1', 'cab132a8-b26a-4e07-ab47-0e9754d982d8', 'catalogueoflife.org', '0');

INSERT INTO `col_test`.`LSIDAuthority_namespaces` (`LSIDAuthority_id`, `namespaces_element`, `namespaces_mapkey`) VALUES ('1',`namespaces_element`='eu.etaxonomy.cdm.model.taxon.TaxonBase', 'taxon');
Actions
Copy link
 #29

Updated by Andreas Müller over 6 years ago

  • Status changed from Resolved to In Progress
Actions
Copy link
 #30

Updated by Andreas Müller over 6 years ago

  • % Done changed from 80 to 10
Actions
Copy link
 #31

Updated by Andreas Müller over 6 years ago

  • Target version changed from Release 4.10 to Release 4.12
Actions
Copy link
 #32

Updated by Andreas Müller over 6 years ago

  • Target version changed from Release 4.12 to Release 4.13
Actions
Copy link
 #33

Updated by Andreas Müller about 6 years ago

  • Target version changed from Release 4.13 to Release 4.14
Actions
Copy link
 #34

Updated by Andreas Müller about 6 years ago

  • Target version changed from Release 4.14 to Release 5.0
Actions
Copy link
 #35

Updated by Andreas Müller almost 6 years ago

  • Target version changed from Release 5.0 to Release 5.1
Actions
Copy link
 #36

Updated by Andreas Müller almost 6 years ago

  • Target version changed from Release 5.1 to Release 5.2
Actions
Copy link
 #37

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 5.2 to Release 5.3
Actions
Copy link
 #38

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 5.3 to Release 5.5
Actions
Copy link
 #39

Updated by Andreas Müller about 5 years ago

  • Target version changed from Release 5.5 to Release 5.6
Actions
Copy link
 #40

Updated by Andreas Müller about 5 years ago

  • Target version changed from Release 5.6 to Reviewed Next Major Release
Actions
Copy link

Also available in: Atom PDF