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 JANUARY 04, 2024
Applies to:
Oracle Data Integrator - Version 10.1.3.2.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]Information in this document applies to any platform.
Purpose
As shown in
Document 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) 10.1.3.2.0 and later Work Repositories, are used to store:
Stored information ODI 10g ODI 11.1.1.3 ODI 11.1.1.5 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
SNP_EXP_TXT SNP_EXP_TXT SNP_EXP_TXT_HEADER Scenario definition information:
- Default and current values of Scenario Variables
- Scenario Folder, Scenario and Variables Description Fields (comments)
SNP_EXP_TXT SNP_EXP_TXT SNP_EXP_TXT_HEADER Scheduled Scenarios Variable values - - SNP_EXP_TXT_HEADER Information related to Text Type Variables:
- Historized values of "Text" type Variables
SNP_EXP_TXT SNP_EXP_TXT SNP_EXP_TXT_HEADER 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
- - SNP_EXP_TXT_HEADER
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! |