Roadmap Item Scenarios Not Loading

Products

• Clarity PPM SaaS

Issue/Introduction

Roadmaps Item Scenarios are not appearing/loading.

It should display the following as an example:

Request  URL pattern: */ppm/rest/v1/scenarios?fields=name,type,associatedObjectID,isBaseline,isPlanOfRecord,code,description&filter=(type+%3D+%27rdm_roadmap%27)+and+(associatedObjectID+%3D+ROAD_MAP_ID)&limit=500&sort=name

Method: GET

The HAR File just shows pending action
fields: name,type,associatedObjectID,isBaseline,isPlanOfRecord,code,description
filter: (type = 'rdm_roadmap') and (associatedObjectID = ROAD_MAP_ID)

The APP log shows:
ERROR 2023-05-05 13:27:15,153 [https-openssl-nio2-443-exec-22] rest.validation (clarity:user:session) ExceptionInfo :: Could not create resource. Resource name: scenarios. Error code: scenario.alreadyExistsMustCopy Error message: A scenario already exists for the associated object therefore only copies operation allowed.

Environment

Release : 16.1.1

Resolution

Run the following query to check if any scenarios do exist:
select * from ODF_SCENARIOS

If they do exist in the database table and takes time to load in the UI, then there is a database SQL execution plan issue.

The DBA team will need to review how the query is being executed and to find for it a better execution plan by running the database SQL tuning advisor.

 

Additional Information

Improved the KB including the Request pattern, it will help users to identify the request in browser console.