OWB 11.2 Repository Assistant Hangs at 95% During Export of Entire Repository (Doc ID 1282091.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Exporting an OWB 10g Repository using the OWB 11.2 Repository Assistant, hangs with Progress Indicator at 95%.

Inspecting the log file in <OWB_home>\owb\UnifiedRepos shows that the process is hanging on the export of WB_IE_AUDIT_SCRIPTS:

exportCCView ViewName:WB_IE_AUDIT_PARAMETER_DEFAULTS
MEMORY DETAILS fm=44503104 tm=151597056 um=107093952
WB_IE_AUDIT_PARAMETER_DEFAULTS Query:-select AUDIT_TASK_ID as AUDIT_TASK_ID...
>> exportCCView ViewName: WB_IE_AUDIT_PARAMETER_DEFAULTS elapsed=5140
>> exportCCView ViewName:WB_IE_AUDIT_SCRIPTS
MEMORY DETAILS fm=40560168 tm=151597056 um=111036888
WB_IE_AUDIT_SCRIPTS Query:-select AUDIT_SCRIPT_ID as AUDIT_SCRIPT_ID, AUDIT_STATUS...
>>>>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms