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.
CA PPM: Load Data Warehouse Access Rights job fails on view creation (MSSQL)
book
Article ID: 108936
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity 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.