InterSystems IRIS TSQL Code 146 Could not allocate ancillary table for a

In this post, you’ll learn about the SQL error code 146 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

146

Reason for the Error code 146 in InterSystems IRIS DBMS

Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.