Project

General

Profile

Actions
Copy link

bug #9649

closed

Specimens sometimes have empty titleCache instead of class<UUID>

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

Status:
Closed
Priority:
New
Assignee:
Andreas Müller
Category:
cdmlib
Target version:
Release 5.25
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:
Tags:
formatting fast

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
Copy link
 #1

Updated by Andreas Müller over 2 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
Copy link
 #2

Updated by Andreas Müller over 2 years ago

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

Updated by Andreas Müller over 2 years ago

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

Updated by Andreas Müller over 2 years ago

  • Status changed from New to In Progress

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

Actions
Copy link
 #5

Updated by Andreas Müller over 2 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
Copy link
 #6

Updated by Andreas Müller about 2 years ago

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

Updated by Andreas Müller almost 2 years ago

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

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
Copy link
 #9

Updated by Andreas Müller almost 2 years ago

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

This issue seems to be fixed with #9665

Actions
Copy link

Also available in: Atom PDF