I’m trying to bundle this analysis to transfer it, and it’s not letting me due to these errors that show up when I run “describe-analysis-definition.” The problem here is that the dataset that these filters are attached to, so there’s no way for me to delete them. I saw that I could use “update-analysis” as a potential solution, but I’m not familiar with that. Is there another way, or help for using “update-analysis?” Thanks
Hi @ineedqshelp - Is it possible to see this analysis from UI? Looks like the analysis is break and you need to fix it first. I will suggest first check in Quick Sight UI first before start analyzing from cli side.
Regards - Sanjeeb
I can see the analysis from the UI, but these filters with the missing columns aren’t showing up because the dataset that the filters were based on have been removed.
Hi @ineedqshelp - Can you fix the data set first and see whether you are able to describe data set?
Regards - Sanjeeb
How do I fix it? I can’t see the filters that are causing the errors. Should I just try to fix using the update-analysis CLI command?
Hi @ineedqshelp - Can you please remove the filters from the data set which caused the issue and then save it. After that try to describe the analysis to see whether the issue has been fixed or not.
Regards - Sanjeeb
The dataset attached to these filters have been removed from the analysis, that’s why I can’t see them.
Hi @ineedqshelp - Sorry, I am bit confused with the details. Can you please confirm the below details.
- The data set is accessible from UI and there is NO issue .
- The analysis based on the dataset is also accessible from UI and no issues with the analysis. If there is any error in analysis, can you please fix it from UI and save it and ensure no issues with analysis when you are accessing from UI.
Once the above steps are done, can you describe the data set and analysis from CLI as well. If any errors, please share the details.
Tagging @duncan @David_Wong for their expert advise as well.
Regards - Sanjeeb
1 Like
Hi,
I had a similar problem and got the feeling, that the json of the analysis contains old errors.
Can you use the SaveAs Feature in the analysis and create a new analysis? I think the copy wont have the complete history of the original analysis.
2 Likes
Thank you @thomask . Is it possible to share the sample command so that @ineedqshelp can try it quickly. Also can we highlight the issue as a feature request, please advise.
Regards - Sanjeeb
Yes, the analysis has no issues in the UI. The dataset has been removed from the analysis. The describe analysis lists the errors from the filters that were based on a dataset that is no longer attached to the analysis.
Hi @ineedqshelp - This is strange. Is it possible to raise a ticket to AWS Customer support team to look at this.
Regards - Sanjeeb
I submitted a ticket, and I’ll meet with support about this. Could you still help me with using the “update-analysis” CLI command?
update-analysis — AWS CLI 1.29.71 Command Reference (amazon.com)
It’s not currently possible to remove the orphaned filters from the Quick Sight UI. You can try the following:
-
call DescribeAnalysisDefinition to get the analysis JSON:
aws quicksight describe-analysis-definition --region $REGION --aws-account-id $ACCOUNT_ID --analysis-id $ANALYSIS_ID > analysis.json -
Modify the JSON to remove “RequestId”, “ResourceStatus”, and “Status” properties.
-
Modify the JSON to remove the orphaned filters.
-
Call UpdateAnalysis
aws quicksight update-analysis --region $REGION --aws-account-id $ACCOUNT_ID --analysis-id $ANALYSIS_ID --name $ANALYSIS_NAME --cli-input-json file://analysis.json
To be safe, you should save as a new analysis and verify before updating your existing analysis
aws quicksight create-analysis --region $REGION --aws-account-id $ACCOUNT_ID --analysis-id $NEW_ANALYSIS_ID --name $NEW_ANALYSIS_NAME --cli-input-json file://analysis.json
1 Like
For the analysis.json, I need to put the file location, not like copy and paste the json correct? It hasn’t worked for me, so just want to follow up.
Yes, the file location.
Which part didn’t work?
You need to add “file://” to the file path. Please refer to this article:
On Windows, the "
~/" expression expands to your user directory, stored in the%USERPROFILE%environment variable. For example, on Windows 10 you would typically have a user directory underC:\Users\UserName.
1 Like
I got it working but found another issue. The cli is expecting additional fields at the end of the json. It gives me this first error, so I added “” at the end of the json, and then ran it again, and got more things that it expected.
After messing with adding additional information, I deleted all of it and ran it again, and got the “Invalid json received” error.
My JSON was formed from running define-analysis-definition on an the analysis, changing one thing (the dataset that feeds into it, I just changed the IDs at the top of the JSON). What information am I missing that’s causing this to fail?
Hello @ineedqshelp, Thanks for being a part of the Quick Sight Community. In order to get your question prioritized, I recommend that you repost your last response as a new question and link to this question. Our team prioritizes 0 reply questions, and then questions that have not been marked as solved, so this will ensure you receive a more rapid reply from one of our experts. Thank you!