System error or error 500 when clicking on Team Properties icon if loading pattern is not set on effort task assignment in Clarity PPM

Document ID : KB000030813
Last Modified Date : 30/01/2019
Show Technical Document Details
Issue:

Error 500 - Internal Server Error or System Error is generated when clicking on the properties icon for one or more resources on the Team tab if the resource's loading pattern on the effort task is blank. 

Steps to Reproduce:

1. In Clarity PPM, go to Administration -> Project Management -> Settings and make sure Allow Effort Task Creation is checked

2. Create a new project and add a few resources to the team

3. From the tasks tab, click on Show All to reveal the effort task 

4. Click on the effort task to get to the task properties page with assigned resources listed at the Assignments section

5. Configure the column Loading Pattern to show in the Assignments section

6. Double click on the Loading Pattern field for one of the resources and click on the drop down list, then select [--Select--] and save, then Return

blank pattern effort task assignment list.JPG

7. Go to the project Team tab, click on the Properties icon for the resource updated at the step above

Expected Result: The team staff properties page opens with no error

Actual Result:     The team staff properties page gives a System Error or Error 500 - Internal Server Error

In the App-ca.logs, you'll also see an error similar to the below:

Fatal error getting effort assignment data for team record 5xxxxxx
java.lang.IllegalArgumentException: Cannot format given Object as a Number 
at java.text.DecimalFormat.format(DecimalFormat.java:505) 
at java.text.Format.format(Format.java:157) 

Cause:
This issue is caused by CLRT-77829. This issue can happen if the loading pattern for the resource is blank for the effort task's assignment. The loading pattern for a resource's assignment on a project effort task can be blanked out from the UI (using the steps to reproduce above), or set to NULL by omitting the estPattern attribute in the <TaskLabor> section in project XOG write file when resources are also included. A null loading pattern on effort task will cause the team staff properties page or allocation page for the resource to be inaccessible, throwing a system error or error 500.
Resolution:

Our sustaining team reviewed this issue as CLRT-77829 and closed it as they are not planning to make any changes to this area of the product.

Use the workarounds noted to resolve the issue:

Workaround:      

1. For any impacted projects: From the effort task properties page, set the loading pattern to any valid value for the affected resources:

  • Navigate to a project with the issue and then the Tasks tab.
  • Click on the effort task.
  • In the Assignments section, add Loading Pattern as one of the available columns.
  • For any assignments that have a Loading Pattern of "Selected", change that to any valid value.

2. Correct the project XOG write file to include the estPattern attribute in the <TaskLabor> section

3. You can also disable effort task creation if you don't use this task in projects globally by using the steps below:

  • In Clarity PPM, go to Administration -> Project Management -> Settings
  • Uncheck the field 'Allow Effort Task Creation'
  • Save changes
Additional Information:

See KB000053503 - What is the effort task and how is ETC calculated on it?

Reference the Customer Reported Defect Resolution Policy for CA PPM