Error "An item with the same key has already been added Key" Occurs When migrating one workbook and one published data source by CMT

Issue

When you try to migrate one workbook and one published data source by CMT 2022.2.1, the following error might occur:

An item with the same key has already been added Key: Sheet 1

The migration of the workbooks and the data sources are successful after receiving the error but the following issues remains.

1. Post migration script will not run
User-added image

2. Extracts won't be refreshed

Environment

Tableau Cloud 2022.3.0
CMT 2022.2.1

Resolution

The workaround is deleting workbooks with multiple views with the same name in the destination server.

Error occurs when there are workbooks with multiple views with the same name exist on the destination server.
Ideally, a workbook will never have views with the same name. The multiple views issue can occur in test servers or when content doesn't get deleted properly.

<Example: workbooks with multiple views with the same name>
User-added image