Solution : https://service.sap.com/sap/support/notes/1640166 (SAP Service marketplace login required)
Key words : 
mass delete lock, unsuccessful execution caused, support package relevant, relevant support packages, attached correction instructions, reason code 00c9008e, service connection leads, 00c9008e reason, service connection, primary connection
Related Notes : 
       
| 1692919 | 7.30:DSO activation fails due to db lock on activation table | 
| 1636053 | Upgrade to SAP NetWeaver 7.30: BW server: Useful SAP Notes |