Migration error: Integrity constraint violation

Problem/Motivation

While performing migration of a single media type "[DEPRECATED] Acquia DAM Image" (machine name: acquia_dam_image) to "Acquia DAM: Image" (machine name: acquia_dam_image_asset) using Drush command acquiadam:migrate we are consistently getting following error and attempt fails:

>  [notice] The following operations has been performed on the acquia_dam_image media type during the Acquia DAM migration: renaming from “[DEPRECATED] Acquia DAM Image” to “[DEPRECATED] Acquia DAM Image”, fetch method switched to “embed”, replacing its source plugin from “acquiadam_asset” to “acquia_dam_asset:image”.
>
> In ExceptionHandler.php line 45:
>
>   SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6279
>   1-0-0-en' for key 'PRIMARY': INSERT INTO "media__acquia_dam_asset_id" ("bun
>   dle", "deleted", "entity_id", "revision_id", "langcode", "delta", "acquia_d
>   am_asset_id_asset_id") VALUES (:db_insert_placeholder_0, :db_insert_placeho
>   lder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_plac
>   eholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array
>   (
>       [:db_insert_placeholder_0] => acquia_dam_image
>       [:db_insert_placeholder_1] => 0
>       [:db_insert_placeholder_2] => 62791
>       [:db_insert_placeholder_3] => 62791
>       [:db_insert_placeholder_4] => en
>       [:db_insert_placeholder_5] => 0
>       [:db_insert_placeholder_6] => 581bc840-4254-4fcd-9c57-c928b0cfbe0c
>   )
>
>
> In PdoTrait.php line 115:
>
>   SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6279
>   1-0-0-en' for key 'PRIMARY'
>
>

Migration config screenshot: