Report Generator - Generate Reports with UI - Errors - Error occurred during web service requesting

This page handles the case when you get the error - "Error occurred during web service requesting" during generating report for a template as shown below

Figure 1

1. Configure RestAPI to connect to the proper imported Central Base.
2. Launch Report Generator.
3. Activate the Web Service URL.
4. Select the desired Application and Snapshot.
5. Try to generate report by selecting any template

1.  Check if there is missing entries from the table DSS_METRIC_DESCRIPTIONS, for this please run the following query on your central base:

   SELECT * 
   FROM   dss_metric_types r 
   WHERE  r.metric_id IN ( 68001, 68002, 68901, 68902 ) 

   Sample result:

   --68001;"Technical Debt";"Technical Debt estimates the cost to fix a pre-set percentage of high severity violations, of medium severity violations, and of low severity violations.";1;0;"";0;0;0
    --68002;"Technical Debt density";"Technical Debt density estimates the cost per thousand of lines of code to fix a pre-set percentage of high severity violations, of medium severity violations, and of low severity violations";1;0;"68001";0;0;0
   --68901;"Technical Debt of added Violations";"Technical Debt of added Violations estimates the part of the technical debt that was added in latest Snapshot on account of added violations.";1;99;"68001";0;0;0
   --68902;"Technical Debt of removed Violations";"Technical Debt of removed Violations estimates the part of the technical debt that was removed during the latest Snapshot on account of removed violations.";1;99;"68001";0;0;0

   If the query returns 4 rows then the issue is not due to corruption in DSS_METRIC_DESCRIPTIONS, you can got to the next step, else this confirms that the entries are missing in the table. To resolve this issue, please perform the below steps -

   1. Take a backup of your Central Base.
   2. Open Server Manager. 
   3. Run a component reinstall on your Central Base.
   4. Restart the web application.
   5. Re launch the Report Generator
      If this workaround do not resolve your issue then contact CAST Technical Support with Relevant input. 

2. Check if there are metrics in the Central base with no parent metric in DSS_METRIC_HISTO_TREE table, for this please run the following query on your central base:

   SELECT * 
   FROM   dss_metric_histo_tree 
   WHERE  metric_parent_id is null 

   Sample result:

   -- 4;null;200000;1;2;1;0

   If the query do not returns rows then this is not your case, go to the next step, else the issue occurs when a custom metric was defined badly (please refer to CMS - Configuring the Background Facts upload file for more information on how to define metrics). This issue has been fixed in 8.2.x, so upgrading to 8.2.x or above will resolve the issue.

3. If the above checks do not resolve your issue then contact CAST Technical Support with Relevant input .