System Error on both Role Capacity and Role Capacity Histogram Portlets

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

Issue: 

The resource planning portlets not working. From the home menu , under Resource Management -->Resource Planning

the Role Capacity Histogram portlet and Role Capacity return the below error:

Error: System error. Contact system administrator.

 

Some examples of errors that might be shown in the app-ca.log for this issue:

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string

or 

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string 

Cause:

If both of these portlets are erroring, one typical cause is due to an incorrect NLS Date Format set in the Database. This parameter should match the guidelines for database parameters listed in the PPM Intallation guide based on your PPM version.

 

Resolution:

 

1. Run below queries to confirm if this is due to a NLS Date Format issue:

 

select * from nls_database_parameters; 

select * from nls_instance_parameters; 

select * from nls_session_parameters; 

 

   2.  Verify that  NLS_Date_Format is set to: YYYY-MM-DD hh24:mi.

 

   3. If not, below are the steps to update the NLS Date Format: 

 

• Run the below query:

alter system set nls_date_format="yyyy-mm-dd hh24:mi:ss" scope=spfile; 

 

• Restart Oracle Services.

 

• PPM services connected to Oracle will also probably need to be restarted after that as well.

 

Additional Information:

TEC535754 Required Oracle Database Parameters for use with Clarity

TEC581262 If nls_date_format is incorrect, you cannot filter for timesheets by prior time period or current time period as it throws a system error.

TEC572798 Timesheet Browsing Error 500

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: