bug #4707
openLSID Authority service cannot find CoL LSIDs
10%
Description
The following request fails
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
Updated by Andreas Kohlbecker over 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!
This must be added at least to the CoL import, therefore reassigning this ticket to a.mueller
Should we implement a validation rule for this?
Should the LSIDAuthority and namespace be added automatically a when setting the LSID for an identifiable entity?
Updated by Andreas Kohlbecker over 9 years ago
- Target version changed from cdmlib RELEASE 3.5.0 to cdmlib RELEASE 3.5.1
moving tickets to next milestone
Updated by Andreas Kohlbecker over 9 years ago
- Keywords set to catalogueoflife
- Category changed from cdmlib to data
Updated by Andreas Müller over 9 years ago
- Priority changed from Priority08 to Highest
Updated by Andreas Müller over 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
Updated by Andreas Müller over 8 years ago
- Target version changed from cdmlib RELEASE 3.5.2 to Unassigned CDM tickets
Updated by Andreas Kohlbecker over 8 years ago
it seems as if this is biting me gain!
see #5624
Updated by Andreas Kohlbecker over 8 years ago
Andreas Müller: can you care for this?
Updated by Andreas Müller over 8 years ago
- Target version changed from Unassigned CDM tickets to Release 4.1
Updated by Andreas Müller over 8 years ago
- Keywords changed from catalogueoflife to CoL
Updated by Andreas Müller over 8 years ago
- Target version changed from Release 4.1 to Release 4.2
Updated by Andreas Müller about 8 years ago
- Target version changed from Release 4.2 to Release 4.3
Updated by Andreas Müller almost 8 years ago
- Target version changed from Release 4.3 to Release 4.4
Updated by Andreas Müller over 7 years ago
- Target version changed from Release 4.4 to Release 4.5
Updated by Andreas Müller over 7 years ago
- Target version changed from Release 4.5 to Release 4.6
Updated by Andreas Müller over 7 years ago
- Description updated (diff)
- Private changed from Yes to No
Updated by Andreas Müller over 7 years ago
- Target version changed from Release 4.6 to Release 4.7
Updated by Andreas Müller over 7 years ago
- Target version changed from Release 4.7 to Release 4.8
Updated by Andreas Müller about 7 years ago
- Target version changed from Release 4.8 to Release 4.9
Updated by Andreas Müller about 7 years ago
- Target version changed from Release 4.9 to Release 4.10
Updated by Andreas Müller about 7 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)
Updated by Andreas Müller about 7 years ago
- File picture665-1.png picture665-1.png added
- Assignee changed from Andreas Kohlbecker to Andreas Müller
AK, now I understand the problem. There are missing entries in tables "LSIDAuthority" and "lsidauthority_namespaces". They should look like
and
Updated by Andreas Müller about 7 years ago
- File picture769-1.png picture769-1.png added
Updated by Andreas Müller about 7 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');
Updated by Andreas Müller about 7 years ago
- Status changed from Resolved to In Progress
Updated by Andreas Müller almost 7 years ago
- Target version changed from Release 4.10 to Release 4.12
Updated by Andreas Müller over 6 years ago
- Target version changed from Release 4.12 to Release 4.13
Updated by Andreas Müller over 6 years ago
- Target version changed from Release 4.13 to Release 4.14
Updated by Andreas Müller over 6 years ago
- Target version changed from Release 4.14 to Release 5.0
Updated by Andreas Müller over 6 years ago
- Target version changed from Release 5.0 to Release 5.1
Updated by Andreas Müller about 6 years ago
- Target version changed from Release 5.1 to Release 5.2
Updated by Andreas Müller about 6 years ago
- Target version changed from Release 5.2 to Release 5.3
Updated by Andreas Müller almost 6 years ago
- Target version changed from Release 5.3 to Release 5.5
Updated by Andreas Müller over 5 years ago
- Target version changed from Release 5.5 to Release 5.6
Updated by Andreas Müller over 5 years ago
- Target version changed from Release 5.6 to Reviewed Next Major Release