data_engine get disconnected from database

book

Article ID: 130435

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

After certain time data_engine get disconnected from database server.

you can get at data_engine log messages like:

Mar  3 11:15:31:776 [14656] de: [Monitor] has disconnected from database

 

Cause

Customer was using SQL 2016 with database in compatibility mode SQL Server 2012.
MS SQLServer  2016,is not supported with UIM 8.51 
For checking supported databases review Compatibility Matrix at:
. https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/installing-ca-uim/pre-installation-planning/product-compatibility/ca-uim-compatibility-matrix
 

Environment

UIM 8.51 
CA_UIM Database on SQL Sever 2016 using SQL Server 2012(110) Compatibility level 
 

Resolution

Change database to use MS SQL Server 2016 in 2014 Compatibility mode or Upgrade to UIM 9.02 

Additional Information

MS SQL 2016 support for UIM 8.51 database

CA UIM Compatibility Matrix