none
SharePoint 2013 search analytics reports - 'query text' column value is empty in 'top queries by month' report RRS feed

  • Question

  • Hi,

    We are using ContentBySearchWebPart to facilitate search through the site.

    We have used display template to format the results. We are deploying the web part on the desired page through a feature. We have below markup for web part in the elements.xml file to add the web part -

    <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
        <metaData>
          <type name="Microsoft.Office.Server.Search.WebControls.ContentBySearchWebPart, Microsoft.Office.Server.Search, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
          <importErrorMessage>Cannot import this Web Part.</importErrorMessage>
        </metaData>
        <data>
          <properties>
            <property name="StatesJson" type="string">{}</property>
            <property name="UseSharedDataProvider" type="bool">False</property>
            <property name="UseSimplifiedQueryBuilder" type="bool">False</property>
            <property name="QueryGroupName" type="string">f5646507-4a7a-4d75-b5c4-d435b9128e2a</property>
            <property name="LogAnalyticsViewEvent" type="bool">True</property>
            <property name="SelectedPropertiesJson" type="string">["Title","Path","Description"]</property>
            <property name="PropertyMappings" type="string" />
            <property name="ShowAdvancedLink" type="bool">True</property>
            <property name="NumberOfItems" type="int">10</property>
            <property name="EmitStyleReference" type="bool">True</property>
            <property name="ShowPreferencesLink" type="bool">True</property>
            <property name="ServerIncludeScriptsJson" type="string">null</property>
            <property name="IncludeResultTypeConstraint" type="bool">False</property>
            <property name="Height" type="string" />
            <property name="MaxPagesBeforeCurrent" type="int">4</property>
            <property name="ResultType" type="string" />
            <property name="ShowDidYouMean" type="bool">False</property>
            <property name="StartingItemIndex" type="int">1</property>
            <property name="AlwaysRenderOnServer" type="bool">False</property>
            <property name="GroupTemplateId" type="string">&#126;sitecollection/_catalogs/masterpage/Display Templates/Content Web Parts/Group_Content.js</property>
            <property name="ResultTypeId" type="string" />
            <property name="ItemTemplateId" type="string">&#126;sitecollection/_catalogs/masterpage/Display Templates/Search/Item_LearningGroup.js</property>
            <property name="AllowConnect" type="bool">True</property>
            <property name="HelpUrl" type="string" />
            <property name="ResultsPerPage" type="int">10</property>
            <property name="RenderTemplateId" type="string">&#126;sitecollection/_catalogs/masterpage/Display Templates/Content Web Parts/ListWithPaging.js</property>
            <property name="AllowEdit" type="bool">True</property>
            <property name="AllowZoneChange" type="bool">True</property>
            <property name="AddSEOPropertiesFromSearch" type="bool">False</property>
            <property name="AdvancedSearchPageAddress" type="string">advanced.aspx</property>
            <property name="HitHighlightedPropertiesJson" type="string">["Title","Path","Author","SectionNames","SiteDescription"]</property>
            <property name="TitleUrl" type="string" />
            <property name="EmptyMessage" type="string" />
            <property name="ShowBestBets" type="bool">False</property>
            <property name="ShowViewDuplicates" type="bool">False</property>
            <property name="AllowHide" type="bool">True</property>
            <property name="BypassResultTypes" type="bool">True</property>
            <property name="Description" type="string">Content Search Web Part will allow you to show items that are results of a search query you specify. When you add it to the page, this Web Part will show recently modified items from the current site. You can change this setting to show items from another site or list by editing the Web Part and changing its search criteria.As new content is discovered by search, this Web Part will display an updated list of items each time the page is viewed.</property>
            <property name="ShowSortOptions" type="bool">False</property>
            <property name="ExportMode" type="exportmode">All</property>
            <property name="AllowMinimize" type="bool">True</property>
            <property name="ShowPersonalFavorites" type="bool">False</property>
            <property name="ChromeType" type="chrometype">None</property>
            <property name="ShowPaging" type="bool">True</property>
            <property name="ChromeState" type="chromestate">Normal</property>
            <property name="CatalogIconImageUrl" type="string" />
            <property name="HelpMode" type="helpmode">Modeless</property>
            <property name="TitleIconImageUrl" type="string" />
            <property name="ItemBodyTemplateId" type="string" />
            <property name="AlternateErrorMessage" type="string" null="true" />
            <property name="Hidden" type="bool">False</property>
            <property name="TargetResultTable" type="string">RelevantResults</property>
            <property name="AllowClose" type="bool">True</property>
            <property name="MissingAssembly" type="string">Cannot import this Web Part.</property>
            <property name="ShowResultCount" type="bool">True</property>
            <property name="ShowLanguageOptions" type="bool">True</property>
            <property name="ShowUpScopeMessage" type="bool">False</property>
            <property name="Width" type="string" />
            <property name="RepositionLanguageDropDown" type="bool">False</property>
            <property name="Title" type="string">Search Learning Groups</property>
            <property name="ScrollToTopOnRedraw" type="bool">False</property>
            <property name="ShowResults" type="bool">True</property>
            <property name="ShowAlertMe" type="bool">False</property>
            <property name="OverwriteResultPath" type="bool">True</property>
            <property name="PreloadedItemTemplateIdsJson" type="string">null</property>
            <property name="MaxPagesAfterCurrent" type="int">1</property>
            <property name="ShowDefinitions" type="bool">False</property>
            <property name="ShouldHideControlWhenEmpty" type="bool">False</property>
            <property name="AvailableSortsJson" type="string">null</property>
            <property name="DataProviderJSON" type="string">{"QueryGroupName":"f5646507-4a7a-4d75-b5c4-d435b9128e2a","QueryPropertiesTemplateUrl":"sitesearch://webroot","IgnoreQueryPropertiesTemplateUrl":false,"SourceID":"8413cd39-2156-4e00-b54d-11efd9abdb89","SourceName":"Local SharePoint Results","SourceLevel":"Ssa","CollapseSpecification":"","QueryTemplate":"Path:{SiteCollection.URL}  AND  :{SearchBoxQuery} ","FallbackSort":[],"FallbackSortJson":"[]","RankRules":[],"RankRulesJson":"[]","AsynchronousResultRetrieval":false,"SendContentBeforeQuery":true,"BatchClientQuery":true,"FallbackLanguage":-1,"FallbackRankingModelID":"","EnableStemming":true,"EnablePhonetic":false,"EnableNicknames":false,"EnableInterleaving":false,"EnableQueryRules":true,"EnableOrderingHitHighlightedProperty":false,"HitHighlightedMultivaluePropertyLimit":-1,"IgnoreContextualScope":true,"ScopeResultsToCurrentSite":false,"TrimDuplicates":false,"Properties":{"TryCache":true,"Scope":"{Site.URL}","UpdateLinksForCatalogItems":true,"EnableStacking":true,"ListId":"60ae8593-eddc-45e0-802a-27f78059ce26","ListItemId":4},"PropertiesJson":"{\"TryCache\":true,\"Scope\":\"{Site.URL}\",\"UpdateLinksForCatalogItems\":true,\"EnableStacking\":true,\"ListId\":\"60ae8593-eddc-45e0-802a-27f78059ce26\",\"ListItemId\":4}","ClientType":"ContentSearchRegular","UpdateAjaxNavigate":true,"SummaryLength":180,"DesiredSnippetLength":90,"PersonalizedQuery":false,"FallbackRefinementFilters":null,"IgnoreStaleServerQuery":false,"RenderTemplateId":"DefaultDataProvider","AlternateErrorMessage":null,"Title":""}</property>
            <property name="Direction" type="direction">NotSet</property>
          </properties>
        </data>
      </webPart>
       

    When we are downloading the 'Top Queries by Month' or 'Top Queries by Day' report, while we see numbers in 'Total Queries' and '% of all queries' columns, we are not finding anything in 'Query Text' column, its empty. Not sure while the analytics is not able to fetch/report the 'Query Text' itself - the report doesnt make any sense without 'Query Text' information.

    Is there anything in the web part markup I pasted above- is any of the property value is affecting this?

    Or it can be some configuration/error with the logging/analytics process?

    Please suggest. Thanks in advance.

    Regards,

    Mahavir

     


    MOSS programmer

    Tuesday, January 6, 2015 7:43 AM

Answers

  • Hi,

    Hope you are doing well. Would you help to try to run the script to start the timer job manually:

    1. Run the script to start the timer job:

    ==================

    $ua = Get-SPTimerJob -Type Microsoft.Office.Server.Search.Analytics.UsageAnalyticsJobDefinition

    $ua.GetAnalysisInfo()

     

    $ua = get-sptimerjob -type microsoft.office.server.search.analytics.usageanalyticsjobdefinition

    $ua.DisableTimerJobSchedule()

    $ua.StartAnalysis()

    $ua.EnableTimerJobSchedule()

     

    $ua = Get-SPTimerJob -Identity ("job-usage-log-file-import")

    $ua.RunNow()

    ==================

    2.  Please install the SharePoint 2013 March update if our version is before this:

    SharePoint 2013 March update:

    http://support.microsoft.com/kb/2767999

    Best Regards,

    Dats Luo

    Wednesday, January 21, 2015 9:34 AM

All replies

  • Hi,

    Thank you for your post.

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

    Best Regards,

    Lisa Chen

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact  tnmff@microsoft.com.


    Lisa Chen
    TechNet Community Support

    Wednesday, January 7, 2015 10:11 AM
    Moderator
  • Hi,

    The report result empty issue should related to the Analyze report. Would you let me know the sharepoitn 2013 version? If it is not the latest version, please upgrade to the lastest version and check if the report works well.

    Best Regards,

    Dats Luo

    Monday, January 12, 2015 7:23 AM
  • try this link:

    http://www.sharepointpals.com/post/Step-by-steps-on-how-to-display-Most-Visited-Sites-with-number-of-view-count-in-SharePoint-2013-Web-Analytics

    Monday, January 12, 2015 8:41 AM
  • Hi,

    I would like to know how things are going.

    Best Regards,

    Dats Luo

    Tuesday, January 20, 2015 9:47 AM
  • Hi,

    Hope you are doing well. Would you help to try to run the script to start the timer job manually:

    1. Run the script to start the timer job:

    ==================

    $ua = Get-SPTimerJob -Type Microsoft.Office.Server.Search.Analytics.UsageAnalyticsJobDefinition

    $ua.GetAnalysisInfo()

     

    $ua = get-sptimerjob -type microsoft.office.server.search.analytics.usageanalyticsjobdefinition

    $ua.DisableTimerJobSchedule()

    $ua.StartAnalysis()

    $ua.EnableTimerJobSchedule()

     

    $ua = Get-SPTimerJob -Identity ("job-usage-log-file-import")

    $ua.RunNow()

    ==================

    2.  Please install the SharePoint 2013 March update if our version is before this:

    SharePoint 2013 March update:

    http://support.microsoft.com/kb/2767999

    Best Regards,

    Dats Luo

    Wednesday, January 21, 2015 9:34 AM
  • Hi there,

    I am running SharePoint 2016 and facing the same issue with empty 'query text' column in the Search Reports.  I tried running the commands above but I don't see any additional results in the reports...  Is there some other timer job I should check?

    Thanks,

    Amy

    Thursday, January 12, 2017 9:18 PM