I have a parent list (Projects) with about 2500 items.

I then have another child list (project tasks) with about 200 items.  It has a lookup to the "Projects" List.

When I create a page with the Project list as one web part, select that web part and insert a related list of "Project Tasks"  I get an error that says "an Unexpected error occurred" and then throws a correlation ID.

The log says the following:

06/11/2015 09:10:01.08  w3wp.exe (0x142C)                        0x1BE8 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (GET:https://dennt05.a53financial.com:443/_layouts/vsmenu.aspx?List=%7Bd25652d7%2D6d22%2D4743%2Db655%2D3fd2b47099e2%7D&View=%7B80d4317e%2D7e2f%2D4467%2D9b0e%2Dca5a68c73a90%7D&Source=https%3A%2F%2Fdennt05%2Ea53financial%2Ecom%2FLists%2FProjects%2FAll%2520Items%2520Show%2520RFS%2520and%2520GECEP%2Easpx&)). Execution Time=12.4616396776685 07f7dd20-a652-4775-91fe-0a65bdf74f28

06/11/2015 09:10:02.22  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (Request (GET:https://dennt05.a53financial.com:443/Lists/Projects/DetailedView.aspx))  

06/11/2015 09:10:02.22  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (GET:https://dennt05.a53financial.com:443/Lists/Projects/DetailedView.aspx) 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.23  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (GetFileAndMetaInfo). Execution Time=8.41741059268706 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.23  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (GetWebPartPageContent). Execution Time=8.6075883946144 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.23  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Site=/ 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.23  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=9.61211550630038 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          General                        xxpk Medium   Unable to open Lookup list '{c44bc87f-b865-474f-af3b-e749287eefe3}'.[Error was 0x81020026] 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (EnsureListItemsData#1). Execution Time=7.41078824263978 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (DataBinding DataFormWebPart (Projects)). Execution Time=22.707844153377 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (Activate web part connections). Execution Time=31.8582389661256 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Runtime                        tkau Unexpected System.ArgumentException: Value does not fall within the expected range.    at Microsoft.SharePoint.SPFieldMap.GetColumnNumber(String strFieldName, Boolean bThrow)     at Microsoft.SharePoint.SPListItemCollection.GetColumnNumber(String groupName, Boolean bThrowException)     at Microsoft.SharePoint.SPListItemCollection.GetRawValue(String fieldname, Int32 iIndex, Boolean bThrow)     at Microsoft.SharePoint.SPListItem.GetValue(SPField fld, Int32 columnNumber, Boolean bRaw, Boolean bThrowException)     at Microsoft.SharePoint.SPListItem.GetValue(String strName, Boolean bThrowException)     at Microsoft.SharePoint.SPListItem.get_Item(String fieldName)     at Microsoft.SharePoint.WebPartPages.BaseXsltListWebPart.get_ConnectionProviderDataTable()     at Microsoft.SharePoint.WebPartPages.DataForm... 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26* w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Runtime                        tkau Unexpected ...WebPart.get_RowData()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PerformSelect()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.DataBind()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.EnsureDataBound()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.CreateChildControls()     at Microsoft.SharePoint.WebPartPages.BaseXsltListWebPart.CreateChildControls()     at Microsoft.SharePoint.WebPartPages.WebPartMobileAdapter.CreateChildControls()     at System.Web.UI.Control.EnsureChildControls()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.Microsoft.SharePoint.WebPartPages.IConnectionData.GetData()     at Microsoft.SharePoint.WebP... 37f77ff6-7f65-4c61-80c1-b4423a3ed551

06/11/2015 09:10:02.26* w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Runtime                        tkau Unexpected ...artPages.SPWebPartManager.BeginWebPartDataFetch()     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.ActivateV2ConnectionsAndSharePointDataFetch()     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.ActivateConnections()     at System.Web.UI.WebControls.WebParts.WebPartManager.OnPageLoadComplete(Object sender, EventArgs e)     at System.EventHandler.Invoke(Object sender, EventArgs e)     at System.Web.UI.Page.OnLoadComplete(EventArgs e)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 37f77ff6-7f65-4c61-80c1-b4423a3ed551
06/11/2015 09:10:02.28  w3wp.exe (0x142C)                        0x1548 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope 

I have tried increasing the list threshold to 300 in central admin with no avail.

If I create two new lists with no records one with a lookup to the other and try it, it works fine, and I get something like this:

I think that this may be related to:  http://www.greenroomsolutions.ca/problems-with-using-document-library-templates-across-site-collections/  where the problem occurs because I moved the parent and the child list from a different site to this site, and the list ID is not correct because it's using the list ID of the old site perhaps?

This is the message I get when I try to lookup the GUID in powershell:

PS C:\Users\administrator.A53FINANCIAL> $web = get-spweb -identity "c44bc87f-b86
5-474f-af3b-e749287eefe3"
Get-SPWeb : Syntax Error: Either provide a full Url or an SPSite object.
At line:1 char:17
+ $web = get-spweb <<<<  -identity "c44bc87f-b865-474f-af3b-e749287eefe3"
    + CategoryInfo          : InvalidData: (Microsoft.Share....SPCmdletGetWeb:
   SPCmdletGetWeb) [Get-SPWeb], SPCmdletPipeBindException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletGetWeb

PS C:\Users\administrator.A53FINANCIAL>

When I open up the site in SharePoint Manager, it seems to be that the GUID's are not being accessed properly for the list.  Something in the front end seems to be accessing some other GUID for the related ITems view, but it's not accessing the one of the list themselves, unless this is by design and the view is referring to something dynamic that isn't the view.

I have other lists that all reference the Project List that were also moved that are all doing the same thing when I try to add related lists. 

I am just about to recreate the parent list and all the child lists and start over, but I really want to try to avoid having to do this kind of data migration task.  It's really very silly to have to do that if there is supposed to be this template feature with the save content feature that's supposed to handle that.  The biggest problem with starting over is that I would have to go through and update dozens of workflows and dozens of other lists that all reference the projects list.  There are documents linked to the projects in the project list, there are tasks, requirements, intakes, etc...  basically I would have to rebuild the entire site just to get this one feature to work...  and that's not OK.

When I recreate the parent list, go to the child list, and reference this new parent list, it will of course allow me to enforce the relationship on the child list and when I go to recreate the page with the related item list it works... that looks like this:

So at the end of my diagnosis I think it must have something to do with the relationship and the original list having some kind of problem.  Again, I don't want to have to recreate the parent list.  That will require that I basically go touch dozens of workflows, recreate dozens of columns in dozens of tables, and it will be a huge mess.  Please help me fix this.

• Edited by tmesias75 11 hours 6 minutes ago

Ok so I did some digging and figured this out. Here are the steps to resolve this issue:

Step 1:

In the parent and child tables Double check that all columns marked as type "lookup" do indeed exist in the new site.

Step 2:

Delete or fix any missing references in the lookup tables.

How I reverse engineered a solution:

1.) The correlation ID on the error message is actually the first step in diagnosing this issue.  Copy the correlation ID down.

2.) lookup the correlation ID in the ULS (I think that's right) logs.  these are text files on your web server. this looks like the text above.

3.) decipher the log and look for "Unable to open Lookup list" line.  This will tell you a GUID that looks like this: '{c44bc87f-b865-474f-af3b-e749287eefe3}'  it will be different in your case.

4.) open up SQL and open the database for your site (mine was WSS_Content)

5.) Goto dbo.AllLookupRelationships and create a select Query, Where LookupListID = 'YourGUID' without the brackets.

6) the result will list columns where it says "ListID" write this down and copy to clipboard.

7) Goto dbo.AllLists and create a select Query, Where tp_ID = 'WhateverYouWroteDown'

8) the tp_title column will be the name of the list/library/etc that has a broken lookup list.

9) open sharepoint up in your web browser.  navigate to that list/library/etc open up the columns and look for lookup columns.  Inspect each one to make sure that they actually point to something, correcting all errors by either deleting the column or correcting the lookup.

10)Reattempt to recreate your display form/edit form/ or page with the related items as expected.  It should work now.

• Marked as answer by tmesias75 11 hours 16 minutes ago
• Edited by tmesias75 11 hours 8 minutes ago