Forum Discussion

Sorin Sandu's avatar
Sorin Sandu
Icon for Microsoft rankMicrosoft
Jul 22, 2021

Per-location view error

Hi,   When trying to setup per-location view on a document library I get 07/22/2021 09:41:32.80 w3wp.exe (SP:0x1824) 0x1838 SharePoint Foundation Database 880i High System.Data.SqlClient.SqlExc...
Surya_Pammi's avatar
Surya_Pammi
Iron Contributor
Jul 22, 2021

Sorin Sandu : Please check these settings in SharePoint site where you were trying...

  1. On the SharePoint site, click the Settings button (Gear icon), and then click Site Settings.
  2. Under Site Actions, click Manage Site Features.
  3. Activate the Metadata Navigation and Filtering feature.
  4. Locate the Library Settings of the document library in question.
  5. Click Per-Location View Settings.
  6. Change the folders to have the default views that you want.
  7. Go back to Library Settings for that library, and then click Metadata navigation settings.
  8. Add Folders and Content Type to the Selected Hierarchy Fields box, and then click OK.
  • TroyStarr's avatar
    TroyStarr
    Icon for Microsoft rankMicrosoft
    Jul 29, 2021

    Thanks Sorin Sandu, these details are very helpful.  We're following up to identify the best approach to fix this issue.

    • Denis Molodtsov's avatar
      Denis Molodtsov
      Brass Contributor
      Oct 20, 2022

      TroyStarr 

      Perhaps it's related: We are getting an error when trying to access the "SharePoint structure view" when adding a reference to a document or a picture. In our case, to replicate an issue, we can replicate the exact same error this way:

       

       

      We recently upgraded from SP 216 to SE. And this is this started occurring. This is not happening if we create an empty site collection from scratch. So, some old data + a database upgrade process breaks this functionality in SE. At least in our farm.

       

      Error:

      System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904 at Microsoft.SharePoint.Library.SPRequestInternalClass.GetWebAndChildrenNSInfo(String bstrUrl, Guid gSiteId, Guid gWebId, UInt32 dwOptions, Boolean bGetPath, String bstrExpandPath, UInt32 dwWebUrlPrefixLen, Object& pvarThisWeb, Object& pvarSubwebs, Object& pvarLists, Object& pvarExpandedNodes, UInt32& pdwThisWebCount, UInt32& pdwSubwebCount, UInt32& pdwListCount, UInt32& pdwExpandedNodeCount) at Microsoft.SharePoint.Library.SPRequest.GetWebAndChildrenNSInfo(String bstrUrl, Guid gSiteId, Guid gWebId, UInt32 dwOptions, Boolean bGetPath, String bstrExpandPath, UInt32 dwWebUrlPrefixLen, Object& pvarThisWeb, Object& pvarSubwebs, Object& pvarLists, Object& pvarExpandedNodes, UInt32& pdwThisWebCount, UInt32& pdwSubwebCount, UInt32& pdwListCount, UInt32& pdwExpandedNodeCount)

       

       

Resources