Multiple Errors In The 'PREDICT' Tables When Upgrading the 'WHODrug' Dictionary.
(Doc ID 3064588.1)
Last updated on DECEMBER 24, 2024
Applies to:
Oracle Thesaurus Management System - Version 5.4.1 and laterInformation in this document applies to any platform.
Symptoms
1)
Unable to successfully upgrade the 'WHODrug' Dictionary (the September 2024 update was being applied).
2)
This worked fine on a different server but not on this one.
3)
It was determined Activation (in TRANSFER mode) has returned multiple errors in the 'PREDICT' tables:
i.
TMS_PREDICT_CONTENTS table contains multiple occurrences of errors like the below:
- Missing mandatory relation between ATC3-ATC4
- Missing mandatory relation between ATC2-ATC3
- Missing mandatory relation between ATC1-ATC2
- Cannot delete record with related active relations
ii.
TMS_PREDICT_RELATIONS table contains multiple occurrences of errors like the below:
- Missing mandatory relation between ATC3-ATC4
- Missing mandatory relation between ATC3-ATC4 (<pre/dict_content_id>)
- Missing mandatory relation between ATC2-ATC3
- Missing mandatory relation between ATC2-ATC3 (<pre/dict_content_id>)
- Missing mandatory relation between ATC1-ATC2
- Missing mandatory relation between ATC1-ATC2 (<pre/dict_content_id>)
- Cannot delete record with related active relations
4)
An unusual amount of PREDICT DML data (Inserts / Updates / Deletes) had been created for this quarterly WHODrug dictionary update i.e.
- TMS_PREDICT_CONTENTS table contained 1,444 error records:
ERROR_MSG COUNT(*) -------------------------------------------------- ---------- Cannot delete record with related active relations 7 Missing mandatory relation between ATC1-ATC2 98 Missing mandatory relation between ATC2-ATC3 291 Missing mandatory relation between ATC3-ATC4 1048
- TMS_PREDICT_RELATIONS table contained 187,267 error records:
ERROR_MSG COUNT(*) ------------------------------------------------------------------ ---------- Cannot delete record with related active relations 7 Missing mandatory relation between ATC1-ATC2 45,054 Missing mandatory relation between ATC1-ATC2 (<pre/dict_content_id>) 1,075 Missing mandatory relation between ATC2-ATC3 8,896 Missing mandatory relation between ATC2-ATC3 (<pre/dict_content_id>) 64 Missing mandatory relation between ATC3-ATC4 131,866 Missing mandatory relation between ATC3-ATC4 (<pre/dict_content_id>) 305
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |