My Oracle Support Banner

Identifying Corrupted Objects Related To Non-existing Records In The ODI SNP_EXP_TXT/SNP_EXP_TXT_HEADER Work Repository Table (Doc ID 751142.1)

Last updated on OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


As shown in

<Note:749487.1> - How To Determine Orphan Records From The ODI SNP_EXP_TXT/SNP_EXP_TXT_HEADER Work Repository Table

The SNP_EXP_TXT and SNP_EXP_TXT_HEADER tables which are located in the Oracle Data Integrator (ODI) and later Work Repositories, are used to store:

Stored informationODI 10gODI and later
Error messages which indicate that the Session (execution) was unable to start. SNP_EXP_TXT SNP_EXP_TXT SNP_EXP_TXT_HEADER
Error messages related to the Graphical User Interface or one object, aside executions (example: com.sunopsis.core.i: Invalid object, it has been updated by another user) SNP_EXP_TXT SNP_EXP_TXT SNP_EXP_TXT_HEADER
Execution related records, such as:
  • Session Parameters and Keywords
  • Session, Step and Task warnings and error messages
  • Scenario Reports
  • Default and current values of Session Variables
Scenario definition information:
  • Default and current values of Scenario Variables
  • Scenario Folder, Scenario and Variables Description Fields (comments)
Scheduled Scenarios Variable values - - SNP_EXP_TXT_HEADER
Information related to Text Type Variables:
  • Historized values of "Text" type Variables

Load Plan related information, such as:

  • Load Plan, Load Plan Instance, Load Plan Step, and Load Plan Execution Descriptions (comments)
  • Load Plan, Load Plan Instance, Load Plan Step, and Load Plan Execution Variables
  • Load Plan, Load Plan Instance, Load Plan Step, and Load Plan Execution Error messages

It may happen that some of these Objects (Sessions, Scenarios, Scenario Folders, Variables) contain references to no more existing records in SNP_EXP_TXT/SNP_EXP_TXT_HEADER table.

The goal of this document is to identify such corrupted Objects and to clean up incorrect values.

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
Troubleshooting Steps
 Step 1. Stop all Oracle Data Integrator processes.
 Step 2. Identify the corrupted records.
 Step 3. Backup the database.
 Step 4. Connect to the Work Repository.
 Step 5. Analyze the corrupted records.
 Step 6. Reset the incorrect references to SNP_EXP_TXT or SNP_EXP_TXT_HEADER records.

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