My Oracle Support Banner

How to Analyze the Damaged Text Entries Detected by the ODI Repository Consistency Checker (RCC) Utility (Doc ID 1061732.1)

Last updated on MARCH 08, 2024

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.

         
  • Sunopsis V3 defects that leave orphan text entries when objects are copied/duplicated -- this causes Procedure or Knowledge Module Option usages left behind after deletion of the Procedure/Knowledge Module itself...
                 
  • etc

    • Troubleshooting Steps

    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
    Purpose
    Troubleshooting Steps
     Step 0. Backup the database.
     Step 1. Before resolving the damaged Text entries...
     Make sure you are using version 12.1.2.0.09 or more recent of the Repository Consistency Checker (RCC) utility.
     Does the ORA_DIAG_OBJ_LISTV2 table contain all the damaged Object types identified by the RCC utility?
     Get the types of damaged ODI Objects.
     Export the ORA_DIAG_OBJ_LISTV2 table into readable format.
     You might desire to change the order of records in the .csv file...
     Step 2. Analyze and purge the ORPHAN text entries.
     Step 3. Resolve the Text damages (DUP_TEXT, NO_TEXT and WRONG_TEXT).
     Resolve the NO_TEXT corruptions.
     Resolve the remaining DUP_TEXT and WRONG_TEXT text corruptions.
     Resolve the COL_DESC type issues.
     Resolve the COND type issues.
     Resolve the JOIN type issues.
     Resolve the INT_KM_OPT type issues.
     Resolve the KM_STEP type issues.
     Resolve the KM_OPT_DESC type issues.
     Resolve the KM_OPT_VALUE type issues.
     Resolve the KM type issues.
     Resolve the MEMO type issues.
     Resolve the MODEL_DESC type issues.
     Resolve the MOD_KM_OPT type issues.
     Resolve the PACK_DESC type issues.
     Resolve the POP_COL type issues.
     Resolve the POP_DESC type issues.
     Resolve the POP_JOIN type issues.
     Resolve the PROC_OPT and PROC_OPT_VALUE type issues.
     Resolve the PROC_OPT_DESC type issues.
     Resolve the PROC_STEP type issues.
     Resolve the PROC type issues.
     Resolve the STEP_OPT type issues.
     Resolve the STEP_VAR type issues.
     Resolve the STEP type issues.
     Resolve the UF type issues.
     Resolve the UF_IMPL type issues.
     Resolve the VARIABLE type issues.
     Step 4. Delete the garbage data.
    References

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