xtcommission-1.10.x : Duplicate Sales Rep assignment exists for Sales Order lines.

xtcommission package failure on duplicateCheck.sql

BEGIN;

DELETE FROM xtcommission.coitemcom
WHERE coitemcom_id IN (SELECT coitemcom_id
FROM (SELECT coitemcom_id,
ROW_NUMBER() OVER (PARTITION BY coitemcom_coitem_id, coitemcom_salesrep_id ORDER BY coitemcom_id) AS rnum
FROM xtcommission.coitemcom) t
WHERE t.rnum > 1);

COMMIT;