The job fails with error:Cannot create index on view 'DWH_SEC_INV_OBS_PARTIAL_MV'.It does not have a unique clustered index
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.
Was this information helpful?