DB ORA-00060:exception when tried to delete disconnected VSE

Document ID : KB000117563
Last Modified Date : 15/10/2018
Show Technical Document Details
Issue:
We migrated from DevTest 9.1 to 10.3 database  and  Some of the data was copied over from 9.1 to the database. 

When we try to mass delete some of the disconnected VSE's from the Portal Console we are getting the below error 

Failed to delete Resource 'ssl://ABCP235:20134/VSE_CDC1_abc235_S4'. Error 400 - Error deleting resource: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resourceError Code: 60Call: DELETE FROM ACL_RESOURCES WHERE (RESOURCE_ID = ?)    bind => [1 parameter bound]Query: DeleteObjectQuery(DbResource{fullname='VSE_CDC1_abc235_S4@Default'})
Environment:
DevTest 10.3 and up
Cause:
Database contained duplicate VSE names when migrated from 9.1.  And trying to delete these duplicate entries caused the below error

org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resourceError Code: 60Call: DELETE FROM ACL_RESOURCES WHERE (RESOURCE_ID = ?) bind => [1 parameter bound]Query: DeleteObjectQuery(DbResource{fullname='VSE_CDC1_psin4p235_S4@Default'}) 
Resolution:
From the Portal-> Monitor VSE,  delete each record one by one for VSE's that had Port as 0  and Status as Disconnected. 
Do not do mass delete on these data.