My Oracle Support Banner

Migration Fails when Running Migration.jar - Error Raised: "ORA-00060: deadlock detected while waiting for resource" (Doc ID 2447922.1)

Last updated on SEPTEMBER 21, 2018

Applies to:

Oracle Enterprise Data Quality - Version 8.1.9 and later
Information in this document applies to any platform.

Symptoms

Migration fails when running migration.jar as part of an upgrade (i.e. $ java -jar migration.jar -db '{database=jdbc:oracle:thin:@dbhost:1521/dbservice,type=oracle}'/edqconfig/password)

The following error is logged:
-----------------------
Migrated 2860000 of 25142490 items in 5.164000s
Migrated 2865000 of 25142490 items in 4.299000s
Migrated 2870000 of 25142490 items in 4.241000s
Migrated 2875000 of 25142490 items in 4.052000s
Migrated 2880000 of 25142490 items in 5.660000s
org.xml.sax.SAXException: An error occurred with the key migration : ORA-00060: deadlock detected while waiting for resource
(Code: 300,550)
com.datanomic.director.casemigration.errors.MigrationException: An error occurred with the key migration : ORA-00060: deadlock detected while waiting for resource
(Code: 300,550)
org.xml.sax.SAXException: An error occurred with the key migration : ORA-00060: deadlock detected while waiting for resource
(Code: 300,550)
com.datanomic.director.casemigration.errors.MigrationException: An error occurred with the key migration : ORA-00060: deadlock detected while waiting for resource
(Code: 300,550)
at com.datanomic.director.casemigration.xml.MigrationParser.startElement(MigrationParser.java:194)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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