ORA-00904: "TEAM_DEF_KEY": invalid identifier on DWH job full load
Article ID: 125144
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS - Application
Clarity PPM On Premise
Upgraded PPM environment to 18.104.22.168 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.
'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.