AnsweredAssumed Answered

CA PPM 15.5 Upgrade Errors

Question asked by Augustin2537 on Sep 14, 2018
Latest reply on Oct 4, 2018 by CandiceWong

Dear CA PPM Experts

 

We are in the process of upgrading CA PPM from 15.2 to 15.5. Although the upgrade was successful, when I executed "admin content csk" as part of the upgrade and verified the admin.log came across the below error lines.

 

 

               9/14/18 4:02 AM (admin) ERROR 14-09 04:02:44,044 - Attribute cop_cost_eft_status is not updated because lookup type cannot be changed.

9/14/18 4:02 AM (admin) ERROR 2018-09-14 04:02:44,044 [main] xql2.xbl Attribute cop_cost_eft_status is not updated because lookup type cannot be changed.

9/14/18 4:02 AM (admin) ERROR 14-09 04:02:48,670 - Attribute cop_schedule_status is not updated because lookup type cannot be changed.

9/14/18 4:02 AM (admin) ERROR 2018-09-14 04:02:48,670 [main] xql2.xbl Attribute cop_schedule_status is not updated because lookup type cannot be changed.

9/14/18 4:02 AM (admin) ERROR 14-09 04:02:48,771 - Attribute cop_scope_status is not updated because lookup type cannot be changed.

               9/14/18 4:02 AM (admin) ERROR 2018-09-14 04:02:48,771 [main] xql2.xbl Attribute cop_scope_status is not updated because lookup type                cannot be changed

 

Also the Load DWH job fails with the below error. There is a case already raised with CA Support and their analysis is in progress. In the mean time, thought of to post it here as well for a quicker fix. Please help.

##         

2018/09/14 05:06:26 - Slices - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :

2018/09/14 05:06:26 - Slices - Couldn't execute SQL: BEGIN^M

2018/09/14 05:06:26 - Slices - DWH_CFG_ADDIN_EXTRAS_SP(P_DBLINK => 'CLARITYDBLINK');^M

2018/09/14 05:06:26 - Slices - DWH_PROC_NEW_VIEWS_SP (P_DBLINK => 'CLARITYDBLINK');^M

2018/09/14 05:06:26 - Slices - END;

2018/09/14 05:06:26 - Slices -

2018/09/14 05:06:26 - Slices - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "R"."SR_COST_EFFORT_STATUS_KEY": invalid identifier 


Outcomes