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.
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 in your destination SharePoint site's settings (in your browser) and clicking on Term store management. You can then locate the term set and add the terms for which Sharegate 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.