ORA-00904: "TEAM_DEF_KEY": invalid identifier on DWH job full load

book

Article ID: 125144

calendar_today

Updated On:

Products

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

Issue/Introduction



Upgraded PPM environment to 15.5.1.240 and faced the error ORA-00904: "TEAM_DEF_KEY": invalid identifier on DWH job full load.

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_RES_RESOURCE). SQLERRM : ORA-00904: "TEAM_DEF_KEY": invalid identifier
ORA-06512: at line 31

Please provide the resolution for the error.

 

Environment

PPM 15.5.1

Resolution

 'TEAM_DEF_KEY' and 'IS_TEAM' columns on DWH_RES_RESOURCE table are used for New User interface(UI). 

Then check for 'Activate New User Experience' on New User Experience under Administration -> General Settings -> System Options and run the DWH job full load again.