Operator Console 20.4 - CU2 problems on MS SQL 2014
search cancel

Operator Console 20.4 - CU2 problems on MS SQL 2014


Article ID: 241787


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


After installing 20.4 CU2 there have been problems reported while running the OC20.4.2_PLSQL_SQLSERVER.sql on MS SQL 2014 DB

This script includes the T-SQL function STRING_SPLIT which was included the first time with MS SQL 2016.


Release : 20.4

Component : UIM - INSTALL


The problem is not reproduced in MS SQL 2014 SP3.

Apparently the SP3 adds the STRING_SPLIT function to the Server.


To resolve the problem, make sure the SP3 is installed.

You can get the MS SQL version and patch level, running: SELECT @@VERSION

For example, next output shows that the version is MS SQL 2014 SP2:

Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)  Jun 17 2016 19:14:09  Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

and in this example, the output shows it is a MS SQL 2014 SP3:

Microsoft SQL Server 2014 (SP3-GDR) (KB4583463) - 12.0.6164.21 (X64)     Nov  1 2020 04:25:14     Copyright (c) Microsoft Corporation     Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 19044: ) (Hypervisor)



Additional Information

Component Support Matrix