| Doc ID: | 357559.1 | Type: | TROUBLESHOOTING | |
| Modified Date : | 22-JAN-2009 | Status: | PUBLISHED | |
In this Document
Purpose
Last Review Date
Instructions for the Reader
Troubleshooting Details
References
Applies to:
Oracle Warehouse Builder - Version: 9.0.4 to 10.1Information in this document applies to any platform.
OWB 9.0.4 - 10.1.0.x
Purpose
This note describes how to collect diagnostical information from the OWB Design Repository (9.0.4 - 10.1)The collection can be done automatically by means of a script that is attached to this note. The script checks for the existence of known issues regarding inconsistency and mentions where applicable the bugnumber where to find more details about the issue. When a patch is available to fix the issue, this is also mentioned in the output.
Following bug checks are included:
- Bug 2700326 api0408: stage component object with name uitbreiding already exists
- Bug 3421798 rtc-5161 when trying to deploy process flow
- Bug 3079762 java.lang.nullpointerexception when opening mapping
Last Review Date
November 21, 2008Instructions for the Reader
A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.
Troubleshooting Details
Caution
This script is for OWB 9.0.4, 9.2 and 10.1 only!
The healthcheck script for OWB 10.2 can be found here:
Note 559542.1 Health Check of the Oracle Warehouse Builder 10.2 Metadata Repository
The healthcheck script for OWB 10.2 can be found here:
Note 559542.1 Health Check of the Oracle Warehouse Builder 10.2 Metadata Repository
This script provided in this note is for diagnostical purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.Usage
1. Download OWB healthcheck script: owbhealthcheck_10_1.sql
2. Execute the script from SQL*Plus when connected with an OWB Design Repository account.
connect <owbrepository>/<password>
spool owbhealthcheck_10_1.txt
spool off
3. When any issues are listed by the script, the following additional scripts might be required
- To fix Bug 2700326, download fix2700326.sql
- To fix Bug 3421798, download fix3421798.sql
- To fix Bug 3079762, download fix3079762.sql
4. Example output.
SQL> @C:\SCRIPTS\healthcheck\owbhealthcheck_10_1.sql
DATA COLLECTED
==============
HEALTHCHECK101.SQL : 1.0.3
Executed by : owb10104
OWB release : 10.1.0.4.0
Collection time : 21-nov-2008 16:37:38
==================================================================
Searching for Duplicate StageLogicalNames and Duplicate Parameters
Bug : 2700326
Patch : fix2700326.zip provided in Note 357559.1
==================================================================
Searching for Duplicate StageLogicalNames...
==>Verified: No objects found.
Searching for Duplicate Parameters...
==>Verified: No objects found.
Searching for Physical objects that have siblings
Bug : 3421798
Patch : fix3421798.sql provided in Note 357559.1
=================================================
==>Verified: No objects found.
Searching for StageComponents without operatortype
Bug : 3079762
Patch : fix3079762.sql provided in Note 357559.1
==================================================
Searching for StageComponents without operatortype...
==>Verified: No objects found.
Searching for MNS_New StageComponents, having no
stagecomponent in cmpmappingparametergroup_v...
==>Verified: No objects found.
SQL>
References
Bug 3079762 - JAVA.LANG.NULLPOINTEREXCEPTION WHEN OPENING MAPPINGBug 3421798 - RTC-5161 WHEN TRYING TO DEPLOY PROCESS FLOW
Note 559542.1 - Health Check of the Oracle Warehouse Builder 10.2 Metadata Repository
0 ความคิดเห็น:
แสดงความคิดเห็น