Retour
-
Titre
"The attempted operation is prohibited because it exceeds the list view threshold" error message -
Description
User sees the error message below in the migration log or when trying to view the list items via the Content Matrix Console:
The attempted operation is prohibited because it exceeds the list view threshold.
-
Cause
This error message is normally a result of the following SharePoint threshold settings in Application Management > Manage web applications > WAP General Settings > Resource Throttling:
- List View Threshold, which has a default value of 5000
- List View Lookup Threshold, which has a default value of 8
-
Résolution
Workaround 1:
Use Database Adapter
Workaround 2
Configure ‘DisableChunkMigration’ setting as True:
1. In the EnvironmentSettings.xml file located at “C:\ProgramData\Metalogix”, set the "DisableChunkMigration" key value to ‘True’ as shown below:<XmlableEntry><Key>DisableChunkMigration</Key><Value>True</Value></XmlableEntry>Note: If the Content Matrix was installed "For current user only", the EnvironmentSettings.xml file will be located at "C:\Users\{username}\AppData\Roaming\Metalogix\Common\"2. Relaunch Content Matrix.
Workaround 3:
Increase “List View Threshold” value on the source SharePoint server:1. Navigate to Central Administration > Application Management > Manage web applications2. Highlight/Select the Web Application corresponding to the site being migrated. Then, in the ribbon, access the drop-down of the "General Settings" and select "Resource Throttling".3. Increase the value of the "List View Threshold" setting to something more appropriate for the list/library you are trying to migrate, and then click OK.Note: Increase the "List View Lookup Threshold" setting as well, if the error message indicates a "List View Lookup" threshold error.4. Reproduce the issue and, if it persists, increase the value again until the error message goes away.Note: To leverage "Scheduled Daily Time Window" as a workaround, and for more information about adjusting resource throttling settings, please visit Manage large lists and libraries for instructions from Microsoft.