This content has been marked as final. Show 5 replies
In Physical layer, go to specific database(Physical layer's) properties, database features tab -> Un check the EXPRESSION_IN_ORDERBY_SUPPORTED.
For that failed report, go to Answers-> advance tab-> Look for 'Advanced SQL Clauses'
Check this box to issue an explicit Select Distinct
Let me know updates
If helps Pls mark correct or helpful
Thanks for your reply but both steps you list have already been done. But the result it the same. Any other ideas?
Are you using Order BY clause in any of column expression or the report is having UNION clause with each individual order by clause?
Nothing like that, no unions either. I even just tried clearing out all sorting done. No difference.
On another machine we have 220.127.116.11.0 with a fresh migration and this is not an issue. We will not be upgrading to 6.1 but directly to ..6.2 bp1. I'll update if I see this issue again.