locked
Content and Structure Reports revert back to default view RRS feed

  • Question

  • The Content and Structure reports such as "Display pages expiring in the next 7 days" have been working for years and suddenly stopped working last week.  When you attempt to display one of the reports it does not display and reverts back to the default view.  The publishing feature has been deactivated and re-activated and it did not fix the problem.  I have seen other reports of this problem but no resolution.  Microsoft Premier Support has not been able to resolve the issue.  Let me know if you have a resolution or troubleshooting steps we might not have tried.  This is SharePoint Server 2007.
    Rick
    • Edited by Rick-TC Tuesday, November 1, 2011 10:26 PM
    Tuesday, November 1, 2011 10:26 PM

Answers

  • Hello Rick,

    Thank you for your post . The reason its defaulting to defaut view is when you are trying to load a page its trying to lookup a property named _SmtReportsListId and lookup its key/value pair that has a list ID that points to the content and structure reports. Looks like the properties collection for the web does not contain a key with _SmtReportsListId. So a default value is returned which is 0 and thus the report simply refreshes. Ideally, there should be this property with a key value pair that is the List GUID.

    Running the below query will give us the list ID,

    SELECT tp_ID, tp_Title From AllLists (nolock) where tp_Title = 'Content and Structure Reports' .

    There is no out of box way from SharePoint UI to populate the property , if deactivation and reactivation of feature has not fixed it .We can definately populate the same using object model or we can see if we can use the tool in http://spm.codeplex.com/releases/view/22762 to do the job.

    However before doing any of these steps we need to esnure that what I have mentioned is exactly the issue on your environment and need to analyze additional logs . Looking at the complexity of the issue I would recommend opening a support case with Microsoft. Please visit the below link to see the various paid support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone. If you are a MSDN / TechNet subscriber, you can also contact our support by using your free support incidents.

     

    However, other members of the community may still have encountered the issue you're seeing, and have a solution to offer!

     


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Rick-TC Monday, November 7, 2011 3:47 PM
    Saturday, November 5, 2011 8:57 AM

All replies

  • We found the problem.  It turns out for some unknown reason a hidden property on the Content & Structure site, _SmtReportsListId, was missing.  This property should hold the GUID for the Views list for the Content & Structure views (reports).  We have had several issues with the publishing infrastructure which deactivating and reactivating the feature only resolved a few of them.  It appears there may be other properties missing as well compared to our test server, but this one was an issue because we couldn't identify expired pages without it.

    Rick


    Rick
    • Marked as answer by Rick-TC Wednesday, November 2, 2011 8:06 PM
    • Unmarked as answer by Rick-TC Thursday, November 3, 2011 2:47 PM
    Wednesday, November 2, 2011 8:05 PM
  • Hello Rick,

     

    Thank you for your question.

     

    I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

     

    Thank you for your understanding and support.

     

    Thanks,

    Wayne Fan

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact  tnmff@microsoft.com.

    Friday, November 4, 2011 2:59 AM
  • Hello Rick,

    Thank you for your post . The reason its defaulting to defaut view is when you are trying to load a page its trying to lookup a property named _SmtReportsListId and lookup its key/value pair that has a list ID that points to the content and structure reports. Looks like the properties collection for the web does not contain a key with _SmtReportsListId. So a default value is returned which is 0 and thus the report simply refreshes. Ideally, there should be this property with a key value pair that is the List GUID.

    Running the below query will give us the list ID,

    SELECT tp_ID, tp_Title From AllLists (nolock) where tp_Title = 'Content and Structure Reports' .

    There is no out of box way from SharePoint UI to populate the property , if deactivation and reactivation of feature has not fixed it .We can definately populate the same using object model or we can see if we can use the tool in http://spm.codeplex.com/releases/view/22762 to do the job.

    However before doing any of these steps we need to esnure that what I have mentioned is exactly the issue on your environment and need to analyze additional logs . Looking at the complexity of the issue I would recommend opening a support case with Microsoft. Please visit the below link to see the various paid support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone. If you are a MSDN / TechNet subscriber, you can also contact our support by using your free support incidents.

     

    However, other members of the community may still have encountered the issue you're seeing, and have a solution to offer!

     


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Rick-TC Monday, November 7, 2011 3:47 PM
    Saturday, November 5, 2011 8:57 AM
  • Yes, we discovered that was the problem.  We discovered missing properties and determined the _SmtReportsListID was missing last week.  Your reply offers more detailed information which should help others.


    BTW, Microsoft Premier Support was not able to resolve the problem or point us in the right direction.  An architect here basically stumbled upon the missing property.

     


    Rick
    • Edited by Rick-TC Monday, November 7, 2011 4:08 PM
    Monday, November 7, 2011 3:47 PM
  • actually, with my scenario, i see the hidden property with the correct listID, but the views still don't work. The views specifically created for that document library/list work, but anything that is below the divider does not persist, eg. All Draft Documents, etc.

    clicking on the views generated by Content and Structure simply does not persist and just stays with the current selected view.

     

    Vincent


    Tuesday, November 22, 2011 4:04 PM
  • @invinceble99

    Another case where this happens is if you have a site collection that you created with a template besides "Publishing Portal" (ex. "Team Site"). From there the "Content and Structure" feature will not be present until you turn on the Site Collection level Publishing feature "SharePoint Server Publishing Infrastructure" under "Site collection features". When you are in that state, the Content and structure link will be present, but switching views will fail.

    To resolve this, you need to activate the Site level (spweb) feature "SharePoint Server Publishing" under "Manage site features".

    Hope this helps.

    Friday, March 1, 2013 12:19 AM