locked
Error Dashboard: Has exceeded the maximum record limit... RRS feed

  • Question

  • Hi.

    I have the following problem

    when I make a chart in a dashboard with more than 50000 records I get the following message:

    "Has exceeded the maximum record limit..."

     

    How I can fix it?

    Thx.

    Friday, June 22, 2012 4:30 PM

Answers

All replies

  • You should setup your filter not to return more than 50.000 records

    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist CRM Online 30 Tage kostenfrei testen – http://crm.dynamics.com/de-de/trial-overview

    Friday, June 22, 2012 4:34 PM
  • How do I do that?
    Friday, June 22, 2012 4:38 PM
  • http://blogs.msdn.com/b/crm/archive/2010/11/12/simple-chart-modification-in-microsoft-dynamics-crm-2011.aspx?goback=%2Egde_21231_news_255223254

    as an example


    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist CRM Online 30 Tage kostenfrei testen – http://crm.dynamics.com/de-de/trial-overview

    Friday, June 22, 2012 4:46 PM
  • ok. This is my fetc, but I dont get filter not to return more than 50.000 records.

    However, the graph should be drawn with all records!!

    <visualization>
      <visualizationid>{xxxxx-xxxxx-xxxxx-xxxxx-xxxxx}</visualizationid>
      <name>EstadoP</name>
      <primaryentitytypecode>contact</primaryentitytypecode>
      <datadescription>
        <datadefinition>
          <fetchcollection>
            <fetch mapping="logical" aggregate="true">
              <entity name="contact">
                <attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="new_estadoparticipante" />
                <attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="fullname" aggregate="count" />
              </entity>
            </fetch>
          </fetchcollection>
          <categorycollection>
            <category alias="_CRMAutoGen_groupby_column_Num_0">
              <measurecollection>
                <measure alias="_CRMAutoGen_aggregate_column_Num_0" />
              </measurecollection>
            </category>
          </categorycollection>
        </datadefinition>
      </datadescription>
      <presentationdescription>
        <Chart Palette="None" PaletteCustomColors="149,189,66; 197,56,52; 55,118,193; 117,82,160; 49,171,204; 255,136,35; 168,203,104; 209,98,96; 97,142,206; 142,116,178; 93,186,215; 255,155,83">
          <Series>
            <Series ChartType="Bar" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40">
              <SmartLabelStyle Enabled="True" />
            </Series>
          </Series>
          <ChartAreas>
            <ChartArea BorderColor="White" BorderDashStyle="Solid">
              <AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
                <MajorGrid LineColor="239, 242, 246" />
                <MajorTickMark LineColor="165, 172, 181" />
                <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
              </AxisY>
              <AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
                <MajorTickMark LineColor="165, 172, 181" />
                <MajorGrid LineColor="Transparent" />
                <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
              </AxisX>
            </ChartArea>
          </ChartAreas>
          <Titles>
            <Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59"></Title>
          </Titles>
        </Chart>
      </presentationdescription>
      <isdefault>false</isdefault>
    </visualization>

    Friday, June 22, 2012 5:21 PM
  • Do not have a solution?

    Tuesday, June 26, 2012 2:15 PM
  • You can set the Registry Key AggregateQueryRecordLimit on client side.

    This way you can return more than 50,000 records


    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist CRM Online 30 Tage kostenfrei testen – http://crm.dynamics.com/de-de/trial-overview

    Tuesday, June 26, 2012 3:21 PM
  • Same as http://social.microsoft.com/Forums/da-DK/crm/thread/4e8980cb-cae6-4008-a6a4-fd604e8ad974 which has just been answered.

    Rune Daub Senior Consultant - Dynateam CRM http://www.xrmmanagement.com

    Tuesday, June 26, 2012 6:55 PM