Symptoms

When attempting to copy an item, ShareGate Migrate displays the following error:

Property 'My property': The value 'My value' is unavailable. Please specify another value.

Error code

DA-077-109

Any error code ending with: -109

Details

In the context of this error, Property is a managed metadata column, and value is a managed metadata value for that column.

The error occurs because the source value is not a valid managed metadata value for this column at the destination.

A common cause is that the term from the source does not exist in the term set that the column is referencing at the destination.

Another frequent cause is when the term is set as not available for tagging.

Solution

You can use one of the following solutions to solve the error.

Note: To avoid some errors, it is highly recommended that you get term store administrator permissions for managed metadata migrations.

Create or migrate the missing term

Verify the term set associated with your managed metadata column

Open the destination list in SharePoint.
Go to the list settings.
Click on the affected column (property) in the Columns section.
Verify what term set the column is using in the Term Set Settings section.
Expand the term set to validate if the term is available for your column.

Create the missing term

In your SharePoint site, click on the gear icon in the top right corner.
Select Site settings.
Click on Term store management in the Site Administration section.
Note: You can verify if you are a term store administrator in the term store management screen.
Find the term set associated with your column.
Right-click on the term set or the term in which you need to add the missing term.
Select Create Term.
Type the name of the missing term precisely as it is at the source.
Migrate the items with the missing values again.

Migrate the missing term

Follow the steps from our Managed Metadata migration article to copy the missing term to the destination.
Migrate the items with the missing values again.

Set your destination term set to Open and allow fill-in choices in your column

Go to the site that contains your destination list in SharePoint.
Click on the gear icon in the top right corner.
Select Site settings.
Click on Term store management in the Site Administration section.
Find and select the term set associated with your column.
In the Submission Policy section, select Open.
Click on Save at the bottom of the page.
Go to your list in SharePoint.
Go to the list settings.
Click on the affected column (property) in the Columns section.
Set Allow 'Fill-in' choices to Yes.
Click Ok to exit the menu and save the setting.
rerun your migration.
SharePoint will automatically add the missing terms to your managed metadata column during the migration.

Note: After the migration is successful, you can go back to your column settings to set Allow 'Fill-in' choices to No, and you can go back to Term store management to set the Submission Policy for your term set to Closed.

Replace the missing value with a value that is available at the destination

In the Copy content only screen, click Options.
Select the Metadata tab.
Expand the Content type that contains the affected column.
Locate the affected column (property).
Select Set mapped value or default in the dropdown.
Click on the new field that appears at the right.
Select the term you wish to use by default when your source term is unavailable.
Click Confirm selection.
Click the green checkmark icon in the top-right corner to save your settings and close the options panel.
rerun your migration.
Your items will keep the available values at the destination, and those with unavailable values will get the default value you selected for that column.

Verify if the error is caused by a term not available for tagging at the destination

Go to the site that contains your destination list in SharePoint.
Click on the gear icon in the top right corner.
Select Site settings.
Click on Term store management in the Site Administration section.
Find and expand the term set associated with your column.
Select the missing Term (value).
Verify if Available for Tagging is checked.
If it is unavailable for tagging, enable Available for Tagging with the checkbox in that section.
Click on Save.
rerun your migration.