2 Replies Latest reply on Jan 27, 2017 8:29 AM by newepouser

    invalid dashboard query

    newepouser

      I have upgraded my solidcore from 6.1.3 to 7.0.1  and deployed this to the client machine, on my dashboard I am now getting the following displayed

       

      Solidcore:
      Policy Assignments By System

      This query can't be displayed because it is in an
      invalid state. View the query's details for more information.

       

       

      and when I look at the query this is what is says

       

      This query can't be executed or edited because

      of these reasons.

      • The table for a query criteria column does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.PolicyName
      • The table for a query criteria column does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.FeatureTextID
      • The table for a table view column does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.Text
      • The table for a table view column does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.PolicyName
      • The table for a table view column does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.InheritFrom
      • The table of a column used to order table view results does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.Text
      • The table of a column used to order table view results does not exist:
        SCOR_VW_POLICIES_ON_HOSTS.PolicyName
      • The table of a column used to order table view results does not exist: SCOR_VW_POLICIES_ON_HOSTS.InheritFrom

       

      any ideas?