| Doc ID: | 754763.1 | Type: | TROUBLESHOOTING | |
| Modified Date : | 18-JUN-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 11.1Information in this document applies to any platform.
Purpose
Attached script reports or deletes the following issues:1. PhysicalObjects referencing NamedConfigurations that do not exist as well as their 'children', 'grand-children', etc.
2. Duplicate PhysicalObjects.
In delete-mode, the script deletes all but most recent duplicate PhysicalObjects as well as their 'children', 'grand-children', etc.
3. LocationUsages referencing Locations that do not exist as well as their 'children', 'grand-children', etc.
4. Deployment and Metadata location usages having the same name.
The fix is to add '_METADATA' to location usage's name where the souceMetaDataLocation flag is true.
5. Orphaned ReferencePropertyValues
The fix is to delete Orphaned ReferencePropertyValues referencing ReferencedElements that do not exist as well as their 'children', 'grand-children', etc.
6. Delete all but most recent duplicate PropertyValues as well as their 'children', 'grand-children', etc.
Last Review Date
December 8, 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
1. Backup OWB Repository
This script modifies the repository, so make a backup of the repository for safety.
2. Read the instructions in the README of the patch
3. Download the patch
Download the script from Metalink:
Patch 7493433 PSE FOR BASE BUG 7435518 ON TOP OF 10.2.0.4 FOR LINUX/INTEL
4. Run the script as follows in SQL*Plus
For OWB 10.2:
connect <owb_repository>/<pw>
For OWB 11.1:
connect owbsys/<pw>
select name, workspaceid from cmpworkspace_v;
call owb_workspace_manager.set_workspace(wsId);
5. Example Output
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jan 13 16:33:50 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> connect owbsys/owbsys
Connected.
SQL> select name, workspaceid from cmpworkspace_v;
NAME WORKSPACEID
------------------------- -----------
GLOBAL_WORKSPACE 1
OWB11GWS 2
WSPRODUCTION 22
SQL> call owb_workspace_manager.set_workspace(2);
Call completed.
SQL> @c:\bug7435518
Report Only? (Y/N=Report+Fix):[N]
Test Mode? (Y=rollback/N=commit):[Y] N
Warning: Turning show key info on could result in extremely large output volume
Tip: Running in report only mode with row info set to FALSE will allow you to
determine row counts first.)
Show detail info for found rows? (Y=show/N=hide):[N]
Review above entries and press
<ENTER> to continue or Ctrl-C to cancel
Start Bug7435518 Customer Critical Issues Repository Cleaning ...
Type created.
old 155: IF '&V_REPORTONLY' = 'N' THEN -- DEFAULT 'N' PROMPT 'Report Only? (Y/N=Report+Fix):[N] '
new 155: IF 'N' = 'N' THEN -- DEFAULT 'N' PROMPT 'Report Only? (Y/N=Report+Fix):[N] '
old 160: IF '&V_TESTING' = 'N' THEN -- DEFAULT 'Y' PROMPT 'Test Mode? (Y=rollback/N=commit):[Y] '
new 160: IF 'N' = 'N' THEN -- DEFAULT 'Y' PROMPT 'Test Mode? (Y=rollback/N=commit):[Y] '
old 165: IF '&V_SHOWROWS' = 'Y' THEN -- DEFAULT 'N' PROMPT 'Show detail info for found rows? (Y=show/N=hide):[N] '
new 165: IF 'N' = 'Y' THEN -- DEFAULT 'N' PROMPT 'Show detail info for found rows? (Y=show/N=hide):[N] '
old 170: putMsg('Starting (Report Only = ' || '&V_REPORTONLY' || ', Testing = ' || '&V_TESTING' ||
new 170: putMsg('Starting (Report Only = ' || 'N' || ', Testing = ' || 'N' ||
old 171: ', Show Row Detail = ' || '&V_SHOWROWS' || ') ...' || EOL); -- add blank line after
new 171: ', Show Row Detail = ' || 'N' || ') ...' || EOL); -- add blank line after
13-JAN-09 04.34.45.484000000 PM +01:00 Bug7435518: DBMS_OUTPUT Enabled.
13-JAN-09 04.34.45.484000000 PM +01:00 Bug7435518: Starting (Report Only = N, Testing = N, Show Row Detail = N) ...
13-JAN-09 04.34.45.484000000 PM +01:00 Bug7435518: Issue: Orphaned PhysicalObjects...
13-JAN-09 04.34.45.484000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.34.45.484000000 PM +01:00 Bug7435518: 0 Orphaned PhysicalObjects
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Owned PropertyValues
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue: Duplicate PhysicalObjects...
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Duplicate PhysicalObjects
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Owned PropertyValues
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Owned CFAs
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue: Orphaned LocationUsages...
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Orphaned LocationUsages
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue: Duplicate LocationUsages...
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Duplicate LocationUsages
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue: Deployment and Metadata location usages have same name...
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: 0 Metadata LocationUsages without "_METADATA" name suffix
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: Issue: Orphaned ReferencePropertyValues...
13-JAN-09 04.34.45.500000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.38.58.078000000 PM +01:00 Bug7435518: 0 Orphaned ReferencePropertyValues
13-JAN-09 04.38.58.078000000 PM +01:00 Bug7435518: 0 Owned PropertyValues
13-JAN-09 04.38.58.078000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.38.58.078000000 PM +01:00 Bug7435518: Issue: Duplicate PropertyValues...
13-JAN-09 04.38.58.078000000 PM +01:00 Bug7435518: FOUND:
13-JAN-09 04.38.58.093000000 PM +01:00 Bug7435518: 0 Duplicate PropertyValues
13-JAN-09 04.38.58.093000000 PM +01:00 Bug7435518: 0 Owned PropertyValues
13-JAN-09 04.38.58.093000000 PM +01:00 Bug7435518: Issue processing completed.
13-JAN-09 04.38.58.093000000 PM +01:00 Bug7435518: Processing completed.
PL/SQL procedure successfully completed.
End of the cleaning.
SQL>
0 ความคิดเห็น:
แสดงความคิดเห็น