NoPain , No Gain
DELETE FROM BPM_CUBE_AUDITINSTANCE A WHERE EXISTS (SELECT 1 FROM BPM_CUBE_AUDITINSTANCE B WHERE A.COMPONENTINSTANCEID = B.COMPONENTINSTANCEID AND B.OPERATION='INSTANCE_CREATED' AND B.ACTIVITYSTATUS='PROCESSED')