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

Products

• IT Management Suite
• IT Analytics

Issue/Introduction

While trying to add a CMDB connection the dependency update, it is failing with the following error:

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 this issue you'll need to modify the stored procedure spITAnalytics_CSMP_CreateViews and replace it with the one attached to this article.