How to detect when the size of a BLOB column read exceeds a threshold (PEGA0039 alert)

This alert is generated when a database query retrieves a BLOB (pzPVStream property value) that is larger (in bytes) than the threshold value. The alert provides a warning that memory performance of your system may be hurt when PRPC expands the BLOB onto a clipboard page.

In contrast to this alert, the similar PEGA0004 alert indicates the size of the entire result set of a query, that may or may not include a BLOB in the individual rows.

Alert log message

The alert identifies the pzInsKey that was read, and the size in bytes of the BLOB:

Read blob from database with compressed size 2058486 expanded size 4125916. pzInsKey: RULE-FILE-BINARY WEBWB OPENAUTHORING!CAB #20100304T152007.144 GMT

Modifying the alert settings

You can modify the default settings in the alerts section of the prconfig.xml file, as follows:

  1. Open the prconfig.xml file and update these alerts entries:
enabled

<env name = “alerts/database/blobsizeread/enabled" value="true" />

The enabled value is a boolean. To turn off the alert, "false"
threshold

<env name = “alerts/database/blobsizeread/threshold" value="3" />

The threshold value is a positive integer in megabytes (default is 3). This is checked against the compressed size of the BLOB being read.
  1. 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.

Next steps

Examine the record being read (identified by the pzInsKey value and determine if the entire BLOB is needed. Usually, you can break the data into additional logical segments (as dictated by your application). This alert is often related to PEGA0004 and PEGA0025 alerts.

Related PDN articles

Consult these PDN articles:

Definitions alert log, prconfig.xml file, storage stream, schema
Related topics Understanding alerts
How to detect when size of BLOB column written to the PegaRULES database exceeded a threshold (PEGA0040 alert)
How to detect when total BLOB column sizes in an a single HTTP interaction exceed a threshold (PEGA0004 alert)

UpSysAdmin category