An Expression Services Limit Has Been Reached

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

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, 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)".