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***

Symptoms

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


Cause

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