An Expression Services Limit Has Been Reached

Affected Software/Reports/DLL(s): EQuIS Professional

Affected Software Version: pre-7.21.2

Symptoms: This error message may be received when EQuIS is running a scalar-value function.

System.Data.SqlClient.SqlException(0x80131904): An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Cause/Details: The error may be related to the in-lining of scalar value functions, likely using a build of EQuIS prior to 7.21.2 with a database hosted in SQL Server 2019 and later, which was not yet supported.

Resolution/Workaround: Have a database administrator set the compatibility level of the database to an earlier version of SQL Server, e.g. "SQL Server 2017 (140)".