SQL 2014 STRING_AGG Not Recognized
Issue
If you try to import from a SQL 2014 database, you may see the following error:
"OPC import fails with error: 'STRING_AGG' is not a recognized built-in function name."
 |
Cause
Older versions of WIN-911 (3.19.X and earlier) shipped with SQL 2014; STRING_AGG was added in SQL 2017.
Since the SQL import for OPC was introduced in WIN-911 2021R5, SQL 2017 is now the minimum supported version of SQL for the 2021 R5 release.
Installs of WIN-911 2021 R5 targeting SQL 2014 will otherwise function, but attempts to import OPC configurations from SQL will result in the error shown above.
Solution
Running Microsoft's installer for SQL 2017 or 2019 provides an option to upgrade to a supported SQL Server and enable OPC import functionality as well.
 |