Error while adding CMDB to ITA : Conversion failed when converting the varchar value '*' to data type int.

Products

• IT Management Suite
• IT Analytics

Issue/Introduction

While trying to add a CMDB connection the dependency update is failing with "Exception: Conversion failed when converting the varchar value '*' to data type int."

 

Exception: Conversion failed when converting the varchar value '*' to data type int.

Cause

 Defect

Resolution

Symantec is aware of the issue and working toward a solution in future releases.

In order to fix the issue modify the spITAnalytics_CSMP_CreateViews stored procedure, replace it with the attached one.

 

Applies To

IT Analytics 7.5 SP1 (7.5.2020)

IT Analytics 7.6

IT Analytics 8.0