I have an extract based on Teradata server and I'm running it on my server machine.Its fetching 200M+ rows.Strange thing is,its able to fetch all the required data within 2.5-3hours but after that its stuck in "Executing Query" phase from last 5 hours.There is no change in underlying data structure and no. of records are also same.
Has anyone else faced similar situation ? What can be the root cause here ?
When I've seen issues with extracts getting stuck on the "Executing Query" phase, the solution has been to create the extract again from scratch, republish, and replace the data source on any workbooks that use the troublesome extract.