Unable to migrate lotus notes forms to sharepoint library that has more than 5000 records-threshold limit

Hi All,

We are using Quest tool ( Notes to sharepoint Migrator )to migrate Lotus notes forms into sharepoint online library as pdf documents. One of our form has more than 10000 records. The job got failed after migrating around 6000 records. Once we are trying to restart the job again for migrating rest of the records, we are unable to initiate it as the job keeps failing stating that sharepoint library has crossed the threshold limit of 5000 records.

I would like to know whether this is an expected behavior in Quest tool.? If yes, what are the alternative solution for fixing it other than below one's.

Migrating into separate libraries.
Migrating to library and later on moving those records into folders so as to keep count within 5000 records.

Also, i would like to know whether we can migrate records into a particular folder under a sharepoint library.?

Any help or guidance is really helpful.

Regards,
Rinu

Top Replies

Peter.Mendelsohn over 5 years ago +1 suggested

Hi,
The 5000 item per view limit is a limit in SharePoint imposed by Microsoft, so your SharePoint design should find a way around it. Usual solutions are modifying the default view (e.g. adding an indexed…

0 Peter.Mendelsohn over 5 years ago

Hi,
The 5000 item per view limit is a limit in SharePoint imposed by Microsoft, so your SharePoint design should find a way around it. Usual solutions are modifying the default view (e.g. adding an indexed filter) or using folders.

https://answers.microsoft.com/en-us/msoffice/forum/all/the-attempted-operation-is-prohibited-because-it/d966057a-0eb8-4ce3-a908-3b6b0a4e975b

https://sharepoint.stackexchange.com/questions/176856/list-threshold-limit

rinudaniel said:
whether we can migrate records into a particular folder under a sharepoint library.?

Yes - if folders are enabled in the SharePoint library, you can map any value to a field of folder type, including subfolders.

Hope this helps,
Peter
- 0 lee mather over 5 years ago in reply to Peter.Mendelsohn
  
  Hi Peter,
  
  I'm in the same position as Rinudaniel, we've started a migration that failed halfway through and now I can't restart it due to the list view threshold. Is there anything I can do to start this off again?
  
  I have created a default view with 1 indexed column and set up a filter to filter out everything still no luck. Is the only option to delete everything in the list, start again and hope for the best?
  
  regards,
  - 0 Peter.Mendelsohn over 5 years ago in reply to lee mather
    
    Have you tried manually adding a new item to that list? If that works, and MNSP still cannot migrate items into that list, that would sound like a case for further investigation (or even support).
  - 0 Mahesh ch over 4 years ago in reply to Peter.Mendelsohn
    
    Hi Peter,
    
    we are also facing the same issue . I could able to create item in sharepoint list .
    
    Please advise .