• State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 8 subscribers
  • Views 2477 views
  • Users 0 members are here
Options
Related

Dashboard (customers) quickreport doesn't work

Eric Schwartz

Hello,

I have Baccs 5.0.2.

When I try to open Dashboard (customers) from the Quickreports page, it gives me this error message. I haven't changed anything for it to not work. Could you tell me what I need to do please?

Thanks!

Exception occurs while assigning the 'DetailView, ID:DashboardViewer_DetailView' view to WinWindow:
Internal error. Please contact the application vendor or your system administrator and provide the following information.

DevExpress.DashboardCommon.DataProcessing.ExtractPreprocessorException: An error occurred during creation of the data extract:
The following columns cannot be processed:
Customer.Country ---> DevExpress.DataProcessing.ExtractColumnProcessingException: The following columns cannot be processed:
Customer.Country ---> DevExpress.Data.Filtering.Exceptions.InvalidPropertyPathException: Can't find property 'Country'
   at DevExpress.Data.Filtering.Helpers.CriteriaCompilerContextDescriptorReflective.ReflectiveAccessor.AccessThroughPropertyDescriptors(PropertyDescriptorCollection props, Object row)
   at DevExpress.Data.Filtering.Helpers.CriteriaCompilerContextDescriptorReflective.ReflectiveAccessor.GetReflectiveValue(Object source)
   at lambda_method(Closure , Object )
   at DevExpress.DataProcessing.DataReaderExEnumerableWrapper.IsNull(Int32 i)
   at DevExpress.DataProcessing.ExtractStorage.ColumnReader`1.Read()
   at DevExpress.DataProcessing.ExtractPreprocessor.FetchData(IPreprocessingProgressController progress, List`1 columnProcessors, List`1 columnReaders, IExtractWriteSession writeSession)
   --- End of inner exception stack trace ---
   at DevExpress.DataProcessing.ExtractPreprocessor.FetchData(IPreprocessingProgressController progress, List`1 columnProcessors, List`1 columnReaders, IExtractWriteSession writeSession)
   at DevExpress.DataProcessing.ExtractPreprocessor.Process(String name, IExtractWriteSession writeSession)
   at DevExpress.DataProcessing.ExtractPreprocessor.Create(ITypedDataReader reader, String resourceName, ExtractPreprocessingParameters parameters)
   at DevExpress.DashboardCommon.DataProcessing.DashboardExtractHelper.Create(ITypedDataReader reader, String resourceName, ExtractPreprocessingParameters parameters)
   --- End of inner exception stack trace ---
   at DevExpress.DashboardCommon.DashboardObjectDataSource.GetStorageInternal(CancellationToken token)
   at DevExpress.DashboardCommon.DashboardObjectDataSource.DevExpress.DashboardCommon.Native.IDashboardDataSourceInternal.GetStorage(String dataMember)
   at DevExpress.DashboardCommon.DataProcessing.DataSourceModel.Create(IDashboardDataSource ds, String dataMember)
   at DevExpress.DashboardCommon.DataProcessing.DataSourceModel.Create(IDashboardDataSource ds, String dataMember, IDataFlowStorage storage)
   at DevExpress.DashboardCommon.Native.DataSourceModelsProvider.GetDataSourceModel(String dataSourceName, String dataMember, IDataFlowStorage storage)
   at DevExpress.DashboardCommon.Native.DashboardColoringValuesProvider.GetColoringValuesCore(IDataSourceMetadata dataSourceMetadata, String dataMember, IEnumerable`1 definitions, IEnumerable`1 filterDimensions, CriteriaOperator filter, IList`1 dashboardItems, IEnumerable`1 items, IActualParametersProvider parameters)
   at DevExpress.DashboardCommon.Native.DashboardColoringValuesProvider.DevExpress.DashboardCommon.Native.IColoringValuesProvider.GetColoringValues(ColorRepositoryKey repositoryKey)
   at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.BuildTable(ColorRepositoryKey repositoryKey, MeasureDefinition[][] measures)
   at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.GenerateColoring()
   at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.GenerateColoringCache(IColoringValuesProvider provider, ColorRepository repository, Int32 paletteColorsCount)
   at DevExpress.DashboardCommon.Server.DashboardSession.EnsureDashboardColoringCache()
   at DevExpress.DashboardCommon.Service.DashboardServiceOperation`1.Execute(DashboardServiceResult result)
Rate translation
×
Suggest better translation
×
  • 0

    Hello, Eric,

    And if to try to open this report in the designer, will it work?

    Eric Schwartz said:
    Customer.Country ---> DevExpress.Data.Filtering.Exceptions.InvalidPropertyPathException: Can't find property 'Country'
       at

    Looks like some error in report configuration. I've installed 5.0.2 now and this report works correctly there. I exported configuration. Try to open it in the designer and import attached xml file.

    Fullscreen db_customers.xml Download 
    <?xml version="1.0" encoding="utf-8"?>
<Dashboard CurrencyCulture="en-US">
  <Title Text="Main dashboard" Alignment="Left" Url="C:\Users\EUGENE\Desktop\index12.png" />
  <DataSources>
    <ObjectDataSource Name="Jobs" ComponentName="dashboardObjectDataSource1">
      <DataSource Type="BaccS_XAF.Module.BusinessObjects.Doc.TranslationJob, BaccS_XAF.Module, Version=5.0.2.0, Culture=neutral, PublicKeyToken=null" />
    </ObjectDataSource>
    <ObjectDataSource Name="Invoice" ComponentName="dashboardObjectDataSource2">
      <DataSource Type="BaccS_XAF.Module.BusinessObjects.Doc.Invoice, BaccS_XAF.Module, Version=5.0.2.0, Culture=neutral, PublicKeyToken=null" />
    </ObjectDataSource>
  </DataSources>
  <Items>
    <Pivot ComponentName="pivotDashboardItem1" Name="Margin" DataSource="dashboardObjectDataSource1">
      <DataItems>
        <Measure DataMember="Margin" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" Precision="1" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="Date" DefaultId="DataItem2" />
        <Dimension DataMember="Customer.Name" DefaultId="DataItem1" />
        <Dimension DataMember="Date" DateTimeGroupInterval="Quarter" DefaultId="DataItem3" />
      </DataItems>
      <FormatRules>
        <PivotItemFormatRule Name="FormatRule 2" DataItem="DataItem0">
          <FormatConditionColorRangeBar ValueType="Percent">
            <RangeSet>
              <Ranges>
                <RangeInfo>
                  <Value Type="System.Double" Value="0" />
                  <BarStyleSettings PredefinedColor="PaleRed" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="25" />
                  <BarStyleSettings PredefinedColor="PaleYellow" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="50" />
                  <BarStyleSettings PredefinedColor="PaleGreen" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="75" />
                  <BarStyleSettings PredefinedColor="PaleBlue" />
                </RangeInfo>
              </Ranges>
            </RangeSet>
            <BarOptions />
          </FormatConditionColorRangeBar>
          <PivotItemFormatRuleLevel />
        </PivotItemFormatRule>
        <PivotItemFormatRule Name="FormatRule 1" Enabled="false" DataItem="DataItem0">
          <FormatConditionAverage>
            <AppearanceSettings AppearanceType="Yellow" />
          </FormatConditionAverage>
          <PivotItemFormatRuleLevel />
        </PivotItemFormatRule>
        <PivotItemFormatRule Name="FormatRule 3" DataItem="DataItem0" IntersectionLevelMode="AllLevels">
          <FormatConditionValue Condition="Less">
            <AppearanceSettings AppearanceType="Red" />
            <Value1 Type="System.Decimal" Value="600" />
          </FormatConditionValue>
          <PivotItemFormatRuleLevel />
        </PivotItemFormatRule>
      </FormatRules>
      <Columns>
        <Column DefaultId="DataItem2" />
        <Column DefaultId="DataItem3" />
      </Columns>
      <Rows>
        <Row DefaultId="DataItem1" />
      </Rows>
      <Values>
        <Value DefaultId="DataItem0" />
      </Values>
      <ShowColumnTotals>false</ShowColumnTotals>
    </Pivot>
    <Grid ComponentName="gridDashboardItem1" Name="Top customers" DataSource="dashboardObjectDataSource1">
      <InteractivityOptions IsDrillDownEnabled="true" />
      <DataItems>
        <Dimension DataMember="Customer.Name" Name="Client" DefaultId="DataItem1" />
        <Measure DataMember="Margin" Name="Margin" DefaultId="DataItem2">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="Date" DefaultId="DataItem5" />
        <Measure DataMember="AmountBase" Name="Amount (base cur.)" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
      </DataItems>
      <FormatRules>
        <GridItemFormatRule Name="FormatRule 2" DataItem="DataItem0">
          <FormatConditionRangeGradient ValueType="Percent">
            <RangeSet>
              <Ranges>
                <RangeInfo>
                  <Value Type="System.Double" Value="0" />
                  <AppearanceSettings AppearanceType="GradientYellow" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="10" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="20" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="30" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="40" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="50" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="60" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="70" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="80" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="90" />
                  <AppearanceSettings AppearanceType="GradientRed" />
                </RangeInfo>
              </Ranges>
            </RangeSet>
          </FormatConditionRangeGradient>
        </GridItemFormatRule>
        <GridItemFormatRule Name="FormatRule 3" DataItem="DataItem2">
          <FormatConditionRangeGradient ValueType="Percent">
            <RangeSet>
              <Ranges>
                <RangeInfo>
                  <Value Type="System.Double" Value="0" />
                  <AppearanceSettings AppearanceType="GradientYellow" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="10" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="20" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="30" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="40" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="50" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="60" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="70" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="80" />
                </RangeInfo>
                <RangeInfo>
                  <Value Type="System.Double" Value="90" />
                  <AppearanceSettings AppearanceType="GradientRed" />
                </RangeInfo>
              </Ranges>
            </RangeSet>
          </FormatConditionRangeGradient>
        </GridItemFormatRule>
      </FormatRules>
      <GridColumns>
        <GridDimensionColumn Weight="78.409781800986281">
          <Dimension DefaultId="DataItem1" />
        </GridDimensionColumn>
        <GridMeasureColumn Weight="53.999189353509415">
          <Measure DefaultId="DataItem0" />
          <Totals>
            <Total Type="Auto" />
          </Totals>
        </GridMeasureColumn>
        <GridMeasureColumn Weight="61.396338580017556">
          <Measure DefaultId="DataItem2" />
          <Totals>
            <Total Type="Auto" />
          </Totals>
        </GridMeasureColumn>
      </GridColumns>
      <SparklineArgument DefaultId="DataItem5" />
      <GridOptions EnableBandedRows="true" ColumnWidthMode="Manual" WordWrap="true" />
    </Grid>
    <Pie ComponentName="pieDashboardItem1" Name="Volumes by customers" DataSource="dashboardObjectDataSource1" ShowPieCaptions="false">
      <DataItems>
        <Dimension DataMember="Customer.Name" DefaultId="DataItem0" />
        <Measure DataMember="AmountBase" DefaultId="DataItem1">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
      </DataItems>
      <Arguments>
        <Argument DefaultId="DataItem0" />
      </Arguments>
      <Values>
        <Value DefaultId="DataItem1" />
      </Values>
    </Pie>
    <Gauge ComponentName="gaugeDashboardItem1" Name="Due invoices" DataSource="dashboardObjectDataSource2" ContentArrangementMode="FixedColumnCount" ViewType="CircularQuarterLeft">
      <DataItems>
        <Measure DataMember="Amount" DefaultId="DataItem1" />
        <Dimension DataMember="Customer.Name" DefaultId="DataItem2" />
        <Measure DataMember="AmountPaid" DefaultId="DataItem0" />
      </DataItems>
      <SeriesDimensions>
        <SeriesDimension DefaultId="DataItem2" />
      </SeriesDimensions>
      <GaugeElement>
        <ActualValue DefaultId="DataItem0" />
        <TargetValue DefaultId="DataItem1" />
        <AbsoluteVariationNumericFormat />
        <PercentVariationNumericFormat />
        <PercentOfTargetNumericFormat />
      </GaugeElement>
    </Gauge>
    <RangeFilter ComponentName="rangeFilterDashboardItem1" Name="Range Filter 1" DataSource="dashboardObjectDataSource2" IsMasterFilterCrossDataSource="true">
      <DataItems>
        <Dimension DataMember="Date" DefaultId="DataItem0" />
        <Measure DataMember="AmountBase" DefaultId="DataItem1" />
      </DataItems>
      <Argument DefaultId="DataItem0" />
      <Series>
        <Simple SeriesType="Line">
          <Value DefaultId="DataItem1" />
        </Simple>
      </Series>
      <DateTimePeriods>
        <DateTimePeriod Name="This Year">
          <StartLimit>
            <FlowDateTimePeriodLimit />
          </StartLimit>
          <EndLimit>
            <FlowDateTimePeriodLimit Offset="1" />
          </EndLimit>
        </DateTimePeriod>
        <DateTimePeriod Name="Last Year">
          <StartLimit>
            <FlowDateTimePeriodLimit Offset="-1" />
          </StartLimit>
          <EndLimit>
            <FlowDateTimePeriodLimit />
          </EndLimit>
        </DateTimePeriod>
        <DateTimePeriod Name="Last 2 Years">
          <StartLimit>
            <FlowDateTimePeriodLimit Offset="-1" />
          </StartLimit>
          <EndLimit>
            <FlowDateTimePeriodLimit Offset="1" />
          </EndLimit>
        </DateTimePeriod>
        <DateTimePeriod Name="Last 3 Years">
          <StartLimit>
            <FlowDateTimePeriodLimit Offset="-2" />
          </StartLimit>
          <EndLimit>
            <FlowDateTimePeriodLimit Offset="1" />
          </EndLimit>
        </DateTimePeriod>
        <DateTimePeriod Name="Last 5 Years">
          <StartLimit>
            <FlowDateTimePeriodLimit Offset="-4" />
          </StartLimit>
          <EndLimit>
            <FlowDateTimePeriodLimit Offset="1" />
          </EndLimit>
        </DateTimePeriod>
      </DateTimePeriods>
    </RangeFilter>
    <ChoroplethMap ComponentName="choroplethMapDashboardItem1" Name="Customers geography" DataSource="dashboardObjectDataSource1" ShapeTitleAttributeName="NAME_LONG" AttributeName="NAME" IncludeSummaryValueToShapeTitle="true">
      <DataItems>
        <Measure DataMember="AmountBase" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="Customer.CountryRef.Name" DefaultId="DataItem1" />
      </DataItems>
      <ViewArea TopLatitude="83.645130000000009" BottomLatitude="-55.611829999999962" LeftLongitude="-179.99999999999997" CenterPointLatitude="44.089080744803773" CenterPointLongitude="10.098071356993813" />
      <MapLegend Visible="true" Position="TopRight" Orientation="Horizontal" />
      <WeightedLegend />
      <AttributeDimension DefaultId="DataItem1" />
      <Maps>
        <ValueMap Name="Amount" ValueName="Amount">
          <Value DefaultId="DataItem0" />
          <UniformScale />
        </ValueMap>
      </Maps>
    </ChoroplethMap>
    <Chart ComponentName="chartDashboardItem1" Name="Uninvoiced jobs" DataSource="dashboardObjectDataSource1" FilterString="[DataItem3] &gt; 0.0000m" Rotated="true">
      <ColoringOptions MeasuresColoringMode="Hue" />
      <InteractivityOptions IsDrillDownEnabled="true" />
      <DataItems>
        <Dimension DataMember="Status" DefaultId="DataItem2" />
        <Measure DataMember="UninvoicedAmount" DefaultId="DataItem0">
          <NumericFormat FormatType="Number" Unit="Ones" IncludeGroupSeparator="true" />
        </Measure>
        <Dimension DataMember="Customer.Name" DefaultId="DataItem1" />
        <Dimension DataMember="UninvoicedAmount" DefaultId="DataItem3" />
        <Measure DataMember="UninvoicedAmount" DefaultId="DataItem4" />
        <Dimension DataMember="Status" DefaultId="DataItem5" />
      </DataItems>
      <HiddenDimensions>
        <Dimension DefaultId="DataItem2" />
        <Dimension DefaultId="DataItem3" />
      </HiddenDimensions>
      <HiddenMeasures>
        <Measure DefaultId="DataItem4" />
      </HiddenMeasures>
      <Arguments>
        <Argument DefaultId="DataItem1" />
        <Argument DefaultId="DataItem5" />
      </Arguments>
      <Panes>
        <Pane Name="Pane 1">
          <Series>
            <Simple>
              <Value DefaultId="DataItem0" />
              <PointLabelOptions OverlappingMode="Reposition" ContentType="Value" />
            </Simple>
          </Series>
        </Pane>
      </Panes>
      <ChartLegend Visible="false" />
    </Chart>
  </Items>
  <LayoutTree>
    <LayoutGroup Orientation="Vertical">
      <LayoutGroup Weight="59.290953545232277">
        <LayoutGroup Orientation="Vertical" Weight="53.016323633782825">
          <LayoutItem DashboardItem="rangeFilterDashboardItem1" Weight="21.855670103092784" />
          <LayoutGroup Weight="78.144329896907223">
            <LayoutItem DashboardItem="gridDashboardItem1" Weight="49.9330655957162" />
            <LayoutItem DashboardItem="pieDashboardItem1" Weight="50.0669344042838" />
          </LayoutGroup>
        </LayoutGroup>
        <LayoutItem DashboardItem="choroplethMapDashboardItem1" Weight="46.983676366217175" />
      </LayoutGroup>
      <LayoutGroup Weight="40.709046454767723">
        <LayoutItem DashboardItem="pivotDashboardItem1" Weight="43.2931156848829" />
        <LayoutItem DashboardItem="gaugeDashboardItem1" Weight="28.388928317955997" />
        <LayoutItem DashboardItem="chartDashboardItem1" Weight="28.317955997161107" />
      </LayoutGroup>
    </LayoutGroup>
  </LayoutTree>
</Dashboard>
  • 0 in reply to Eugene Kuchynski

    No, I'm afraid not. I try to open it with right-click "show quick report designer" and it gives me this error message.

    Internal error. Please contact the application vendor or your system administrator and provide the following information.

    DevExpress.DashboardCommon.DataProcessing.ExtractPreprocessorException: An error occurred during creation of the data extract:
    The following columns cannot be processed:
    Customer.Country ---> DevExpress.DataProcessing.ExtractColumnProcessingException: The following columns cannot be processed:
    Customer.Country ---> DevExpress.Data.Filtering.Exceptions.InvalidPropertyPathException: Can't find property 'Country'
       at DevExpress.Data.Filtering.Helpers.CriteriaCompilerContextDescriptorReflective.ReflectiveAccessor.AccessThroughPropertyDescriptors(PropertyDescriptorCollection props, Object row)
       at DevExpress.Data.Filtering.Helpers.CriteriaCompilerContextDescriptorReflective.ReflectiveAccessor.GetReflectiveValue(Object source)
       at lambda_method(Closure , Object )
       at DevExpress.DataProcessing.DataReaderExEnumerableWrapper.IsNull(Int32 i)
       at DevExpress.DataProcessing.ExtractStorage.ColumnReader`1.Read()
       at DevExpress.DataProcessing.ExtractPreprocessor.FetchData(IPreprocessingProgressController progress, List`1 columnProcessors, List`1 columnReaders, IExtractWriteSession writeSession)
       --- End of inner exception stack trace ---
       at DevExpress.DataProcessing.ExtractPreprocessor.FetchData(IPreprocessingProgressController progress, List`1 columnProcessors, List`1 columnReaders, IExtractWriteSession writeSession)
       at DevExpress.DataProcessing.ExtractPreprocessor.Process(String name, IExtractWriteSession writeSession)
       at DevExpress.DataProcessing.ExtractPreprocessor.Create(ITypedDataReader reader, String resourceName, ExtractPreprocessingParameters parameters)
       at DevExpress.DashboardCommon.DataProcessing.DashboardExtractHelper.Create(ITypedDataReader reader, String resourceName, ExtractPreprocessingParameters parameters)
       --- End of inner exception stack trace ---
       at DevExpress.DashboardCommon.DashboardObjectDataSource.GetStorageInternal(CancellationToken token)
       at DevExpress.DashboardCommon.DashboardObjectDataSource.DevExpress.DashboardCommon.Native.IDashboardDataSourceInternal.GetStorage(String dataMember)
       at DevExpress.DashboardCommon.DataProcessing.DataSourceModel.Create(IDashboardDataSource ds, String dataMember)
       at DevExpress.DashboardCommon.DataProcessing.DataSourceModel.Create(IDashboardDataSource ds, String dataMember, IDataFlowStorage storage)
       at DevExpress.DashboardCommon.Native.DataSourceModelsProvider.GetDataSourceModel(String dataSourceName, String dataMember, IDataFlowStorage storage)
       at DevExpress.DashboardCommon.Native.DashboardColoringValuesProvider.GetColoringValuesCore(IDataSourceMetadata dataSourceMetadata, String dataMember, IEnumerable`1 definitions, IEnumerable`1 filterDimensions, CriteriaOperator filter, IList`1 dashboardItems, IEnumerable`1 items, IActualParametersProvider parameters)
       at DevExpress.DashboardCommon.Native.DashboardColoringValuesProvider.DevExpress.DashboardCommon.Native.IColoringValuesProvider.GetColoringValues(ColorRepositoryKey repositoryKey)
       at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.BuildTable(ColorRepositoryKey repositoryKey, MeasureDefinition[][] measures)
       at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.GenerateColoring()
       at DevExpress.DashboardCommon.Native.ColorSchemeGenerator.GenerateColoringCache(IColoringValuesProvider provider, ColorRepository repository, Int32 paletteColorsCount)
       at DevExpress.DashboardCommon.Server.DashboardSession.EnsureDashboardColoringCache()
       at DevExpress.DashboardCommon.Service.DashboardServiceOperation`1.Execute(DashboardServiceResult result)
  • 0 in reply to Eric Schwartz

    Then, you can try to delete existing report, then create a new one with the same name and import (click Open button) XML file attached above. This will definitely work.