Error when migrating sharepoint list contains lookup field

Gulnar 146

I am trying to migrate a list that contains lookup field from local sharepoint 2013 to sharepoint online office 365, but I am getting the following error:

SharePoint on-premise list 'Department' is skipped; Reason: The list reference is broken. The lookup field 'Department type' cannot find the referred list '71e5ca71-ad37-46a6-a389-d794e96e27b6' (ErrorCode: 0x02010023)

Already the referred list that the lookup field use it to return the data from it is migrated successfully.

I am using sharepoint migraton tool.

JoyZ 18,076 Reputation points

2020-10-14T01:13:14.207+00:00

Hi @Gulnar ,

If you find any answer helpful to you, please remember to accept it as answer.

Thank you for your understanding.
JoyZ 18,076 Reputation points

2020-10-20T01:19:31.68+00:00

Hi @Gulnar ,

If you feel a answer works for you, please kindly accept it as answer.

It will be beneficial to other community members reading this thread.

3 answers

Shaun Brown 1 Reputation point

2020-10-06T21:12:20.79+00:00

In the "Department" list what kind of data is pulled from the "Department Type"? What kind of fields are being looked up?
Also does the migrating account have access to all list and lookups involved?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Joseph Cilia 1 Reputation point

2020-10-06T23:49:54.387+00:00

This happens as when you migrate the lists to OnLine the list reference is changing, then when you try to migrate a list linked to that list its unable to match it. I am having the same problem, -migrate all is failing and migrate list by list is not an option due to this issue. I am stuck :(
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
JoyZ 18,076 Reputation points

2020-10-07T10:01:18.827+00:00

Hi @Gulnar ,

Please try to migrate the whole site includes the source list and target list instead of migrating lists one by one.

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Gulnar 146 Reputation points

2020-10-08T09:57:44.747+00:00

I am doing list by list because I prepared the pages in my site and also some lists. The other site has the same names of the pages and some lists. So, If I did all together it will be overwrite on the old one.

JoyZ 18,076 Reputation points

2020-10-12T03:06:10.747+00:00

Hi @Gulnar ,

If I migrate the list one by one, the issue can be reproduced.

When I migrate the whole site, no error occurs, so I think that the current SPMT does not support one-to-one list migration that contains lookup columns.

We suggest you migrate the same pages and lists to different sites in SharePoint online, or share a suggestion to improve the SPMT at User Voice.

Joseph Cilia 1 Reputation point

2020-10-15T06:30:20.897+00:00

What if site migration is failing with error Local storage file is corrupted (ErrorCode: 0x02050001)?

JoyZ 18,076 Reputation points

2020-10-15T06:48:04.337+00:00

Hi @Joseph Cilia ,

For the error message, please restart your migration as mentioned in following article:

https://learn.microsoft.com/en-us/sharepointmigration/troubleshooting-common-spmt-issues

Joseph Cilia 1 Reputation point

2020-10-15T06:57:03.25+00:00

This has been retried many times, even on different machines, always end up with the same error, we have been stuck for 3 months on this migration.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error when migrating sharepoint list contains lookup field

3 answers

Your answer