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 the following errors:

"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

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