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

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.

Environment

ITMS 8.x, IT Analytics 8.x

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.

Attachments

spITAnalytics_CSMP_CreateViews_Optimized.sql get_app