Trying to remove a user from a DAG, getting the error: ORA-01403: no data found -

(Doc ID 2285143.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Thesaurus Management System - Version 5.0.1 to 5.1.2 [Release 5.0 to 5.1]
Information in this document applies to any platform.

Symptoms

When trying to remove a user from a DAG, your getting the error:

ORA-01403: no data found

FRM-40735: ON-DELETE trigger raised unhandled exception
ORA-01403.

This is happening for all Users, and the Users have all the correct TMS roles assigned.

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