When attempting to copy an item, Sharegate 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
The error occurs because the specified value is not a valid value for this column, which means that the term "My Value" does not exist in the term set that the column is associated with or the term is set as not available for tagging.
There are 3 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 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 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.