Batch Validation Job Fails with 'TMS Internal Error Thesaurus Corrupted' Error.
(Doc ID 2904146.1)
Last updated on OCTOBER 26, 2022
Applies to:
Oracle Clinical - Version 5.2.1 and laterOracle Thesaurus Management System - Version 5.3.0 and later
Information in this document applies to any platform.
Symptoms
1)
Batch Validation Job Fails with 'TMS Internal ErrorThesaurus Corrupted' Error i.e. the Batch Validation log file contains:
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
TMS Internal ErrorThesaurus Corrupted
Report to TMS Administrator.
Batch Validation aborted due to an error
calling TMS_OCL_DERV.DERIVATION first time
TMS Internal ErrorThesaurus Corrupted
Report to TMS Administrator.
Batch Validation aborted due to an error
2)
OPA_DEBUG output contains the 'New term came in with same Sid, and owner is not tms' error message when processing the 'DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ' term:
gVtUpper: DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ CAPSULE, gIndUpper=
No lookup of dict dom
pTerm=DIAMMONIUM GLYCYRRHIZINATE ENTERIC-COATED CAPSULE st_id=31xxx06 action_text=Medication DIAMMONIUM� GLYCYRRHIZINATE� ENTERIC-COATED� CAPSULE contains special characters which must be removed before the term can code. action_owner=OPS$OPAADMIN aux_info_id= ind_upper=
Entering... st_id=31xxx06 occ_id=0 gInstanceId=1 DefIntKey=OCL term= aux_id= indUpper= dict_id= dom_id= omis_stat=INV REVIEW action_text=Medication DIAMMONIUM� GLYCYRRHIZINATE� ENTERIC-COATED� CAPSULE contains special characters which must be removed before the term can code. action_owner=OPS$XXX owning_app= vtaId=
in bUpdate. OldVtOmissionRec: term_upper=DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ CAPSULE aux_info_id= indication_upper= dict_id=2173769 dom_id=102 omis_stat=INV REVIEW action_text=The reported term DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ CAPSULE contains nonstandard characters. Please delete and re-enter the term. When updating the term please remove all extra spaces, non-standard characters, accent marks. action_owner=OPS$XXX owning_app=TMS
New term came in with same Sid, and owner is not tms
No lookup of dict dom
pTerm=DIAMMONIUM GLYCYRRHIZINATE ENTERIC-COATED CAPSULE st_id=31xxx06 action_text=Medication DIAMMONIUM� GLYCYRRHIZINATE� ENTERIC-COATED� CAPSULE contains special characters which must be removed before the term can code. action_owner=OPS$OPAADMIN aux_info_id= ind_upper=
Entering... st_id=31xxx06 occ_id=0 gInstanceId=1 DefIntKey=OCL term= aux_id= indUpper= dict_id= dom_id= omis_stat=INV REVIEW action_text=Medication DIAMMONIUM� GLYCYRRHIZINATE� ENTERIC-COATED� CAPSULE contains special characters which must be removed before the term can code. action_owner=OPS$XXX owning_app= vtaId=
in bUpdate. OldVtOmissionRec: term_upper=DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ CAPSULE aux_info_id= indication_upper= dict_id=2173769 dom_id=102 omis_stat=INV REVIEW action_text=The reported term DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ CAPSULE contains nonstandard characters. Please delete and re-enter the term. When updating the term please remove all extra spaces, non-standard characters, accent marks. action_owner=OPS$XXX owning_app=TMS
New term came in with same Sid, and owner is not tms
Changes
Upgraded from a pre-TMS 5.1.2.2 release to TMS 5.3.1 (where the 'DIAMMONIUMÂ GLYCYRRHIZINATEÂ ENTERIC-COATEDÂ' term was entered / omission created in the pre-upgrade release).
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 |