Getting Error while Migrating QS dashboard in using Cloud formation in AWS

Question & Answer
, , , , ,
1

Hi Team, i got below error

Properties validation failed for resource d953c80d436947b0a7b1664FB3 with message: #/Definition/Sheets/0/Visuals/2/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Suffix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/2/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/3/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Suffix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/3/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/4/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/5/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/6/GaugeChartVisual/Subtitle/FormatText/PlainText: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/6/GaugeChartVisual/ChartConfiguration/FieldWells/TargetValues/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/6/GaugeChartVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/7/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/8/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/9/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Suffix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/9/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/15/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Suffix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/15/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/CurrencyDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/16/BarChartVisual/Subtitle/FormatText/PlainText: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/17/GaugeChartVisual/ChartConfiguration/FieldWells/TargetValues/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/17/GaugeChartVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/Definition/Sheets/0/Visuals/18/KPIVisual/ChartConfiguration/FieldWells/Values/0/NumericalMeasureField/FormatConfiguration/FormatConfiguration/PercentageDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0 #/

Any idea about this?

1 Like
2

Hello @Venkat.Metadata

In the analysis/dashboard definition, do you notice anything specifically wrong about those visuals? I’ve never run into this specific error but something similar and I was able to get around it by making corrections to the visuals.

3

@duncan , the analysis is fine - no error in the analysis or in any visual.

image
image1817Ă—558 67.5 KB

  1. Do i need to specify the data type whenever we created a measure ?

I have created calculated column ( Values like 0.94, 0.90, 0.87, like that ) which is using for the Percentage showing in the On time delivery part.

  1. which / where need to define the data type of a calculated column / measure in QS?

  2. It is mandatory to put prefix/suffix values while specifying the column / measure formatting.

  3. Can you pls define the error

#/Definition/ColumnConfigurations/7/FormatConfiguration/StringFormatConfiguration/NumericFormatConfiguration/NumberDisplayFormatConfiguration/Prefix: expected minLength: 1, actual: 0

1 Like
4

Hello @Venkat.Metadata

Based on the error my assumption is that requires a string that is at least 1 character length. Have you tried adding a placeholder value to see if that satisfies the error message?

5

@duncan , I tried by placing 1 character & 2 character string in Suffix & Prefix options.
Still getting error. So, we just did manual changes in the JSON script ( actually this was created when we run a script using Dashboard ID in AWS CloudShell )

Then the Migration is successful.

  1. Is it mandatory to place a suffix / Prefix for every Integer Measure / Column when we place that field in the Visual. Because we are already formatting that field to Number or Currency or Percentage after inputting field in the visual?

  2. Based on the definition can we find which error is belong to which visual?

2 Likes
6

Hello @Venkat.Metadata

I’m glad you were able to find a solution, and thank you for sharing the fix!

As for your questions, I’m not sure why you received that error because you shouldn’t need to create prefix/suffix for every visual. For the second part, each error message has a breakdown of where the error is happening. For example: “#/Definition/Sheets/0/Visuals/2/KPIVisual/etc…” is referring to your 3rd visual, a KPI, on the 1st sheet of your dashboard. Then every subsequent part of the error message is defining the subpart.

When debugging a JSON/YAML definition I like to use the documentation as a sort of map:

1 Like