When computing a snaphshot, a fatal error is encountered that stops the snapshot during the compute snapshot step with the message "Error while executing procedure" as shown in the screenshot below:
In the log messages, there will be the additional messages including:
ERROR: function xxx_com_local.dia_many_empfinalblk(integer, integer, integer, integer) does not exist
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
Below is the step-by-step scenario leading to the problem:
- Migrate to 8.X.
- Deliver and analyze code.
- Perform a snapshot.
The impact of the problem on the analysis or the dashboard is: No snapshot performed so no dashboard results.
This issue generally occurs due to migration issues with the assessment model in 8.X as the computing configuration is changed for this rule in 8.X.
To fix the problem, proceed as follows:
- Modify the assessment model for the quality rule 'Avoid empty finally blocks'.
- For this change in the computing settings tab the values shown in the screenshot below.
Basically, the metric should be set for "Computing Based on Scope and Property" instead of "Computing Based on SQL Procedures' in 8.X" with the proper values for scope and property (scope name value '602' and detail property value '140574').