<< 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.
Copyright © 2024 EarthSoft, Inc. • Modified: 20 Jul 2022