Quicksight describe-analysis-definition - json having errors

Q&A
, ,
1

Using “aws quicksight describe-analysis-definition --aws-account-id xxxxxx --analysis-id yyyyy > output.json”, the json contains Error. How to fix them?

ERROR 1 I am unable to find the filter control in the specified sheet.

“Errors”: [
{
“Type”: “FILTER_NOT_FOUND”,
“Message”: “Filter that used in the filter control can not be found in Analysis”,
“ViolatedEntities”: [
{
“Path”: “sheet/d6dee315-9df9-4b9d-a499-bd8a6ce377d4/filter-control/337a8532-618d-4636-aede-ff7dc671dcda”
}
]
},…

ERROR 2 “DataSetIdentifier” & “ColumnName” not resolved. I am unable to find the erroneous filter.

“FilterGroupId”: “9098bd67-492c-4511-bbde-24be66dbe718”,
“Filters”: [
{
“CategoryFilter”: {
“FilterId”: “2ecac861-93eb-414e-babf-4c4e2638d892”,
“Column”: {
“DataSetIdentifier”: “d268de1f-e780-4afa-886c-1ce19bc0184d”,
“ColumnName”: “c0e552a3-ad3b-4f4d-a3c0-c35a16ddfa8c.month”
},
“Configuration”: {
“CustomFilterConfiguration”: {
“MatchOperator”: “EQUALS”,
“ParameterName”: “paramAsOfMonth”,
“NullOption”: “NON_NULLS_ONLY”
}
}
}
}
]

2

Hi @lbl
are you able the trace the errors within the analysis itself? e.g. which filter it is and if it is working in analysis.
BR

3

hi @ErikG
I was tracing using the analysis and unable to see any problem.
Then found out that erroneous components were hidden behind other components.
After clearing those components hidden behind other components, I still have below error which unable to find out.

"Errors": [
    {
        "Type": "COLUMN_NOT_FOUND",
        "Message": "Column that used in the filter can not be found in Dataset",
        "ViolatedEntities": [
            {
                "Path": "filter-group/9098bd67-492c-4511-bbde-24be66dbe718/filter/2ecac861-93eb-414e-babf-4c4e2638d892"
            }
        ]
    },
    {
        "Type": "FILTER_SOURCE_PARAMETER_NOT_FOUND",
        "Message": "The filter is using a parameter that has been deleted. Choose a new parameter and save changes.",
        "ViolatedEntities": [
            {
                "Path": "filter-group/9098bd67-492c-4511-bbde-24be66dbe718/filter/2ecac861-93eb-414e-babf-4c4e2638d892"
            }
        ]
    }
],

Thanks!

4

Hi @lbl,
It’s been awhile since last communication took place on this thread, are you still encountering the same errors or were you able to find a work around for your case?

What is your goal from using describe-analysis-definition? Depending on what you are trying to complete, I would suggest exploring the create-template CLI as it’s less error prone

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

5

hi @Brett
Thanks, I had switched to use template.

1 Like