Project

General

Profile

Actions

bug #2449

open

Some or many names have an empty fullTitleCache though information is atomized

Added by Andreas Müller over 10 years ago. Updated about 2 months ago.

Status:
In Progress
Priority:
Priority14
Category:
cdmlib
Target version:
Start date:
06/21/2011
Due date:
% Done:

30%

Estimated time:
Severity:
major
Found in Version:

Description

E.g. Cicerbita duthieana in Cichorieae or Aiphanes bicornis Cerón & R.Bernal in PalmWeb

It looks like this accounts mainly to updated names.


Related issues

Related to Edit - bug #2448: Missing updated by/when (e.g. in PalmWeb)WorksformeAndreas Müller06/21/2011

Actions
Related to Edit - bug #9649: Specimens sometimes have empty titleCache instead of class<UUID>ClosedAndreas Müller06/03/2021

Actions
Related to Edit - bug #9665: Filter out property change event for created and updated and cacheStrategy ClosedAndreas Müller06/11/2021

Actions
Actions #1

Updated by Andreas Müller over 10 years ago

maybe related to #2448

Actions #2

Updated by Andreas Müller 7 months ago

  • Related to bug #2448: Missing updated by/when (e.g. in PalmWeb) added
Actions #3

Updated by Andreas Müller 7 months ago

  • Related to bug #9649: Specimens sometimes have empty titleCache instead of class<UUID> added
Actions #4

Updated by Andreas Müller 7 months ago

  • Related to bug #9665: Filter out property change event for created and updated and cacheStrategy added
Actions #5

Updated by Andreas Müller 7 months ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • Target version changed from cdmlib - Old Next Major Release to Release 5.29

Check if this is fixed with #9665

Actions #6

Updated by Andreas Müller 7 months ago

  • Private changed from Yes to No
Actions #7

Updated by Andreas Müller 4 months ago

  • Priority changed from Highest to Priority14
Actions #9

Updated by Andreas Müller about 2 months ago

An empty fullTitleCache with atomized data was not found anywhere. Empty fullTitleCaches exist for fully empty data which have something like TaxonName#9617 in the titleCache. So empty fullTitleCaches are not replaced by this default yet. But maybe this is also not necessary.

Only in algaterra_old I found records with also empty titleCache which needs to be further checked. Even after running cacheUpdate and trying to edit the names manually.

SELECT id, protectedTitleCache, protectedFullTitleCache, titleCache, fullTitleCache , tn.*
    FROM TaxonName tn
    WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
    ;

    SELECT *
    FROM OriginalSourceBase osb
    WHERE osb.sourcedName_id IN (
    SELECT id
    FROM TaxonName tn
    WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
) ;

Flora Malesiana also has some but has not been cache updated (#9650) yet.

Pro-iBiosphere eupolybothrus_pilot has empty titleCache with atomized data but this has no CDM Server anymore and was not yet cache updated.
Also rl_standardliste has them but was not yet cache udpated.

Actions #10

Updated by Andreas Müller about 2 months ago

  • Status changed from Resolved to In Progress

Also Algaterra was saved correctly when the name was explicitly stored differently and then changed back.

Only remaining problem: if only a nom. ref. exists it is not saved as suche in the fullTitleCache but null is saved instead (at least this was the case for the algaterra records). This needs to be checked and corrected if necessary. In the TaxEditor this can not be seen as it is shown correctly for some reason.

Actions #11

Updated by Andreas Müller about 2 months ago

  • Description updated (diff)

Also the 2 examples from the description are handled correctly in the meanwhile.

Actions #12

Updated by Andreas Müller about 2 months ago

  • % Done changed from 0 to 30
Actions

Also available in: Atom PDF