SQL Error During TMS Thesaurus Validation ORA-20000: 700100-Please Register Instance by Running TMS_USER_SYNCHRONIZATION

(Doc ID 789252.1)

Last updated on SEPTEMBER 01, 2016

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:


Connecting... Connected.
Batch Start: 09-MAR-2009 16:18:21
Batch Validation at DATABASE_A for Study OLSQA owned by DATABASE_A


Number of patients with modified data: 0


DVG, DVG Subset, Thesaurus Resolution
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


Modified Univariate Validation Resolution
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:


  1. Log into Installation
  2. Follow the TMS Installation Smoke Test Documentation
  3. As part of test 9 it is required that a Batch Validation session is run
  4. Job fails and resulting .out file shows above error as cause of failure


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms