ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Project Status List Report not Grouping by Stage

book

Article ID: 212347

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Modifying the Out of the Box stages under lookup INV_TYPE may cause the Project Status List Report to not group by stage correctly.

This happens when you add a new parent level under INV_PROJECT_TYPE and then inactivate the OOTB values under  INV_PROJECT_TYPE

Steps to Reproduce:

  1. Create a new item under INV_PROJECT_TYPE called Ideation
  2. Add 5 values to this new item under INV_STAGE_TYPE
    • IE: Ballpark, Order of Magnitude, Steering, Ready to Convert, Bus Justification
  3. Go to the OOTB   IT under INV_PROJECT_TYPE
  4. Deactivate the OOTB values
  5. Add these new ones:

                         Lookup Value                                                       ID                                                           Description  

   Project Stage 1 Ideadtion and Initiation         PROJECT_LIFECYCLE_STAGE_1          Project Stage 1 Ideadtion and Initiation
   Project Stage 2. Plan and Analysis                PROJECT_LIFECYCLE_STAGE_2          Project Stage 2. Plan and Analysis
   Project Stage 3. Design                                 PROJECT_LIFECYCLE_STAGE_3          Project Stage 3. Design
   Project Stage 4. Build and Test                      PROJECT_LIFECYCLE_STAGE_4          Project Stage 4. Build and Test
   Project Stage 5. Deploy                                 PROJECT_LIFECYCLE_STAGE_5          Project Stage 5. Deploy
   Project Stage 6. Close                                   PROJECT_LIFECYCLE_STAGE_6          Project Stage 6. Close

    6. Create status reports for several projects

    7. Assign a variety of Stages to different projects. Make sure to include several of these new ones.

    8. Run Load Data Warehouse job

    9. Go to Advanced Reporting or Reports and jobs and select Project Status Report List

    • Group by Stage
    • Make sure you are not limiting it to a certain Work Status or Project Type or Status Reporting

Expected Results: The report groups by stage correctly.

Actual Results: The stages are jumbled and repeated throughout the report.

Cause

Reported as defect DE60374.  

Environment

Release : 15.9.1

Component : CA PPM SAAS JASPERSOFT

Resolution

Fixed in 15.9.2