AnsweredAssumed Answered

CA PPM 15.2 - DWH_CMN ERROR_MESSAGE table missing

Question asked by RnFernandez on May 3, 2017
Latest reply on Apr 8, 2018 by Suman Pramanik

After updating ca ppm from 15.1 to 15.2 I do not have the table DWH_CMN ERROR_MESSAGE

 

Can I to do some step sequence for add this table?
Can anyone help me?

 

My error when I run the job LOAD DATA WAREHOSE.

 

ERROR 2017-05-03 15:45:15,367 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
2017/05/03 15:45:15 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2017/05/03 15:45:15 - dwh_db_check_ - Couldn't execute SQL: TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE;
2017/05/03 15:45:15 - dwh_db_check_ - EXEC DWH_CFG_PRE_CONFIG_SP 'PPMDBLINK.niku.niku', 'Y'
2017/05/03 15:45:15 - dwh_db_check_ -
2017/05/03 15:45:15 - dwh_db_check_ - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_CMN_ERROR_MESSAGE" because it does not exist or you do not have permissions.
null

Outcomes