SharePoint on-prem list is skipped during migration

%3CLINGO-SUB%20id%3D%22lingo-sub-1706466%22%20slang%3D%22en-US%22%3ESharePoint%20on-prem%20list%20is%20skipped%20during%20migration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706466%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI'm%20migrating%20a%20SharePoint%20on-prem%20list%20to%20the%20SPO%20list%20using%20SharePoint%20Migration%20Tool.%20While%20the%20migration%20list%20gets%20skipped%2C%20below%20is%20the%20message%3A%3C%2FP%3E%3CP%3E%22%3CSPAN%3ESharePoint%20on-premise%20list%20'CommentHistory'%20is%20skipped%3B%20Reason%3A%20The%20list%20reference%20is%20broken.%20The%20lookup%20field%20'Status'%20cannot%20find%20the%20referred%20list%20'43a0c2f8-1efe-4acc-b49c-f6bec8f74ab4'%20(ErrorCode%3A%200x02010023)%3C%2FSPAN%3E%22%3C%2FP%3E%3CP%3EHow%20to%20fix%20this%3F!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1706466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1706513%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20on-prem%20list%20is%20skipped%20during%20migration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F806772%22%20target%3D%22_blank%22%3E%40samdany10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20CommentHistory%20a%20custom%20list%20or%20a%20system%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20list%20is%20using%20a%20lookup%20for%20the%20column%20Status%2C%20find%20the%20list%20it%20is%20referencing%20and%20migrate%20that%20first.%20Not%20entirely%20sure%20how%20the%20migration%20tool%20migrates%20lookup%20lists%2C%20might%20be%20worth%20investigating%20if%20it%20supports%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1706514%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20on-prem%20list%20is%20skipped%20during%20migration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706514%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reference%20list%20is%20already%20there!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi All,

I'm migrating a SharePoint on-prem list to the SPO list using SharePoint Migration Tool. While the migration list gets skipped, below is the message:

"SharePoint on-premise list 'CommentHistory' is skipped; Reason: The list reference is broken. The lookup field 'Status' cannot find the referred list '43a0c2f8-1efe-4acc-b49c-f6bec8f74ab4' (ErrorCode: 0x02010023)"

How to fix this?!

4 Replies
Highlighted

@samdany10 

 

Is CommentHistory a custom list or a system list?

 

The list is using a lookup for the column Status, find the list it is referencing and migrate that first. Not entirely sure how the migration tool migrates lookup lists, might be worth investigating if it supports them.

Highlighted

@Andrew Hodges 

The reference list is already there!

Highlighted

@samdany10 

 

I cannot see in the documentation if lookup columns are supported. You are best of creating a small test with 2 lists, one referencing the other as  a lookup column and migrating them. If it works you would know its supported if it doesn't that's your issue and you would need to manually re-establish the lookup. 

Highlighted

@samdany10 

 

0x02010023Your source list template is not supported.  Please try another.

 

Looks like you cannot migrate that list.

 

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