| Doc ID: | 559542.1 | Type: | TROUBLESHOOTING | |
| Modified Date : | 07-JUL-2009 | Status: | PUBLISHED | |
In this Document
Purpose
Last Review Date
Instructions for the Reader
Troubleshooting Details
References
Applies to:
Oracle Warehouse Builder - Version: 10.2 to 10.2Information in this document applies to any platform.
This script is intended for OWB 10.2.
Purpose
This note describes how to collect diagnostic information of the OWB Design Repository.
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. Where applicable the script lists a note number where to find out more details about the issue and how to fix the it.
Last Review Date
January 19, 2009Instructions 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 provided in this note is for diagnostic 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.1. Download OWB healthcheck script
Download the script here...
2. Execute the script
Before running the script, it is required to connect to the OWB Repository.
connect <owbrepository>/<password>
spool owbhealthcheck.txt
spool off 3. Notes containing information and fixes
Where applicable the script lists a note number where to find out more details about the issue and how to fix the it. The following notes are referred to by the script :
Note 460411.1 Opening Map Returns Cannot find ACL Containter for Object
Note 754763.1 Repository Cleanup Script for OWB 10.2 and OWB 11.1
Note 761975.1 Process Flow Activities are Executed in Incorrect Order
4. Example output
SQL> connect owb10204/owb10204@o10g
Connected.
SQL> @c:\scripts\owb11g\owbhealthcheck
DATA COLLECTED
==============
OWBHEALTHCHECK.SQL 1.0.5
Running from host : localhost
Instance Name : o10g. Version 10.2.0.4.0
Executed by : owb10204
OWB release : 10.2.0.4
Collection time : 19-jan-2009 16:17:41
======================================================
Searching for:
+ Orphaned PhysicalObjects
+ Duplicate PhysicalObjects
+ Orphaned LocationUsages
+ Duplicate LocationUsages
+ Deployment and Metadata location usages have same name
+ Orphaned ReferencePropertyValues
+ Duplicate PropertyValues
.
Note 754763.1 Repository Cleanup Script for OWB 10.2 and OWB 11.1
=================================================================
Issue: Orphaned PhysicalObjects...
FOUND:
1 Orphaned PhysicalObjects
2 Owned PropertyValues
Issue processing completed.
Issue: Duplicate PhysicalObjects...
FOUND:
1 Duplicate PhysicalObjects
3 Owned PropertyValues
0 Owned CFAs
Issue processing completed.
Issue: Orphaned LocationUsages...
FOUND:
3 Orphaned LocationUsages
Issue processing completed.
Issue: Duplicate LocationUsages...
FOUND:
0 Duplicate LocationUsages
Issue processing completed.
Issue: Deployment and Metadata location usages have same name...
FOUND:
0 Metadata LocationUsages without "_METADATA" name suffix
Issue processing completed.
Issue: Orphaned ReferencePropertyValues...
FOUND:
25 Orphaned ReferencePropertyValues
0 Owned PropertyValues
Issue processing completed.
Issue: Duplicate PropertyValues...
FOUND:
2 Duplicate PropertyValues
0 Owned PropertyValues
Issue processing completed.
Processing completed.
Searching for Duplicate Transitions in Process Flows
Note 761975.1 Process Flow Activities are Executed in Incorrect Order
=====================================================================
Project [MIP] Module [OWF_MODULE]
...Package [SPX_DWH] Process [DWH_SPX_LAAD_01]
dumpProcessInformation - 5.1 - source Activity[2366330]
dumpProcessInformation - 5.2 - source name [MAP_SPX_ACTIEFUNCTIES]
dumpProcessInformation - 5.3 - targetActivity [2366322]
dumpProcessInformation - 5.4 - Target name [END_ERROR]
......Invalid Transition [MAP_SPX_ACTIEFUNCTIES--->END_ERROR]
dumpProcessInformation - 5.1 - source Activity[2366330]
dumpProcessInformation - 5.2 - source name [MAP_SPX_ACTIEFUNCTIES]
dumpProcessInformation - 5.3 - targetActivity [2366324]
dumpProcessInformation - 5.4 - Target name [END_WARNING]
......Invalid Transition [MAP_SPX_ACTIEFUNCTIES--->END_WARNING]
.
Project [MIP] Module [OWF_MODULE]
...Package [SPX_DWH] Process [DWH_SPX_LAAD_01]
dumpProcessInformation - 5.1 - source Activity[2366330]
dumpProcessInformation - 5.2 - source name [MAP_SPX_ACTIEFUNCTIES]
dumpProcessInformation - 5.3 - targetActivity [2366317]
dumpProcessInformation - 5.4 - Target name [AND01]
......Invalid Transition [MAP_SPX_ACTIEFUNCTIES--->AND01]
dumpProcessInformation - 5.1 - source Activity[2366330]
dumpProcessInformation - 5.2 - source name [MAP_SPX_ACTIEFUNCTIES]
dumpProcessInformation - 5.3 - targetActivity [2366324]
dumpProcessInformation - 5.4 - Target name [END_WARNING]
......Invalid Transition [MAP_SPX_ACTIEFUNCTIES--->END_WARNING]
Processing completed.
Searching for objects with lost ACL Container...
Note 460411.1 Opening Map Returns Cannot find ACL Containter for Object
=======================================================================
Project: Admin Project, projId: 24246
==>Verified and OK
Project: PUBLIC_PROJECT, projId: 26434
==>Verified and OK
Project: MY_PROJECT, projId: 26635
==>Verified and OK
Project: WAREHOUSE, projId: 26801
==>Verified and OK
Processing completed.
References
Note 460411.1 - Trying to Open/Edit/Rename/Delete a Mapping Returns "Internal ERROR: Can not find the ACL Containter for Object" ErrorsNote 754763.1 - Repository Cleanup Script for OWB 10.2 and OWB 11.1
Note 761975.1 - Process Flow Activities are Executed in Incorrect Order
0 ความคิดเห็น:
แสดงความคิดเห็น