Operator Console 20.4 - CU2 problems on MS SQL 2014

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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.

Environment

Release : 20.4

Component : UIM - INSTALL

Cause

The problem is not reproduced in MS SQL 2014 SP3.

Apparently the SP3 adds the STRING_SPLIT function to the Server.

Resolution

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
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/product-compatibility/ca-uim-compatibility-matrix.html#concept.dita_3e0b025267e987b38f84e5c201b1b6f9da447ad5_ComponentSupportMatrix