My Oracle Support Banner

Repository Cleanup Script for OWB 10.2 (Doc ID 754763.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Warehouse Builder - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Purpose

The Repository Cleanup script can be used for all OWB 10.2 versions. The 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.


Although the patch description mentions version 10.2.0.5, the script in this patch can be used for all OWB 10.2 versions.



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
Purpose
Troubleshooting Steps
References

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