Transaction Deadlock In OSM (Doc ID 1337854.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 and later
Information in this document applies to any platform.

Symptoms

Transaction deadlock in OSM and is returning the following exceptions:

<Jun 17, 2011 12:39:36 PM GMT+08:00> <Error> <oms.core> <600129> <SQL Exception 60 : ORA-00060: deadlock detected while waiting for resource
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
<Jun 17, 2011 12:39:40 PM GMT+08:00> <Error> <oms.automation> <700023> <An automation exception has occurred At TaskContextBean: completedOrder:115753, orderHistID:347233380, completionStatus: finish , the reason is :com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
<Jun 17, 2011 12:39:40 PM GMT+08:00> <Error> <oms.automation> <700023> <An automation exception has occurred At AutomationDispatcherImpl.runAutomator:/automation/plugin/internal/task/TM_NonConsumer/3.001/Set_Device_Name/do , the reason is :com.mslv.oms.automation.AutomationException: com.mslv.oms.automation.AutomationException: com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
com.mslv.oms.automation.AutomationException: com.mslv.oms.automation.AutomationException: com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
com.mslv.oms.automation.AutomationException: com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
com.mslv.oms.handler.InternalErrorException: ORA-00060: deadlock detected while waiting for resource
: ORA-00060: deadlock detected while waiting for resource
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource

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