An Idea Instance Has Been Deleted From Clarity PPM but Still Appears in Jaspersoft Reports

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

An Idea instance has been deleted from Clarity PPM and it is no longer shown in the Idea List. The 'Delete Investments' job was run. However, it is still showing in some reports.

Resolution

Before trying these steps, and as a general best practice, make sure that you have taken all the necessary precautions to be able to roll back to an earlier state if necessary.

Please try the following steps:

1* Find the internal ID for the Idea instance that you are trying to delete. You can query the Clarity PPM schema, e.g.:

If you know that the external ID for that idea is 'ID1234':

SELECT ID, ODF_OBJECT_CODE, NAME, CODE FROM INV_INVESTMENTS WHERE ODF_OBJECT_CODE = 'idea' AND CODE = 'ID1234';

If you know that the name for that idea is 'Idea 1234':

SELECT ID, ODF_OBJECT_CODE, NAME, CODE FROM INV_INVESTMENTS WHERE ODF_OBJECT_CODE = 'idea' AND NAME LIKE 'Idea 1234';

Get the ID on the queries above, e.g.: 5000003.

2* Navigate to Home > Demand Management > Ideas.

3* Open any Idea instance

4* The URL for your idea should be something like:

http://<ppm-hostname>/niku/nu#action:pma.ideaProperties&return_to=pma.ideaList&id=5000001&ownerID=5000002

5* Check the URL, and replace the section "id=5000001&ownerID=5000002" with "id=5000003" (replace the ID number, and delete the "&ownerID=5xxxxxx" part).

http://<ppm-hostname>/niku/nu#action:pma.ideaProperties&return_to=pma.ideaList&id=5000003

6* Open the URL. Confirm that this opens the idea that you want to delete.

7* Now navigate again to Home > Demand Management > Ideas.

8* Select any inactive idea and then click "Mark for Deletion". DO NOT CONTINUE AND DO NOT CLICK 'YES' -- just copy the URL when you see the "ALERT: Do you want to delete the following Ideas?" message.

9* The URL should be something like the following.

http://<ppm-hostname>/niku/nu#action:projmgr.selectorActionConfirm&odf_obs_unit_id_list_add_option=selected_unit_only&is_active=0&odf_checkbox_control=is_required&portlet_context=Ideas&portlet_instance_id=pma.ideaList&odf_object_name=idea&page_pma.ideaList_collapse=false&objectCode=idea&componentId=pma&isErrorRequest=false&validationViewCode=null&return_action=pma.ideaList&selectorTable=inv_investments&selectorIDCol=ID&instanceCode=FILTER_pma.ideaList&objectCode=idea&componentId=pma&uitk.navigation.last.workspace.action=pma.ideaPropertiesCancel&uitk.navigation.parent.location=Workspace&superSecretTokenKey=superSecretTokenValue&isErrorRequest=true&yesAction=pma.ideaDelete&spaceID=pma.ideas&page_pma.ideaList_collapse=false&confirmMsg=pma.CONFIRM_DELETE_IDEAS&confirmTitle=pma.CONFIRM_DELETE_IDEAS_TITLE&selectorLabelCol=name&validationViewCode=null&buttonAction=3&confirmType=confirmDelete&noAction=pma.ideaList&relabel=true&gridCode=ideaList&gridCode=ideaList&filterGridCode=ideaList&componentCode=pma&selector=5000004

10* Look for the "selector=5000004" attribute and replace it with "selector=5000003", i.e.:

http://<ppm-hostname>/niku/nu#action:projmgr.selectorActionConfirm&odf_obs_unit_id_list_add_option=selected_unit_only&is_active=0&odf_checkbox_control=is_required&portlet_context=Ideas&portlet_instance_id=pma.ideaList&odf_object_name=idea&page_pma.ideaList_collapse=false&objectCode=idea&componentId=pma&isErrorRequest=false&validationViewCode=null&return_action=pma.ideaList&selectorTable=inv_investments&selectorIDCol=ID&instanceCode=FILTER_pma.ideaList&objectCode=idea&componentId=pma&uitk.navigation.last.workspace.action=pma.ideaPropertiesCancel&uitk.navigation.parent.location=Workspace&superSecretTokenKey=superSecretTokenValue&isErrorRequest=true&yesAction=pma.ideaDelete&spaceID=pma.ideas&page_pma.ideaList_collapse=false&confirmMsg=pma.CONFIRM_DELETE_IDEAS&confirmTitle=pma.CONFIRM_DELETE_IDEAS_TITLE&selectorLabelCol=name&validationViewCode=null&buttonAction=3&confirmType=confirmDelete&noAction=pma.ideaList&relabel=true&gridCode=ideaList&gridCode=ideaList&filterGridCode=ideaList&componentCode=pma&selector=5000003

11* Open the URL and confirm that the screen shown is "ALERT: Do you want to delete the following Ideas?" and that the idea that you would like to delete is shown in the alert dialog. If it is, click 'Yes' to delete.

12* Run the 'Delete Investments' job (understanding that it will not just delete the idea that was just marked for deletion, but also any other investment that has been marked for deletion).

13* Run these jobs in order:

• Load Data Warehouse (Full)
• Load Data Warehouse Access Rights

14* The idea should no longer appear in the report.