The problem occurred due to improper drop scripts. Re installing the package caused the whole site to screw up as I was running dotlrn which depends heavily on service contracts to display portlets.
I believe there is another table acs_sc_operations which lacks constraint for uniquely identifying a operation on contract_name and operation_name. There are quite a few procs depending on this condition.
