How to remove duplicate packages from a failed yum transaction

Issue

• How to remove the older versions of a package which has multiple versions installed on Red Hat Enterprise Linux?
• After a failed yum transaction, yum-complete-transaction fails to complete and the duplicates are still present.
• yum fails with <package_name-version1> is a duplicate with <package_name-version2>
• package-cleanup --cleandupes fails with Error: Depsolving loop limit reached