List View returns error: "Sorry, something went wrong File Not Found" contains lookup column and additional column

Question

List View returns error: "Sorry, something went wrong File Not Found" contains lookup column and additional column

UnderwoodMarlene-1858 115

I have a view (Report View) on a list that is returning an error "Sorry, something went wrong File Not Found". When I remove the lookup column's additional column (Company:Description) OR if I group the list by the lookup column (Company) the error goes away. What is causing this? It used to work.

SharePoint Server 2016 on-premise

There are 1,360 rows.

5 lookup columns and 1 person people-picker column.

The lookup tables contain 52 rows or less (52, 4, 20, 6, 26).

Error page also has:

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

Web part page has:

Web Part Title	Type	Open on Page?
Web Part Title	Type	Open on Page?
Hazard	XsltListViewWebPart	Yes

ULS Log has: 04/02/2025 11:30:30.42 w3wp.exe (0x1B40) 0x1D2C SharePoint Foundation General ai1wu Medium System.IO.FileNotFoundException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002), StackTrace: at Microsoft.SharePoint.SPSite.OpenWeb(Guid gWebId, Int32 mondoHint) at Microsoft.SharePoint.JSGrid.SPGridInitGenerator.<GetInitObject>b__6(SPFieldLookup field) at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement] at Microsoft.SharePoint.JSGrid.SPGridInitGenerator.GetInitObject(String qualifier) at Microsoft.SharePoint.WebPartPages.XsltListViewWebPart.EnsureJSonObject() at Microsoft.SharePoint.WebPartPages.XsltListViewWebPart.OnPreRender(EventArgs e) at Microsoft.SharePoint.WebPartPages.WebPartMobileAdapter.OnPreRender(EventArgs e) ... ce9490a1-87f1-90bd-df19-c3a237c8478d

1 answer

Your answer

Answer 1

Xyza Xue_MSFT 30,176 Microsoft External Staff

Hi @UnderwoodMarlene-1858 ,

Thank you for posting in this community.

It seems this is not a common issue per my test. However, we can work together to narrow down and resolve the situation.

The error "Sorry, something went wrong File Not Found" in your SharePoint list view could be related to the use of lookup columns, especially when they are combined with additional columns. This issue may arise when the lookup columns are not properly configured or if there are missing references in the lookup data.

In your case, since the error disappears when you remove the additional column or group by the lookup column, it suggests that the additional column (Company:Description) might not be able to retrieve the necessary data from the lookup table, leading to the "File Not Found" error.

The ULS log indicates System.IO.FileNotFoundException , which typically occurs when the system cannot find a specified file or resource. This can happen if the lookup column references an item that has been deleted or if there are issues with the data integrity in the lookup tables.

To resolve this, you may want to check the following:

Ensure that all items in the lookup tables are intact and accessible.
Verify that the lookup column configuration is correct and that it points to existing data.
Consider creating a new view without the problematic additional column to determine if a specific additional column is causing the problem or if all additional columns are at fault.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2025-04-03T08:52:59.59+00:00

Hi @UnderwoodMarlene-1858 ,

How's going today? Do you have further concerns regarding this issue? Please feel free to talk with us if you have other questions. If the above info is helpful to this question, you can click "Accept Answer". Have a nice day!
UnderwoodMarlene-1858 115 Reputation points

2025-04-03T14:01:49.73+00:00

For suggestion

#1, I created a simple view and grouped it by the lookup column (Company) and included the additional column (Company:Description). All of the records display the additional column. So, the tables are intact and accessible.

#2, See #1 above.

#3. I already made a copy of the view with the problem and removed the additional column (Company:Description) and the view works OK. So that is the culprit.

I am also using the view with the error in an excel spreadsheet (owssvr) and it works fine. All the rows have data in the additional column (Company:Description).

I have not exceeded any lookup column limits.

Using Edge in IE mode.

Chrome returns the same error.

Did the XsltListViewWebPart change? How do I check it? What does the 'Reset' function do on the Web Part Page Maintenance page?
UnderwoodMarlene-1858 115 Reputation points

2025-04-29T20:16:18.0166667+00:00

This problem still exists. Any other suggestions?
UnderwoodMarlene-1858 115 Reputation points

2025-04-29T20:27:59.5166667+00:00

I opened a support request.
UnderwoodMarlene-1858 115 Reputation points

2025-05-01T21:33:42.77+00:00

The issue is because the main list has the SAME internal column name as the Additional column in the Lookup list (Company:Description). This used to work, so I assume a recent change introduced this bug.

As a workaround, I created a new lookup column & switched the views to use it instead, and renamed the original column.

UnderwoodMarlene-1858 115

To find other lists that use lookup columns, see https://techtrainingnotes.blogspot.com/2015/04/powershell-finding-all-sharepoint-lists.html . I slightly modified it to format the output.

I found other lists using the same column names, but those views were working OK. So, apparently, it's not always an issue, which is good because they were using the build-in fields of ID and Title.

Add-PSSnapin Microsoft.SharePoint.PowerShell
<#
Many of the out of the box lists are "custom" lists and will have fields that look like user added columns. Exclude those with the $TTNExcludeLists variable.
Field that are Hidden or FromBaseType are not typically user created and are excluded in this example.
#>
$TTNExcludeLists = "Solution Gallery", 
                "Workflow Tasks", 
                "Master Page Gallery"
Get-SPSite -Limit All | Get-SPWeb -Limit All | 
  Select -ExpandProperty Lists | 
  Where { -Not ($TTNExcludeLists -Contains $_.Title) } | 
  Select -ExpandProperty Fields | 
  Where { $_.TypeDisplayName -eq "Lookup" -and 
          $_.Hidden -eq $false -and 
          $_.FromBaseType -eq $false } | 
  Select {$_.ParentList.ParentWebUrl} , 
         {$_.ParentList}, 
         Title | Format-Table -AutoSize #ParentWebUrl, ParentList, Title -Wrap

Share via

List View returns error: "Sorry, something went wrong File Not Found" contains lookup column and additional column

1 answer

Your answer