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.