Magento 2.3 re-index failing for sales rule index

Magento Asked by Ajith on November 30, 2020

When I trying to re-index salesrule_rule index, It gives me bellow error and the sales rule grid is not loading in magento admin. Please advice.

Item (MagentoSalesRuleModelRuleInterceptor) with the same ID "165" already exists.

Attached is the MySQL result when I run query to see all the rules having 165 as rule_id

enter image description here

Add your own answers!

Ask a Question

Get help from others!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP