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.
The problem is not reproduced in MS SQL 2014 SP3.
Apparently the SP3 adds the STRING_SPLIT function to the Server.
Release : 20.4
Component : UIM - INSTALL
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)