Is anyone implemented Clarity 14.3 version on Oracle 12c? If so, what are the issues faced during and after the upgrade? Say, first upgrading 13.3 on Oracle 184.108.40.206 to 14.3 version and then upgrading the database to Oracle 12c.
Can't comment on the Oracle upgrade process per se, but I can recommend that you carefully review the following section:
Specifically, this is one change that should be noted for 12c where I have seen some issues when not done:
Set the following parameter values to optimize performance when running CA PPM Release 14.3 with Oracle 220.127.116.11.optimizer_adaptive_features=false optimizer_inmemory_aware=false optimizer_adaptive_reporting_only=true
Set the following parameter values to optimize performance when running CA PPM Release 14.3 with Oracle 18.104.22.168.
Thanks Marc for your response. Already I went thru it. But I was looking for issues, which occurred during or after Oracle 12c upgrade
If you want I can elaborate on that post-upgrade issue I was talking before (when not done properly, not having the correct configuration noted in my earlier message) on new object creation. New objects were being created with most of the default views missing. But again, that is not an issue if the configuration parameters have been properly set as documented.
Thanks again Marc. Mainly, looking for any performance related issues after Oracle 12c upgrade
We upgraded from 14.2 to 14.3 and also upgraded oracle from 11g to 12c.
The upgrade was successful, but we are facing issue with jobs like Time Slicing, Post Timesheets, Investment Allocation, Update Earned Value and Cost Total. Time Slicing job is not getting completed and other jobs are failing with database error:
ERROR 2016-09-26 01:51:51,167 [Dispatch Post Timesheets 26sep : bg2@APSED1904 (tenant=clarity)] niku.xql2 (clarity:PAGRAWA1:22140093__357380D3-03FC-4F8B-B9E8-A157F53E4254:Post Timesheets 26sep) SQLException with query: select PRAssignment.*, PRTASK.PRPROJECTID from PRAssignment, PRTimeEntry, PRTimeSheet, PRJ_RESOURCES,PRTimePeriod, PRTASK where PRAssignment.prID=PRTimeEntry.prAssignmentID and PRTimeEntry.prTimeSheetID=PRTimeSheet.prID and PRTimeSheet.prStatus=3 and PRTimeSheet.prModTime<? and PRTimeSheet.prResourceID=PRJ_RESOURCES.prID and PRJ_RESOURCES.prTrackMode=2 and PRTimeSheet.prTimePeriodID=PRTimePeriod.prID and PRTimePeriod.prFinish<? and PRAssignment.PRTASKID = PRTASK.PRID java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Operation cancelled by user request.
ERROR 2016-09-26 01:51:51,167 [Dispatch Post Timesheets 26sep : bg2@APSED1904 (tenant=clarity)] xql2.xbl (clarity:PAGRAWA1:22140093__357380D3-03FC-4F8B-B9E8-A157F53E4254:Post Timesheets 26sep) ****POSTTIMESHEET: Error posting timesheet - unknown error-->timesheetID=7986675java.lang.Exception: Invalid expression assignmentQuery: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Operation cancelled by user request.
We are working with CA on this issue.
Even we moved to 12 C .Several system portlets (out of box) are breaking post upgrade .
Checking with CA on those issues .
Did you added the CA recommend optimizer settings in the database as mentioned above in the thread as well .
Please keep this thread posted with the CA investigations so will I .
Piyush & Supriya,
Thank you for your input. We are planning to stay on Oracle 22.214.171.124 version based on Time slice issue.
Yes we have applied those optimizer settings. In addition we have also applied SESSIONS_CACHED_CURSOR=1000 and CURSOR_SHARING=FALSE.
But, still we are getting same error.
Did you face any issue with jobs also?
We have similar problem with CA PPM 14.3 SP10 and Oracle 126.96.36.199, did you resolve your problem ? If yes, how did you do ?
Thank you, Regards Patrice