There is an base system business rule named "Affected ci notifications" that may have a task or tasks that have a cmdb_ci record associated with it and a large number of parents.

The business rule creates a ci.affected event for the task_ci associated with the task and additional such events for its parent records in accordance with the nature of script. The larger the relationship between CIs, the greater volume of event creation.

The issue is that we cannot process through those events. The sudden event creation due to the business rule prevents other events from being processed in a timely manner. This can cause severe performance degradation and uses up all the db connections leading to a potential outage.

Steps to Reproduce

  1. Set the business rule Affected ci notifications to active.
  2. Create an incident record.
  3. Associate a task record with it.
  4. In the task record add a configuration item (cmdb_ci) record to it. The CI item can have, for example, 10 parents associated with it.
  5. Update the task.

The issue only occurs with large CMDB relationships and with relationships that might form circular relationships.


The Affected ci notifications business rule is enabled by default in the base system. If you are not using this functionality, disable the business rule.

Alternatively, examine the CI Relationships [cmdb_rel_ci] table for circular references and remove them.


Related Problem: PRB597787

Seen In

Berlin Patch 11
Berlin Patch 2
Calgary Patch 2 Hot Fix 5
Calgary Patch 4
Calgary Patch 7 Hot Fix 2
Dublin EA 8
Dublin EA 9
Dublin Patch 1
Dublin Patch 4
Dublin Patch 7 Hot Fix 2
Eureka Patch 1
Eureka Patch 1 Hot Fix 2
Eureka Patch 10
Eureka Patch 11
Eureka Patch 11 Hot Fix 2
Eureka Patch 13 Hot Fix 2
Eureka Patch 5
Eureka Patch 8
Fuji Patch 10
Fuji Patch 11
Fuji Patch 12 Hot Fix 1
Fuji Patch 2 Hot Fix 1
Fuji Patch 3
Fuji Patch 7 Hot Fix 5
Fuji Patch 8
Fuji Patch 9 Hot Fix 1
Geneva Patch 4
Geneva Patch 4 Hot Fix 6
June 2011 Patch 3 Hot Fix 11

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-11-14 02:14:09