In MSSQL 2016, Achilles fails on analysis 2004 with the error: “The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query.”
One of our developers looked into it and found this article
https://www.mssqltips.com/sqlservertip/5279/sql-server-error-query-processor-ran-out-of-internal-resources-and-could-not-produce-a-query-plan/
. If you break the SQL statement into 3 queries and UNION them, it appears to work. Just wanted to make everyone aware.
Thanks!
Jeff Klann