Errors RME-20 ORA-1403 ORA-6512 (SDD_TAB_D) ORA-4088 CDR-2000 RME-11 RME-222 When Deleting A Table From The Design Editor (Doc ID 279288.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version 6.5 to 9.0 [Release Designer 6i]
Information in this document applies to any platform.
Design Editor (DE)

"Checked for relevance on 08-Apr-2011"


Symptoms

Trying to delete a specific table from the Design Editor fails with the following errors:

RME-00020: Internal API error - ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "<Repository_Owner>.SDD_TAB_D", line 969
ORA-04088: error during execution of trigger '<Repository_Owner>.SDD_TAB_D'
CDR-02000: Cannot delete Table Definition <Application_Name>/<Table_Name>
RME-00011: Operation 'del' on TABLE_DEFINITION has failed
RME-00222: Failed to dispatch operation to Repository
RME-00222: Failed to dispatch operation to Repository
The table appears in a special color in the navigator of the DE.
Trying to add a column to this table fails with the following errors:
RME-00020: Internal API error - ORA-20291: integrity constraint (SDD_COL_OWNER) violated - parent key not found
ORA-06512: at "<Repository_Owner>.SDD_COL_BR", line 39
ORA-04088: error during execution of trigger <Repository_Owner>.SDD_COL_BR'
RME-00011: Operation 'ins' on COLUMN has failed
RME-00222: Failed to dispatch operation to Repository


NB: same errors can occur for other Designer objects.

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