Rule Definition
Recursive calls can be unpredictable with regard to consumption of resources, especially memory. Under certain condition, a function or procedure using a recursive call can keep calling itself and as each call consumes memory, the entire application runs out of memory. Recursive calls are known to be difficult to test for because the termination condition and thus the resource consumption might be dependent on the data used for the test. For all these reasons, it is often forbidden and limited to academic usage rather than for mission-critical systems. Because the flip side is complexity, such a trade-off should be carefully chosen by architects or senior developers, balancing cost with reliability and in all cases the conditions under which it is used should be reviewed in details. Triggers recursivity can be disabled by configuration of the database server (setting the Allow nested triggers option off).

Remediation
Review the design of the Triggers