Status Report - Canvas - Adding Table for Cost Plan Details Not Showing Records

Products

• Clarity PPM On Premise

Issue/Introduction

Table widget on a canvas does not populate data when selected Target Object is: Financials - Cost Plan Details

Example: You have added canvas in an idea blueprint and unable to add the 'Financial - Cost Plan Details' in the table widget.
In the blueprint, you have enabled 'Financials - Cost Plan Details'

 

Steps To Reproduce:

1. Navigate to Status Module of a Project with Cost Plans
2. Click on 'Configure' button to display Widgets.
3. Add a Table Widget to the Canvas on the right hand side of the page 
4. Enter a Title for the Widget
5. In the Target Object Dropdown select 'Financials - Cost Plan Details'

Expected:  The Cost Plan Details of the POR-Cost Plans are displayed
Actual: The page remains blank and there is an error in the browser console,  "CNVE-004 : Invalid Source Reference."

Cause

There is an issue with widget reference id.

 

Resolution

Please contact the Support team for review.

--get associated_instance_id
SELECT * FROM NMC_CANVAS_AVAILABLE_ELEMENTS
WHERE 
associated_type = 'widget'
AND OBJECT_ALIAS = 'obaCostPlanDetails'

--get source_ref_id
SELECT 
b.canvas_id, b.SOURCE_TYPE, b.SOURCE_REF_ID,
a.id, a.name, a.ui_view_id, a.TYPE, a.TYPE_CODe, a.CREATED_BY, a.LAST_UPDATED_DATE
FROM 
ODF_CANVAS a,
ODF_CANVAS_ELEMENTS b
whERE a.id = b.CANVAS_ID 
AND a.type_code = 'cop_prj_statusrpt'
--AND b.canvas_id = xxxxxx
ORDER BY a.last_updated_date DESC

--get widget information to obtain the correct id/reference
select * from odf_visual_widgets

The Support team will then provide the resolution queries to run.