Upgrade to OWB 11.2.0.1 Fails With INS0074: Error ocurred upgrading repository (Doc ID 1077387.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Upgrading a repository to OWB 11.2.0.1 using the Repository Assistant, fails with:

INS0074: Error ocurred upgrading repository


Error stack:

org.xml.sax.SAXException:MDL1261: Error importing OWBAssoc_ReferencingObject
MDW.FNDDW.MAINTAIN_CONS_SALES_DIRECT.DELETE_RECOGNIZED_UER (IN DATE).
Detailed Error Message:
java.lang.Exception: Error at line 228,403: MDL1261: Error importing
OWBAssoc_ReferencingObject
MDW.FNDDW.M_CONS_SALES_DIRECT.DELETE_RECOGNIZED_UER.MDW.FNDDW.MAINTAIN_CONS_S
ALES_DIRECT.DELETE_RECOGNIZED_UER (IN DATE).
Detailed Error Message:
Object of id 99,029 does not exist in the database. It could have been deleted in another session.
at
oracle.wh.repos.pdl.metadataloader.converter.foundation.ConverterStateMachine.runAll(ConverterStateMachine.java:140)
at
oracle.wh.repos.pdl.metadataloader.converter.foundation.ProcessXML$ConvertHandlerBase.startElement(ProcessXML.java:196)

 

Note: The progress indicator percentage can indicate a different percentage on every attempt.

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