I’m having weird problem with quicksight. I’m running Quicksight stuff on two AWS accounts.
On account A exists Analysis that I made template of, copied it to Account B and created Dashboard out of the template.
On account A, the analysis (or dashboard made from it) works as expected. On account B everything else seems to work fine, except that one Pie Chart widget says:
Your calculated field expression contains invalid syntax. Correct the syntax and try again. Show details
And in the details, it says:
This is NOT really helpful error message. Unknown symbol where? and where did it came from? IS it unknown symbol in data or where? It says that calculated field expression has invalid syntax but related to that widget there is no calculated expression used.
I have checked data-sets, that they have same data types and name of the fields also match.
How can I debug such error further?
it’s data model is cases sensitive, can you please check the dataset column name as other env.
second thing you can check your filter on it.
this may help you.
Thanks for quick response, field names are exactly the same. And I would assume that the dashboard creation would fail, if it didn’t find all the required fields in data-sets? All creations to account B have been done with AWS CLI tool, so through API and not with clickops.
There is a parameter based filter on that field, but the casing is correct also there and that parameters is also used in other Bar Chart widgets, that works just fine.
Any other ideas?
Took a copy of the analysis on Account A and re-created the problematic widget exactly the same way as it was, using same data-sets, filters, parameters, etc. then did the whole thing again: analysis (account A)->tempalate(account A)->template(account B)->dashboard(account B)
…and magically everything seems to work? Really weird bug.
Could you please create a ticket providing the problematic dashboard/analysis URL? This might be related to a side effect of an optimization we have tested for a day on “preview accounts” and probably your account is part of preview. We can confirm it once we have all the details.