After upgrade: Status Report OOTB PMO fields have IS_DELETED =1 in DWH_META_COLUMNS, stock reports fail with "Error filling reports" and ORA-00001 - invalid identifier

Document ID : KB000009097
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

STEPS TO REPRODUCE:

1. Upgrade a working with DWH customer environment to 15.1 (this is an intermittent issue, please use the environment attached for testing)
2. Run Load Data Warehouse job
3. Try to execute reports, such as Project Storyboard

EXPECTED RESULTS: Reports to be working correctly

ACTUAL RESULTS: Reports fail with "Error filling reports" and ORA-00904: invalid identifier in jasperserver.log on the PMO fields, most of the Status Report fields are IS_DELETED =1 in DWH_META_COLUMNS and we are not able to check/uncheck from UI anymore to fix it

Environment:
PPM 15.1, 15.2
Cause:

This is caused by CLRT-81478 / DE32643 and is fixed in 15.3

Resolution:

Run the following query:
update dwh_meta_columns
set is_deleted = 0
where object_code = 'cop_prj_statusrpt'
and is_deleted =1

commit

Run Load Data Warehouse - Full Load