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.

IT Analytics does not display Groups after Upgrade to SEP 14.2 RU2 - Dashboards may be Broken as Well

book

Article ID: 184809

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

IT Analytics does not display groups after upgrade to SEP 14.2 RU2.  Any cube views that contain group information are not functional.  This also affects dashboards as well

N/A

Cause

The DELETED column of the IDENTITY_MAP table in the SEP database no longer supports a NULL value

Environment

IT Analytics For SEP 14.2

Resolution

Modify the following 2 views:

'vITAnalytics_SEP_GroupDim'
'vITAnalytics_SEP_GroupFact'

so that, for every linked server (OPENQUERY) reference, the line that looks like this:

and DELETED IS NULL

now reads like this:

and DELETED = 0