How to detect when the number of declarative indexes exceed a threshold (PEGA0034 alert)

Alert log message

The PEGA0034 alert is generated when an instance is saved and the number of indexes — instances of a concrete class derived from the Index- base class through Declare Index rules — that are created as a result of the save operation exceeds a specified threshold.

Declarative indexes are useful as a way to quickly find work objects for reporting or other purposes. However, if your application creates a large number of index instances when a work object is saved, then the application is probably not properly configured, and system and database performance is impacted. 5.5

Here is an example of the alert log message:

Number of indexes written for instance RULE-OBJ-MODEL DATA-ADMIN-OPERATOR-ID PYDEFAULT #20081215T181157.704 GMT exceeded threshold of 100: 141

Modifying the alert settings

By default, the alert is enabled with a threshold of 100 indexes per saved instance. You can modify the setting in the prconfig.xml file as follows:

1. Open the prconfig.xml file and update this alerts section:

<env name = “alerts/database/indexesperinstance" value="100" />

2. Set the threshold value to a positive integer identifying the maximum number of indexes per saved instance.
3. Stop and restart the server.

Example

For an example, see Pega Developer Network article PRKB-25678 Understanding the PEGA0034 alert.

	alert log, prconfig.xml file
	Understanding alerts About Declare Index rules

SysAdmin category