Affected Software/Reports/DLL(s): EQuIS Professional and Enterprise
Affected Software Version/Build: 7.21.2 and up
Symptoms: After upgrading from a build lower than 7.21.1, a user may encounter difficulties accessing reports or user reports, and the following message appears to the user or in the equisdebug.log file.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'STRING_SPLIT'.
at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, IDbCommand Command)
at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, String CommandText)
Cause/Details: EQuIS build 7.21.2 started using the STRING_SPLIT SQL operator, which requires a database compatibility level and server of at least SQL Server 2016 (130).
Resolution/Workaround: Have a database administrator set the compatibility level of the database to a supported version of SQL Server, such as "SQL Server 2017 (140)". Consult the EQuIS Hardware and Software Requirements prior to each upgrade.
Copyright © 2022 EarthSoft, Inc • Modified: 20 Jul 2022