Cannot Access Reports/Invalid object name STRING

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)

at EarthSoft.Common.Forms.PropertyTreeS.UpdatePickReportsValueList()

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.

Cannot Access Reports/Invalid object name 'STRING_SPLIT' (7.21.2+)

Cannot Access Reports/Invalid object name 'STRING_SPLIT' (7.21.2+)