Report Generator - Reports - Empty results - Action Plans table is not populated

This page gives solution to the problem where action plan table is not populated with any value after generating report as shown in the below screenshot.

Below is the step-by-step scenario leading to the problem:

1. Deploy RESTAPI and point it to Central Database.

2. Use Report generator to generate the report using latest 2 snapshots and template - 1- Powerpoint-components-library.pptx

3. Check that the Action Plan table is empty.

The impact of the problem on the analysis or the dashboard is: N/A

To fix the problem, proceed as follows:

1. Check if there are any items in VIEWER_ACTION_PLANS table having FIRST_SNAPSHOT_DATE = NULL by executing the below query on the Central database. 

   select distinct DMD.metric_description as Quality_Rule,DOBJ.object_full_name as Object_Full_Name, VAP.action_def as Description 
   from viewer_action_plans VAP, dss_metric_descriptions DMD, dss_objects DOBJ
   where VAP.object_id = DOBJ.object_id
   and VAP.metric_id = DMD.metric_id 
   and VAP.FIRST_SNAPSHOT_DATE is null

   Example -

   Query result example

   Quality_Rule	Object_Full_Name	Description
   Avoid throwing an exception of type Exception (C# .Net)	p1.ORDERS.ISSUE_VALUE	To be corrected
   Avoid throwing an exception of type Exception (C# .Net)	p1.ORDERS.ISSUE_RESULT	To be corrected
   Avoid throwing an exception of type Exception (C# .Net)	p1.ORDERS.ORDER_VALUE	To be corrected

   If the above query returns any rows then and save the results and take a backup of the Central Database. This should not happen if you are using CAST products to build your Action Plan.

2. Run the query on the Central Base to delete the inconsistent entries

   delete from VIEWER_ACTION_PLANS where FIRST_SNAPSHOT_DATE is null;

3. Re-generate report

4. You may add the violations for the Quality Rules identified in step 1 to the action plan if they are still relevant.

 Impact of the solution on the analysis or the dashboard is: N/A