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)".
Copyright © 2021 EarthSoft, Inc • Modified: 27 Jul 2021