cabi probe in UIM 20.x fails to start, OC logs show Incorrect syntax near 'OFFSET'

Products

• DX Infrastructure Management

Issue/Introduction

 

UIM 20.3 was successfully installed in a sandbox. However, after installing cabi it failed to start and logs from the OC server showed this error message:

Mar 09 09:23:30:045 ERROR [http-nio-80-exec-8, com.firehunter.ump.exceptions.DataFactoryException] Incorrect syntax near 'OFFSET'.
Mar 09 09:23:30:045 ERROR [http-nio-80-exec-8, com.firehunter.ump.exceptions.DataFactoryException] 
Mar 09 09:23:30:045 ERROR [http-nio-80-exec-8, com.firehunter.ump.exceptions.DataFactoryException] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OFFSET'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)

 

Cause

This syntax of using OFFSET in a query is accepted beginning in SQL Server 2012.

SQLServer 2012 or newer is a requisite for UIM 20.3.

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - ALARM VIEWER

Resolution

Microsoft SQLServer 2012 or newer is a pre-requisite for UIM 20.3

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