{"id":1602,"date":"2013-06-22T17:08:12","date_gmt":"2013-06-22T15:08:12","guid":{"rendered":"http:\/\/www.itidea.nl\/?p=1602"},"modified":"2013-06-22T17:08:12","modified_gmt":"2013-06-22T15:08:12","slug":"content-by-query-webpart","status":"publish","type":"post","link":"https:\/\/www.itidea.nl\/index.php\/content-by-query-webpart\/","title":{"rendered":"Content By Query webpart"},"content":{"rendered":"

Recently I was fixing a bug which occurred at a custom webpart derived from the Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.<\/p>\n

The custom webpart has an EditorPart where the user is able to set some properties and after configuration the webpart shows an item from a list with custom formatting. Not too exciting.<\/p>\n

The customer reported an error occurred every time the properties where set and he selected ‘Apply’ and ‘Save’ or ‘Publish’. After returning from the error page to the page with the webpart on it he pressed ‘Save’ or ‘Publish’ again and the page was saved or published successfully.<\/p>\n

The first thing is to start analyzing the ULS log messages belonging to the correlation id which belongs to the exception. The first unexpected exception:<\/p>\n

‘Creating object wrapper, expecting major version, but no major version given.\u00a0 URL is \/xxxx’<\/p><\/blockquote>\n

followed closely by the message<\/p>\n

‘Trying to store a checked out item (\/xxx.ASPX) in the object cache.\u00a0 This may be because the checked out user is accessing the page, or it could be that the SharePoint system account has the item checked out.\u00a0 To improve performance, you should set the portalsuperuseraccount property on the web application’<\/p><\/blockquote>\n

Three things to check:<\/p>\n

    \n
  1. the checked out user is accessing the page – well yes, that will be me configuring the page<\/li>\n
  2. the SharePoint system account has the item checked out – no<\/li>\n
  3. set the portalsuperuseraccount property on the web application – I already did, so no<\/li>\n<\/ol>\n

    And a lot of ‘ConsoleUtilies.GetContextualControlMode had no currentPage so the current SPWebPartManager mode cannot be retrieved.’ messages.<\/p>\n

    The categories these messages came from where Publishing and Publishing Cache, so I checked some of the cache policies applied to the site. To be sure it didn’t had to do anything with the cache configured in the solution, I moved the webpart to a clean SharePoint installation, but the same exception did occur.<\/p>\n

    The next unexpected exception:<\/p>\n

    ‘System.Web.HttpException: Failed to load viewstate.\u00a0 The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request.\u00a0 For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.’<\/p><\/blockquote>\n

    Ah, the viewstate was changed during the postback. But I couldn’t find anything in the code which would be responsible for that, except…<\/p>\n

    The QueryOverride property was set in the EditorPart when configuring the webpart and this property wasn’t available in the .webpart file.<\/p>\n

    When the QueryOverride property is set SharePoint adds a new label to the toolpane with the message ‘Some properties in this Web Part are not available because they are configured to have fixed values’:<\/p>\n

    \"\"<\/a><\/p>\n

    The message is fine, because that’s the purpose of the QueryOverride property, but the label changed the viewstate, because the QueryOverride wasn’t set at the initial loading state of the webpart, and occurred the exception.<\/p>\n

    To solve this issue the QueryOverride property has to be set before the first time the viewstate is loaded. Afterwards it can be changed to another value, which will happen because this webpart changes the QueryOverride when a user changes one of the properties of the webpart.<\/p>\n

    To set the QueryOverride property before the viewstate is loaded there are two option: set the property in the OnInit event or add the property to the .webpart definition file.<\/p>\n

    OnInit event<\/h4>\n

    Only set a sort of dummy property value when the QueryOverride property is empty.<\/p>\n

    \r\nprotected override void OnInit(EventArgs e)\r\n{\r\n  base.OnInit(e);\r\n\r\n  string baseOverride = "<Where><Eq><FieldRef Name='ID'\/><Value Type='Counter'>0<\/Value><\/Eq><\/Where>";\r\n  if (this.QueryOverride.Equals(string.Empty))\r\n  {\r\n    this.QueryOverride = baseOverride;\r\n  }\r\n}\r\n<\/pre>\n
    Webpart definition file<\/h4>\n
    Add a dummy QueryOverride property to the xml file.<\/p>\n
    \r\n<property name="QueryOverride" type="string">&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='ID'\/&gt;&lt;Value Type='Counter'&gt;0&lt;\/Value&gt;&lt;\/Eq&gt;&lt;\/Where&gt;<\/property>\r\n<\/pre>\n
    Summary<\/h3>\n
    Sometimes the content query webpart is somewhat inconvenient and you’ll have to implement some fixes to get around it.<\/p>\n
    Of the two possible solutions provided for this inconvenience there is no ‘best one’, but I prefer using the OnInit method, because developers including myself, are most of the time investigating the code before the accompanying definition files.<\/p>\n
    Both solutions add the label<\/p>\n
    \"\"<\/a><\/p>\n
    to the toolpane right away and the viewstate won’t change during a postback.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Recently I was fixing a bug which occurred at a custom webpart derived from the Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart. The custom webpart has an EditorPart where the user is able to set some properties and after configuration the webpart shows an item from … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[20,42,6],"class_list":["post-1602","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2010","tag-c","tag-sharepoint-2010","tag-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/1602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/comments?post=1602"}],"version-history":[{"count":16,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/1602\/revisions"}],"predecessor-version":[{"id":1620,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/1602\/revisions\/1620"}],"wp:attachment":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/media?parent=1602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/categories?post=1602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/tags?post=1602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}