LinkedIn
Copied!

PEGA0040 alert: BLOB size written to the database exceeded a threshold

The PEGA0040 alert occurs when a PegaRULES database write operation saves a single Storage Stream BLOB (pzPVStream property value) that is larger in bytes than the threshold value. The write operation is not canceled. The alert indicates that memory performance of your system might be affected by large property values.

Example message text

The alert identifies the pzInsKey that was written and its size in bytes.

Wrote blob to database with compressed size 3158486 pzInsKey: RULE-FILE-BINARY HELPINDEX PXHELPINDEXBINARY!ZIP #20100215T113526.121 GMT

Default prconfig.xml settings

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

The enabled value is Boolean. To turn off the alert, change the value to "false".

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

The threshold value is a positive integer in megabytes (default is 3). This value is checked against the compressed size of the BLOB being written.

Stop and restart the server after changing these settings.

Reason for the alert

Examine the record being written (pzInsKey) and determine whether the entire BLOB is needed. Usually, you can redesign the application to divide the data into multiple, modular segments.

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.