When attempting to copy an item, ShareGate Desktop displays the following error:
The value 'My value' is unavailable. Please specify another value.
The error should appear on a given property, for example, Property Status: The value 'My value' is unavailable. Please specify another value.
Any error code ending with: -109
In the context of this error, Property is a 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 of this 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.
You have 4 possible solutions to this issue:
- Copy the missing terms using Copy Structure, or manually add the missing terms to the term set associated with the column. If you are using Copy Structure, you can follow the instruction on our Managed Metadata article. To manually add them, go into your destination SharePoint site's settings (in your browser) and click on Term Store Management. You can then locate the term set and add the terms for which ShareGate Desktop gives an error (in the example above, the term "My Value" should be added to the term set).
- Set the term set associated with the column to be Open, which means that new terms can be added to the term set by any user. This can be done by going in your destination SharePoint site's settings (in your browser) and clicking on Term store management. You can then locate the term set and change its Submission Policy setting to Open. Once this is done, you can go to your destination list or library's settings, then click on the managed metadata column causing the issue and set "Allow 'Fill-in' choices" to Yes.
This will allow ShareGate Desktop to create any term that is missing during the copy, so instead of giving the above error, it will create the term "My Value" in the term set referenced by the column.
- Set a default value in ShareGate Desktop to use when the source item's value is empty. This can be done by creating a Property Template and setting the column to "Set mapped value or default". Doing this will replace every value that is no longer valid with the specified default value, so the data will be altered. The default value must be a term that exists in the term set referenced by the column. It can also be blank if the column is not required.
- If the error is caused by a term not available for tagging at the destination. Set that term as available manually in your destination's term store.