Description

Some objects of technology ABAP are violating the quality rule Avoid using SQL queries inside a loop, but in dashboard violations are missing.

Observed in CAST AIP


Release
Yes/No
8.3.x (tick)
Observed on RDBMS
RDBMS
Yes/No
CSS (tick)
Step by Step Scenario

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

  1. Run the analysis.
  2. Take a snapshot.
Impact of the Problem

The impact of the problem on the analysis or the dashboard is:
Missing violations

Action Plan

Starting from AIP 8.0.1 we have remove ABAP from quality rule "Avoid using SQL queries inside a loop". The reason why we opted for this choice is:

When analyzing an ABAP application, 2 rules are violated when there is SQL query in a loop:

  1. Avoid Open SQL queries in loops, this quality rule is applied for all technologies and not specific to ABAP technology.
  2. Avoid using SQL queries inside a loop, this quality rule is applied only for ABAP technology.

This delivers redundant information to Dashboard consumers and impacts grades at Technical Criteria level. As a consequence, only one rule should be kept and if both are similar, then we prefer keeping the one for all technologies.

Notes/comments
Ticket # 5711
Related Pages