My Oracle Support Banner

ORA-01422 When Batch Validation is Running TMS Derivation Process (Doc ID 793525.1)

Last updated on AUGUST 29, 2014

Applies to:

Oracle Thesaurus Management System - Version 4.5.1 and later
Information in this document applies to any platform.
.
***Checked for relevance on 07-DEC-2010***
***Checked for relevance on 29-Aug-2014***

Symptoms

On TMS 4.5.1 in Production:
When attempting to run Batch Validation the following warning is appearing at the end of the log file:

ERROR

Batch Validation Completed with warnings due to TMS or Procedure execution or generation SQL error during TMS Thesaurus Validation: SQLERROR ORA-01422: exact fetch returns more than requested number of rows
ORA-

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
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.