Problem using Automatic Relationships and Generic Relationships

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

When create Generic Relationships rules only, everything works properly, but when create Automatic Relationships with  Generic Relationships , they do not work, generating SQL errors in the log files. To be able to group specific components it is necessary to use Generic Relationships for Services and Unamanaged Relationships for device components the log shows the error when Generic and Automatic Relationships are enabled:

2024-04-02 09:19:45,436 ERROR  [dataLoaderScheduler-1] servicediscovery.ServiceDiscovery - Service discovery error.. 
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [          
         .... nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'from'.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'from'.

Environment

SOI 4.2

Resolution

1- download the Service-Discovery-4.2.0.jar from attachment

2-  backup the existing Service-Discovery jar present in <install_dir>\ServiceDiscovery

3-  copy the downloaded jar in same path

4- restart Integration Services service.

5- it will take around 30-40 secs to policy to apply