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 items for reporting or other purposes. However, if your application creates a large number of index instances when a work item 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.

As an alternative to the prconfig.xml file, you can use Dynamic System Settings to configure your application.
See How to create or update a prconfig setting.

Example

For an example, see PDN article Understanding the PEGA0034 alert.

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

SysAdmin category