Repository Cleanup Script for Oracle Warehouse Builder(OWB) 11.2
(Doc ID 1153357.1)
Last updated on OCTOBER 26, 2023
Applies to:
Oracle Warehouse Builder - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Purpose
The Repository cleanup script for Oracle Warehouse Builder (OWB) 11.2 reports or fixes 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.
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! |