Can you check if underlying database is accessible to the custom query? Looks like the data source is unavailable.
Hope this helps.
Hi Nachiket, Thanks for the reply.
No it is not an issue with Query. Because i executed the same query in SQL server, it is executed perfectly.
And same query i took extraction in the last week, it was working fine. when i am trying to refresh the extraction, it showing above error.