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

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

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

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.