ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 161763

calendar_today

Updated On:

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

Attachments

spITAnalytics_CSMP_CreateViews_Optimized.sql get_app