En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Unable to refresh Quicksight dataset. ERROR: Query (39995467) cancelled on user's request

0

Hello, I am not able to refresh the dataset anymore receiving the following error message: This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again. Source error message: ERROR: Query (39995467) cancelled on user's request SQL queries behind are working correctly, how can I dive deep and fix it? Thanks a lot Nicolò

Sujets
AnalytiqueBase de données
Balises
AnalytiqueAmazon QuickSightBase de données
Langue
English
rePost-User-4632342
demandé il y a 2 ans301 vues
1 réponse
0

If you open up the Athena console and check the query history, you should be able to locate the queries that were executed at the time of the Quicksight dashboard refresh. Try refreshing the dashboard once while you have the Athena query history open. Here each query that executes in Athena would be listed and you should be able to see detailed query errors as well that would help identify which queries are timing out or erroring out.

profile pictureAWS
Ananth Tirumanur
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents