MDL Upgrade From OWB 10.2 to 11.2.0.1 Fails With CNV0002-0025(ERROR): Unexpected error occurred (Doc ID 1094324.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

The import of an OWB 10.2 mdl file fails with the following error: 

Error occurred importing from file "C:\MDL\MAPPINGS.mdl".
CNV0002-0025(ERROR): Unexpected error occurred. Upgrade terminated. See log file C:\MDL\MAPPINGS_11_2_upgrade.log for details.


When activating tracing of the Design Center as explained in <Note 943928.1>, the generated log file will report an error stack like below:

[System.out ()] 16:31:31: <DEBUG_ALL> Upgrading MAPPING MAP_MAPPING1
[System.err ()] 16:31:31: <DEBUG_ALL> java.lang.reflect.InvocationTargetException
[System.err ()] 16:31:31: <DEBUG_ALL> at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
[System.err ()] 16:31:31: <DEBUG_ALL> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[System.err ()] 16:31:31: <DEBUG_ALL> at java.lang.reflect.Method.invoke(Method.java:585)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.WBTrigger.callMethod(WBTrigger.java:157)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.WBTrigger.performOperation(WBTrigger.java:101)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.WBTrigger.preTrigger(WBTrigger.java:194)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.OutputTrigger.preTrigger(OutputTrigger.java:19)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.Output.run(Output.java:694)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.ConverterStateMachine.runAll(ConverterStateMachine.java:71)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.UpgradeMDLXMLHandler.startElement(UpgradeMDLXMLHandler.java:169)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1320)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:364)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:310)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:315)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.util.WBXMLSourceReader.parse(WBXMLSourceReader.java:59)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.ProcessXML.runConversion(ProcessXML.java:419)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.ProcessXML.run(ProcessXML.java:306)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.StateMachine.runAll(StateMachine.java:49)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.WBConverter.ConvertXML(WBConverter.java:840)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.VersionState.internalRunConversion(VersionState.java:211)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.VersionState.runConversion(VersionState.java:271)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.versions.Version10to11.runConversion(Version10to11.java:188)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.VersionState.run(VersionState.java:87)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.StateMachine.runAll(StateMachine.java:49)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.WBConverter.Convert(WBConverter.java:1142)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.WBConverter.run(WBConverter.java:4343)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.MDLRunUpgrade.runUpgrade(MDLRunUpgrade.java:158)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.ui.metadataloader.Import.MDLUpgradeImportTransaction.internalRunUpgrade(MDLUpgradeImportTransaction.java:112)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.ui.metadataloader.Import.MDLUpgradeImportTransaction.run(MDLUpgradeImportTransaction.java:317)
[System.err ()] 16:31:31: <DEBUG_ALL> Caused by: java.lang.NullPointerException
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.versions.WBUpgrade10to11.processStringPropertyValue(WBUpgrade10to11.java:2550)
[System.err ()] 16:31:31: <DEBUG_ALL> ... 29 more

[System.err ()] 16:31:31: <DEBUG_ALL> java.lang.Exception: CNV0002-0025(ERROR): Unexpected error occurred. Upgrade terminated. See log file C:\Documents and Settings\....\s2dimlocn_11_2_upgrade.log for details. Please contact

[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.ConverterStateMachine.runAll(ConverterStateMachine.java:124)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.wh.repos.pdl.metadataloader.converter.foundation.UpgradeMDLXMLHandler.startElement(UpgradeMDLXMLHandler.java:169)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1320)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:364)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:310)
[System.err ()] 16:31:31: <DEBUG_ALL> at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:315)

 

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