Unexpected Error occured on Add of Related List to page for lists that were moved to the site from another site. (Network Steve Forum)

Unexpected Error occured on Add of Related List to page for lists that were moved to the site from another site.

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 also noticed that for the lists that were not moved and work fine in creating the related list, the lookup column is in fact indexed. However, when I try to set the lookup column on "Project Tasks" to enforce relationship behaviour, I get another error that states that "This lookup column cannot enforce a relationship behavior because it contains values that reference one ore more non-existent items in the target list." However every item is properly set to an item in the list.

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.

When I try to create a brand new child list that points with a single lookup column to the parent "Projects" List the same error occurs. However I do notice that the lookup field has all the projects listed, where the lookup field on the migrated lists seem to have entries missing. It's bizzare.

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 13 hours 4 minutes ago

July 31st, 2015 12:57pm

Hi tmesias- you're thinking correctly that you're causing an issue by moving those connected lists. About all you can do is un-connect the lists in the original location, then save them as templates. Then add them to the new location and re-connect them.

Free Windows Admin Tool Kit Click here and download it now

July 31st, 2015 5:03pm

When I had the two lists in the sub-site, I first disconnected the lookups and transferred the data to basic number columns before moving them. Then I recreated the lookups in the new site, which was indeed the main site.

I have deleted the templates I used to transfer the lists over, because at the time, the "related lists" feature wasn't something we needed, and so we didn't suspect anything was an issue.

When this new requirement came in, and we started implementing the feature is when the problem became apparent. I wonder if there was a way - maybe rebuild an index or something that will let me fix whatever is broken under the covers without having to recreate the list and relink everything and redo all the associated workflows.

In our organization EVERYTHING is linked back to that Project ID. That one index is used EVERYWHERE.

I hope someone has a way to diagnose this issue and fix it without resorting to a rebuild.

July 31st, 2015 5:50pm

This topic is archived. No further replies will be accepted.