Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Bulk process fails with error on screen



Developers are not able to perform bulk processes in Project Management Framework (PMF) version 7.2.1.

Error Messages

Status fail
Message There has been an issue; please consult your system administrator
Operator ID [Your_Operator_ID]
Requestor ID HE8260AD60C6A1DB4F065119C53F4089F

When traced, the following error is visible:

** One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: .SystemName. Revise the join conditions or optimize the property.

Steps to Reproduce

1) Open a backlog instance.
2) Select "Bulk process" from the "Settings" button.
3) Select any user story from the list.
4) From the actions menu select "Update BackLog".
5) Click "Submit".

Root Cause

This error occurs because the property "SystemName" which is used as a join criteria for a Report Definition that underlies the bulk process has not been optimized for reporting.


There are two possible solutions to this issue:

Solution A (best performance): Optimize the properties involved by using the option to "optimize property for reporting."

Solution B (alternate solution): Enable the system setting which allows the pzpvstream properties (unoptimized properties) to be used in join conditions:
Alternatively, one can create and set the following DSS to true.

​Note that this will allow you to run the report, but it will not perform as well when using unoptimized properties as it would if you optimize the properties. Optimizing properties for reporting is specifically so that the stream (the Pega BLOB) does not need to be extracted and decompressed when running reports.

Published August 23, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us