Dataset failed to refresh


I got a error message that my dataset failed to refresh all of sudden. It has been working pretty well for long time.
The error message is REsult size exceeds LISTAGG limit detail. Any suggestion on this? is this a bug?

Hi @Cindy ,
Have you executed query in Redshift directly and verified ? Seems like your underlying query in Redshift failed ? Please note return type for LISTAGG is VARCHAR(MAX). If the result set is larger than the maximum VARCHAR size (64K – 1, or 65535), then LISTAGG returns the error “Result size exceeds LISTAGG limit”.
I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!”

Thanks for your reply.

Yes, the query can be executed sucsessfully in redshift. So the issue is with quicksight. I will open a ticket with quicksight team then.

Do you know if any other work around on this?