Load Data Warehouse (DWH) job fails with error: DWH_INV_TEAM: ORA-01452

Document ID : KB000095202
Last Modified Date : 14/05/2018
Show Technical Document Details
Issue:
The Load Data Warehouse (DWH) job fails with the below error due to duplicate entries in the prj_baseline_details table for prteam. 

DWH_INV_TEAM: ORA-01452: cannot CREATE UNIQUE INDEX
 
Cause:
Caused by CLRT-81527/DE30741
Resolution:
Fixed in CA PPM 14.4 and higher

Workaround: Please contact CA Technical Support for analysis and investigation for a possible workaround.