SQL Error During TMS Thesaurus Validation ORA-20000: 700100-Please Register Instance by Running TMS_USER_SYNCHRONIZATION
(Doc ID 789252.1)
Last updated on DECEMBER 05, 2019
Applies to:Oracle Thesaurus Management System - Version 4.6.0 and later
Information in this document applies to any platform.
***Checked for currency: 14-Jan-2015***
When attempting to Run a Batch Validation in Oracle Clinical after a new install of TMS on the same Database, it is failing with the error below:
Batch Start: 09-MAR-2009 16:18:21
Batch Validation at <DATABASE NAME> for Study <STUDY NAME> owned by <DATABASE NAME>
0 DVG discrepancies processed, 0 became obsolete, 0 changed to DVG Subset
0 DVG Subset discrepancies processed, 0 became obsolete
0 Thesaurus Terms discrepancies processed, 0 became obsolete
0 Data Type discrepancies processed, 0 became obsolete
0 Length discrepancies processed, 0 became obsolete
No modified univariate question definitions since last execution.
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Error during TMS Thesaurus Validation
Batch Validation aborted due to an error
SQL error during TMS Thesaurus Validation: SQLERROR ORA-20000: 700100-Please register instance by running tms_user_synchro...
Steps To Reproduce:
- Log into Installation
- Follow the TMS Installation Smoke Test Documentation
- As part of test 9 it is required that a Batch Validation session is run
- Job fails and resulting .out file shows above error as cause of failure
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