CA PPM: Load Data Warehouse Access Rights job fails on view creation (MSSQL)

Article Id: 108936

Status: Published

Updated On: 31-07-2018 14:35

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

The job fails with error:
Cannot create index on view 'DWH_SEC_INV_OBS_PARTIAL_MV'.
It does not have a unique clustered index

Cause:

The view is missing 2 indexes.

Environment:

15.4+

Resolution:

Solution Options:

1. The DBA team will need to recreate the indexes by copying/creating the indexes from a working environment to the environment having the issue or

2. The CA PPM administrator will need to run the dbpatch command.