There is a 50 character limit on the SQL Server Name for an MCS profile on OC 20.3.X

book

Article ID: 208209

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

There is a 50 character limit on the SQL Server Name when creating an MCS profile for SQL server. This limit did not exist for UIM 20.1, MSC profiles.

This is the OC screenshot while creating the SQL Server MCS Profile -

In the "Server Name" field, more than 50 character is not allowed.

Cause

After checking the code, this is confirmed that - there should be a 50 character limit on the "Server Name" field, even for 20.1. And, that limit exists for 20.3 as well. Somehow, the older versions might have accepted more than 50 characters for this specific field, but there was a limit from the beginning.

Environment

UIM 20.3.1

OC 20.3.2

sqlserver 5.45

sqlserver_mcs_template

Component : UIM - MON_CONFIG_SERVICE

Resolution

The 50 character limit on the SQL Server Name for an MCS profiles is per design. If customer need longer (>50 character) name field, request needs to be made to our engineering team to get that as a new feature on a new "sqlserver_mcs_templates" package.