drill through stopped working

Dear community

 

I have an issue with some existing drill throughs. They suddenly stopped working. 

This comes after a move to production. They were all right in production, now they stopped.

I have opened the drill through tab in the data reader section, selected one of those that stopped and I managed to run it.

However I can't do this from an existing dataview.

I also checked the trees for the account I am trying to run it for and there is absolutely no difference between the production version before move to prod and the actual version.

 

Has anyone ever experienced the same issue? What should I check in order to have it running again? 

 

Thanks for your help.

 

Xavier Vanderlynden

Answers

  • After some research I found the solution: an order by was placed after the where in the SQL statement, making the Drill through fail.