Project

General

Profile

Actions

bug #9649

closed

Specimens sometimes have empty titleCache instead of class<UUID>

Added by Andreas Müller almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
New
Category:
cdmlib
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:

Description

E.g. in additiviy_ontology after running titleCache update for records 72 and 74


Related issues

Related to EDIT - bug #9665: Filter out property change event for created and updated and cacheStrategy ClosedAndreas Müller

Actions
Related to EDIT - task #9650: Update all titleCaches after upgrade of cache strategies and formattersIn ProgressAndreas Müller

Actions
Related to EDIT - bug #2449: Some or many names have an empty fullTitleCache though information is atomizedIn ProgressAndreas Müller

Actions
Actions #1

Updated by Andreas Müller almost 3 years ago

  • Subject changed from Specimen sometimes have empty titleCache instead of class<UUID> to Specimens sometimes have empty titleCache instead of class<UUID>
Actions #2

Updated by Andreas Müller almost 3 years ago

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

Updated by Andreas Müller almost 3 years ago

  • Related to task #9650: Update all titleCaches after upgrade of cache strategies and formatters added
Actions #4

Updated by Andreas Müller almost 3 years ago

  • Status changed from New to In Progress

Maybe fixed by #9665 . Need to check after release if this still happens.

Actions #5

Updated by Andreas Müller almost 3 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 30

Set to resolved in case #9665 fixed the issue.

Actions #6

Updated by Andreas Müller almost 3 years ago

  • Related to bug #2449: Some or many names have an empty fullTitleCache though information is atomized added
Actions #8

Updated by Andreas Müller over 2 years ago

  • Status changed from Resolved to In Progress
  • Target version changed from Release 5.25 to Release 5.45

There are still records in fdac, which is not supported anymore and did not run cache updates.

    SELECT *
    FROM SpecimenOrObservationBase sob
    WHERE sob.titleCache = '' OR sob.titleCache IS NULL AND sob.protectedTitleCache = 1;

    SELECT *
    FROM SpecimenOrObservationBase_AUD sob
    WHERE sob.id IN (   SELECT id
    FROM SpecimenOrObservationBase sob
    WHERE sob.titleCache = '' OR sob.titleCache IS NULL)
Actions #9

Updated by Andreas Müller over 2 years ago

  • Status changed from In Progress to Closed
  • Target version changed from Release 5.45 to Release 5.25
  • % Done changed from 30 to 100

This issue seems to be fixed with #9665

Actions

Also available in: Atom PDF